DB2 error codes (SQLSTATE) 1

[RicMtl]

My stored proc is returning a SQLSTATE of 01003. I have tried to find a list of the codes and their meaning but I have not been successfull. Is there such a list? Alternatively, does anyone know the meaning of 01003?

Regards,

Ric

 

[MarcLodge]

Hi Ric,

Try here:

http://www-rohan.sdsu.edu/doc/oracle/server803/A54660_01/appd.htm

Hope this helps,

Marc

 

[MarcLodge]

Ric,
I've just noted that the link I gave previously appears to be on an Oracle/SQL Server page.

I'm not sure what your platform is, so this link might help too:

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzala/rzalastc.html

or you can also find SQLSTATE descriptions by using a DB2 command line processor, if you have DB2 UDB installed:

To open the command line processor, select Start --> Program --> DB2 --> Command Line Processor.
On the command line, type ? [SQLSTATE].

 

[juliane26]

I:\>db2 ? 01003

SQLSTATE 01003: Null values were eliminated from the argument of a column
function.

anyway, you can find SQL States here:
for z/OS:

http://publib.boulder.ibm.com/cgi-bin/bookmgr/BOOKS/DSNC1J10/CCONTENTS

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2.doc.mc/bjnmoic16.htm

other:

http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/core/r0sttmsg.htm

and the internal return codes in case of real problems:

http://www-1.ibm.com/support/docvie...uid=swg21066178&loc=en_US&cs=utf-8&lang=en+en

Juliane