1) i am using a db2 cursor in the program and in first section i have opened the cursor , and then perfoming another section to fetch the records till sqlcode=100
The question is
2) when we open the cursor will it positioned to the first record which matches the condition
3 ) If the table is empty or no records matching the condition then will it throw the sqlcode 100 while opening the cursor.....
when we open the cursor will it positioned to the first record which matches the condition
what I was suppposed to ask is ...we wil be having the select query in the cursor definition so if we open the cursor what actoin happens ..
i thought that if there is any records matches the condition in the query the cursor will
point to that particular record and then from there it will move to the next records based on the condition ...