SQL Error code

[micjohnson]

Hi there!


Can anyone tell me that where can i get the complete list of SQL Error code ?.

Thanx in advance.
Johnson Susai

 

[2742]

Hi There

You can find a complete list of error messages from the online help or you can buy the book as well. You can find it in the

DB2 folder - > infomation - > DB2 online books - > choose administration -> choose Message Reference They are all there

I hope this helps

 

[RCPD700]

You can find a list of SQL Return Codes in the DB2 Reference Summary (SX26-3824-nn). You can also get message text for negative SQL codes in your application by calling routine DSNTIAR.

Hope this helps,
Jim

 

[Techspec1]

I recommend having the Message Code Redbook (depending on your version 5.x, 6.1, or 7.x). You can find the books in PDF format online at

http://www.redbooks.ibm.com.

I also recommend the IBM Tech Support Online help. The search page is

http://www-4.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/techlib.d2w/report.

Bookmark the site, it makes looking up errors and tech tips fast. You can also selectively set your list of support sources.

 

[micjohnson]

Hi Techspec1!

Useful reply. Thanx lot

Johnson Susai