RE: SQLCOD equivalent for %ERROR on file exceptions

["Haas, Matt" <Matt.Haas@xxxxxxxxxxxxxxxxxxx>]

Dan,

Negative SQLCOD's are always an error and positive codes are warnings and 
informational messages. The Information Center for V5R1 has a link to them in 
the Database section.

To test for end of file, you should check for SQLCOD = 100. 100 = no records.

Better yet would be to check SQLSTT which is much more detailed and also cross 
platform if that makes any difference.

Matt

-----Original Message-----
From: Dan [mailto:dbcerpg@xxxxxxxxx]
Sent: Tuesday, February 18, 2003 4:50 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SQLCOD equivalent for %ERROR on file exceptions


What is the equivalent of %ERROR for file exceptions occurring in SQL?  This is 
an SQLRPGLE
program.  The existing code I am working with tests SQLCOD <> 0 to determine 
"end of file".  Is
there a minimum SQLCOD value that indicates a file exception?  Or some other 
SQLCA subfield?

TIA, Dan

__________________________________________________
Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day
http://shopping.yahoo.com
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.