IBM Books

Call Level Interface Guide and Reference

Appendix E. SQLSTATE Cross Reference

This table is a cross-reference of all the SQLSTATEs listed in the Diagnostics section of each function description in Chapter 5, "DB2 CLI Functions".
Note:DB2 CLI may also return SQLSTATEs generated by the server that are not listed in this table. If the returned SQLSTATE is not listed here, refer to the documentation for the server for additional SQLSTATE information.

SQLState Cross Reference table

01000 (Warning.)


 


01002 (Disconnect error.)


 
   

01004 (Data truncated.)


 


01504 (The UPDATE or DELETE statement does not include a WHERE clause.)


 
   

01508 (Statement disqualified for blocking.)


 
   

01S00 (Invalid connection string attribute.)


 
   

01S01 (Error in row.)


 
   

01S02 (Option value changed.)


 
   

01S06 (Attempt to fetch before the result set returned the first rowset.)


 
   

01S07 (Fractional truncation.)


 
   

07001 (Wrong number of parameters.)


 
   

07002 (Too many columns.)


 
   

07005 (The statement did not return a result set.)


 
   

07006 (Invalid conversion.)


 


07009 (Invalid descriptor index)


 


08001 (Unable to connect to data source.)


 
   

08002 (Connection in use.)


 
   

08003 (Connection is closed.)


 

  • SQLTransact()

08004 (The application server rejected establishment of the connection.)


 
   

08007 (Connection failure during transaction.)


 
   

08S01 (Communication link failure.)


 


0F001 (The LOB token variable does not currently represent any value.)


 
   

21S01 (Insert value list does not match column list.)


 
   

21S02 (Degrees of derived table does not match column list.)


 
   

22001 (String data right truncation.)


 
   

22002 (Invalid output or indicator buffer specified.)


 
   

22003 (Numeric value out of range.)


 


22005 (Error in assignment.)


 
   

22007 (Invalid datetime format.)


 


22008 (Datetime field overflow.)


 


22011 (A substring error occurred.)


 
   

22012 (Division by zero is invalid.)


 
   

22015 (Interval field overflow)


 
   

22018 (Invalid character value for cast specification.)


 
   

22019 (Invalid escape character)


 
   

22025 (Invalid escape sequence)


 
   

22026 (String data, length mismatch)


 
   

23000 (Integrity constraint violation.)


 
   

24000 (Invalid cursor state.)


 


24504 (The cursor identified in the UPDATE, DELETE, SET, or GET statement is not positioned on a row.)


 
   

2500025501 (Invalid transaction state.)


 
   

25501 (Invalid transaction state.)


 
   

28000 (Invalid authorization specification.)


 
   

34000 (Invalid cursor name.)


 
   

37000 (Invalid SQL syntax.)


 
   

37xxx (Invalid SQL syntax.)


 
   

40001 (Serialization failure)


 


40003 (Statement completion unknown)


 
   

4000308S01 (Communication link failure.)


 


42000 (Syntax error or access violation)


 
   

42601 (PARMLIST syntax error.)


 
   

42818 (The operands of an operator or function are not compatible.)


 
   

42895 (The value of a host variable in the EXECUTE or OPEN statement cannot be used because of its data type.)


 
   

428A1 (Unable to access a file referenced by a host file variable.)


 
   

42xxx (Syntax Error or Access Rule Violation.)


 
   

44000 (Integrity constraint violation.)


 
   

54028 (The maximum number of concurrent LOB handles has been reached.)


 
   

56084 (LOB data is not supported in DRDA.)


 
   

58004 (Unexpected system failure.)


 


HY000 (General error.)


 


HY001 (Memory allocation failure.)


 


HY002 (Invalid column number.)


 
   

HY003 (Program type out of range.)


 


HY004 (SQL data type out of range.)


 
   

HY007 (Associated statement is not prepared.)


 
   

HY008 (Operation was cancelled)


 


HY009 (Invalid argument value.)


 


HY010 (Function sequence error.)


 


HY011 (Operation invalid at this time.)


 


HY012 (Invalid transaction code.)


 
   

HY013 (Unexpected memory handling error.)


 


HY014 (No more handles.)


 


HY016 (Cannot modify an implementation row descriptor.)


 
   

HY017 (Invalid use of an automatically allocated descriptor handle.)


 
   

HY018 (Server declined cancel request.)


 
   

HY021 (Inconsistent descriptor information.)


 


HY024 (Invalid attribute value.)


 
   

HY090 (Invalid string or buffer length.)


 


HY091 (Descriptor type out of range.)


 
   

HY092 (Option type out of range.)


 


HY093 (Invalid parameter number.)


 
   

HY094 (Invalid scale value.)


 
   

HY096 (Information type out of range.)


 
   

HY097 (Column type out of range.)


 
   

HY098 (Scope type out of range.)


 
   

HY099 (Nullable type out of range.)


 
   

HY100 (Uniqueness option type out of range.)


 
   

HY101 (Accuracy option type out of range.)


 
   

HY103 (Direction option out of range.)


 
   

HY104 (Invalid precision value.)


 
   

HY105 (Invalid parameter type.)


 
   

HY106 (Fetch type out of range.)


 
   

HY107 (Row value out of range.)


 
   

HY109 (Invalid cursor position.)


 
   

HY110 (Invalid driver completion.)


 
   

HY111 (Invalid bookmark value.)


 
   

HY501 (Invalid data source name.)


 
   

HY503 (Invalid file name length.)


 
   

HY506 (Error closing a file.)


 
   

HY509 (Error deleting a file.)


 
   

HYC00 (Driver not capable.)


 


HYT00 (Timeout expired.)


 


HYT01 (Connection timeout expired)


 
   

S0001 (Database object already exists.)


 
   

S0002 (Database object does not exist.)


 
   

S0011 (Index already exists.)


 
   

S0012 (Index not found.)


 
   

S0021 (Column already exists.)


 
   

S0022 (Column not found.)


 
   

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]