Home > IT Answers > SQL Server > SQLCODE and SQLSTAT error messages?
Vince01
25 pts.
 SQLCODE and SQLSTAT error messages?
SQL error messages, SQLCODES, SQLSTAT
Does anyone know where I can find SQLCODE and SQLSTAT error numbers and messages?

Software/Hardware used:
ASKED: January 22, 2009  2:27 PM
UPDATED: February 19, 2009  3:30 PM
RELATED QUESTIONS
Answer Wiki:
You didn't specify what database you are using. In Oracle, SQLCODE is a function that returns the number of the associated <b>Oracle</b> error (of the most recent exception). For Orcle, have a look at: <a href="http://download.oracle.com/docs/cd/B12037_01/appdev.101/b10807/13_elems049.htm">Oracle SQLCODE Function</a> For iSeries: <a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzala/rzalaco.htm">SQLCODE and SQLSTATE concepts</a> <a href="http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/rzala/rzalafinder.htm">SQL message finder</a>
Last Wiki Answer Submitted:  January 22, 2009  8:22 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Sorry, I am using the iSeries. Thank you for the answer. It was what I was looking for.

Vince01
 25 pts.