RE: embedded sql

This will work fine for a single record fetch but it won't work if you do a 
blocked fetch.  For a blocked fetch you will need to check SQLER5 for the value 
of 100 to determine end of file and SQLERR3 for the number or records returned.

SQLSTT = 2000 tells you that the fetch didn't return any records.  For a single 
record fetch it is the same as end of file.  For a blocked fetch however, 
SQLSTT could equal '00000' but you could have reached the end of the file.  In 
this case SQLER3 contains the number of records returned and SQLER5 indicates 
if the end of file has been reached (value of 100).

Rick

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Matt.Haas@xxxxxxxxxxx
Sent: Wednesday, October 26, 2005 10:28 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: embedded sql


You need to check either SQLSTT for 02000 or SQLCOD for 100. Generally
speaking, you want to process records while the first two characters of
SQLCOD are either '00' (success) or '01' (warning). You'll need to check
the SQLCOD and SQLSTT reference in the InfoCenter to see if you want to
ignore the warnings or not.

Matt


Privileged and Confidential.  This e-mail, and any attachments there to, is 
intended only for use by the addressee(s) named herein and may contain 
privileged or confidential information.  If you have received this e-mail in 
error, please notify me immediately by a return e-mail and delete this e-mail.  
You are hereby notified that any dissemination, distribution or copying of this 
e-mail and/or any attachments thereto, is strictly prohibited.