|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
