I have a situation where, at least f/now, it seems best to CURSOR into one
table, then, f/ea record, CURSOR into another table f/matching records.  My
problem is managing SQLCODE values.  Is it possible to use something other
than ...

WHILE SQLCODE <> 100 THEN
...
ENDWHILE

That is, could I set a variable equal to SQLCODE at the appropriate points,
such as after a FETCH, and test that variable?

Thanks,
Steve in Memphis

================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/

Reply via email to