SQL Cursor Closing Without Issuing CLOSE

[Guest.Visitor]

On occasion in our nightly batch processing our applications will encounter an SQL -501 on a FETCH statement. Conditional logic is specified to only attempt a FETCH if the OPEN received a 0 error code. The high-level language we are using is COBOL. Are there any reasons why an SQL cursor inside COBOL would close without issuing a CLOSE statement?

[Guest.Visitor]

I encountered the same problem before. I found out that data types of my FETCH variables differ from the data types of the file I am selecting. Try checking this thing.....

[Guest.Visitor]

My only experience with COBOL/DB2 is in Pig-Iron mainframes, but how are you handling end of file?

[Guest.Visitor]

By monitoring for SQLCODE = 100