MVSFORUMS.com

[badri5]

I am stuck up with the logic of a cursor.

Select a from table a

If sqlcode = 0 from table a---( i have to use declare,fetch and close .ie from fetch sqlcode = 0) i am selecting b from table b--i am selecting many records

Then

select b from table b

If sqlcode = 0



where will i close the cursor

[dbzTHEdinosauer]

[badri5]

Select a from table a

where b = : b
And c = 'F'

If SQLCODE = 0----(I have to check sqlcode = 0 for fetch.But lastly close cursor will come.it will close cursor for and checking sqlcode = 0)without closing the cursor i can't go to the next select.how will i handle this

Select a
From table b
Where a = from input file
And b = 'F'
and c = 'E'

[kolusu]

badri5,

if you are reading the file and selecting the values from the table then you close the cursor just before you read your next key from the file

I suggest you read these two topics

http://www.mvsforums.com/helpboards/viewtopic.php?p=51990#51990

http://www.mvsforums.com/helpboards/viewtopic.php?p=51678#51678

Kolusu