RE: QUICK Embedded SQL Question

["Fisher, Don" <Dfisher@xxxxxxxxxxxxxxxxx>]

I wondered about that after I sent my reply.  As far as I know, there's no
way to know whether there are records in the result set without executing a
FETCH.  The SQLCOD just tells you if an error was encountered during the
OPEN.

I'm not familiar enough with SQLSTATE to venture a guess.  the SQL Reference
or Programming manuals might have something.  The following two links are
for V4R1 and V5R2 (the only ones I have):
http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/QB3AQ900/CCONTENTS?SHELF
=QB3AYC00&DN=SC41-5612-00&DT=19970315145311

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/QB3AQ800/CCONTENTS?SHELF
=QB3AYC00&DN=SC41-5611-00&DT=19970315125430

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/db2/rbafzmst02.htm

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzajp/rzajpmst02.htm

Hope some of that helps. 

Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx

<clip>
Any idea of what that value will contain?  Seems to always be 0 even with no
records (when I run interactive SQL with the same data and statement). Maybe
SQLSTATE has something?
<clip>