iSeries / AS400 FAQ : (Category) Programming : (Category) SQL : Where can I look up SQLCOD and SQLSTATE values?
Q. Where can I look up SQLCOD and SQLSTATE values? A. The Infocenter has the SQL manuals online. For V5R3: http://publib.boulder.ibm.com/pubs/html/as400/infocenter.html Choose your region and language, then Database (on the left). On the right, choose Database Information Finder. On the right, under SQL Quick Reference, choose SQL messages and codes, then click the Go button to its right. For V5R2, Choose Database on the left, then in the SQL Quick Reference on the right choose SQLCODES and SQLSTATES That should take you to http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzala/rzalamst02.html Alternately, the V5R2 Database, Reference, SQL message finder topic has a way for you to directly enter the SQLCODE or SQLSTATE you want to find out about. If you prefer hard copy, choose the Printable PDFs topic on the left, then Database, list of all books. From there, http://publib.boulder.ibm.com/iseries/v5r2/ic2924/info/rzahf/rzahfli0.htm, you can see the HTML and PDF versions of the S
Related Questions
- iSeries / AS400 FAQ : (Category) Programming : (Category) SQL : Where can I look up SQLCOD and SQLSTATE values?
- iSeries / AS400 FAQ : (Category) Programming : (Category) SQL : How do I access a specific member with SQL?
- iSeries / AS400 FAQ : (Category) Programming : (Category) SQL : Can I use SQL in a CL program?
