Hi,
In my cobol-ims-db2 application program, I have a simple SELECT query. First value from input is moved to the keys in the query section. I'm getting the proper output. (SQLCODE =0).
After reading the second record from the file, key is moved perfectly. (I found out by giving display statements before the call). But I'm getting +100 row not found error. But actually I've the same row in the table.

This problem happens if WHENEVER I have any row in the second row.

I ran the program with single row in the input file. My program RAN FINE WITHOUT ANY ABEND. I tried to expedite the program. But no use.

Any suggestions??

Thanks,
Ranjini.S

Please post your cursor defintion and the sections in which you OPEN/FETCH/CLOSE the cursor.

To obtain values from the same row of your cursor, after the first fetch, don't FETCH a second time since that would (try to) get the second row which doesn't exist.

Ranjini, did I understand your problem correctly:

You have a file containing some keys.
You read the first record from the file and SELECT INTO data using the key in the WHERE clause which runs fine.
Then you read the second key from the file, again do the SELECT INTO using the new key and that select fails with SQLCODE +100 ?

You DISPLAYed the key to check, whether it was the correct one ?
The program runs fine if there is only one record in your file.