This table summarizes potential SQL States error and informational messages that can be returned to CONNX by a DB2 target server.
|
State |
Error Message Text |
Recommended Action |
|
00000 |
SQL statement execution successful. |
Informational: No action required. |
|
01002 |
Disconnect error. |
Informational: No action required. |
|
01003 |
Null values removed from column function argument(s). |
Informational: No action required. |
|
01004 |
The host variable string value was truncated. |
Informational: No action required. |
|
01503 |
The result column count is greater than the number of host variables. |
Informational: No action required. |
|
01504 |
UPDATE or DELETE without a WHERE clause. |
Informational: No action required. |
|
01506 |
An arithmetic error in the date portion of a DATE or TIMESTAMP was corrected. |
Informational: No action required. |
|
01509 |
Cursor blocking disabled due to insufficient storage. |
If this message recurs, notify your DBA. |
|
01515 |
Null value has been assigned to a host variable. |
Informational: No action required. |
|
01517 |
Substitute character used for a character which could not be converted. |
Informational: No action required. |
|
01519 |
Numeric value out of range: null value assigned to host variable. |
Informational: No action required. |
|
01520 |
Host variable cannot be assigned a string value. |
Revise SQL statement to assign a compatible data type to the host variable. |
|
01524 |
Column function result omits null arithmetic values. |
Informational: No action required. |
|
01526 |
Isolation level escalated. |
Informational: No action required. |
|
01539 |
Connection successful; use only single byte character set (SBCS) characters. |
Informational: No action required. |
|
01543 |
Duplicate constraint ignored. |
Informational: No action required. |
|
01545 |
A one-part column name was processed as a correlated reference. |
Informational: No action required. |
|
01550 |
The index create failed because the index already exists. |
Informational: No action required. |
|
01564 |
Division by zero: null value assigned to a host variable. |
Revise SQL statement and retry as required. |
|
01589 |
Redundant statement specifications ignored. |
Informational: No action required. |
|
01595 |
Invalidated view definition replaced. |
Informational: No action required. |
|
01596 |
Long string data type-based comparison functions were not created. |
Informational: No action required. |
|
01599 |
Bind/REBIND options ignored. |
Informational: No action required. |
|
01602 |
Optimization level reduced. |
Informational: No action required. |
|
01604 |
SQL statement explained. |
Informational: No action required. |
|
01607 |
Read-only transaction time exceeds the defined threshold. |
Notify your DBA. |
|
01609 |
Stored procedure returned too many result sets. |
Informational: No action required. |
|
01610 |
Stored procedure returned ad-hoc result set(s). |
Informational: No action required. |
|
01611 |
Previously closed cursor reopened on the next result set. |
Informational: No action required. |
|
01615 |
Bind option ignored. |
Informational: No action required. |
|
01616 |
CPU resource limit exceeded. |
Resubmit SQL request; notify your DBA if this message recurs. |
|
01622 |
System error after successful statement completion. |
Informational: No action required. |
|
01632 |
Number of entitled concurrent connections exceeded. |
Notify your DBA. |
|
02000 |
End of result set. |
Informational: No action required. |
|
07001 |
Host variable count is not equal to number of parameter markers. |
Revise SQL statement and/or bound parameters and retry. |
|
07002 |
Invalid parameter list or control block. |
Revise SQL statement and/or bound parameters and retry. |
|
07003 |
An EXECUTE of a SELECT failed, or the statement is not in prepared state, |
Contact CONNX Tech Support. |
|
07005 |
Statement cursor name does not match any prepared statement. |
Contact CONNX Tech Support. |
|
07006 |
Input host variable unused due to invalid data type. |
Revise SQL statement and/or bound parameters and retry. |
|
08001 |
DRDA AR (application requester) could not connect to the target. |
Verify connection parameters; retry; contact CONNX Tech Support. |
|
08002 |
Connection already exists. |
Verify connection parameters; retry; contact CONNX Tech Support. |
|
08003 |
Connection does not exist. |
Verify connection parameters; retry; contact CONNX Tech Support. |
|
08004 |
DRDA AS (application server) rejected the connection request. |
Verify connection parameters; retry; contact CONNX Tech Support. |
|
09000 |
Triggered SQL statement failed. |
Notify your DBA. |
|
0A001 |
Invalid CONNECT statement: process not in the connectable state. |
Verify connection parameters; retry; Contact CONNX Tech Support. |
|
|
|
|
|
0A501 |
The connect attempt failed because the DRDA application server security mechanism is not supported by the DRDA application requester (CONNX for DB2). |
Verify connection parameters; retry; contact CONNX Tech Support. |
|
0A502 |
Action/operation disabled. |
Notify your DBA; contact CONNX Tech Support. |
|
21000 |
Result contains more than one row or subquery result contains more than one value. |
Revise SQL statement and retry. |
|
21501 |
Invalid multi-row INSERT into self-referencing table. |
Revise SQL statement and retry. |
|
21502 |
Invalid multi-row UPDATE of a primary key. |
Revise SQL statement and retry. |
|
21504 |
Invalid multi-row DELETE. |
Revise SQL statement and retry. |
|
21505 |
Row function must not return multiple rows. |
Revise SQL statement and retry. |
|
22001 |
Character data was truncated. |
Revise SQL statement and retry. |
|
22003 |
Numeric value out of range. |
Revise numeric value and retry. |
|
22007 |
Invalid datetime format. |
Correct datetime literal or parameter marker value and retry. |
|
22008 |
Datetime field overflow. |
Revise datetime arithmetic function or expression and retry. |
|
22011 |
Substring error. |
Revise SUBSTR function and retry. |
|
22012 |
Division by zero. |
Revise DIVIDE syntax and retry. |
|
22018 |
Invalid scalar function character value. |
Correct character literal and retry. |
|
22019 |
Invalid escape character in LIKE predicate. |
Correct escape character and retry. |
|
22021 |
A character is undefined for the coded character set. |
Remove character from host variable or character literal and retry. |
|
22024 |
Input host variable or parameter did not contain a NUL terminator. |
Resubmit with NULL-terminated host variable. |
|
22025 |
Invalid escape character in LIKE predicate. |
Correct escape character and retry. |
|
22501 |
Invalid variable string length. |
Truncate string and retry. |
|
22502 |
Arithmetic exception error occurred. |
Revise arithmetic expression and retry. |
|
22506 |
Datetime special register reference is invalid. |
Remove reference to special register and retry. |
|
22522 |
Invalid CCSID value. |
Contact CONNX Tech Support. |
|
23001 |
A RESTRICT UPDATE/DELETE rule prevented the UPDATE/DELETE of a parent key. |
Revise SQL statement and retry. |
|
23502 |
Attempt to INSERT/UPDATE NULL into a non-null column. |
Remove NULL values from INSERT/UPDATE statement and retry. |
|
23503 |
Invalid value for foreign key INSERT/UPDATE. |
Revise INSERT/UPDATE values and retry. |
|
23504 |
A NO ACTION UPDATE/DELETE rule prevented a parent key UPDATE/DELETE. |
Revise UPDATE/DELETE and retry. |
|
23505 |
Unique index/constraint violation. |
Revise INSERT/UPDATE and retry. |
|
23511 |
A check constraint prevented the deletion of a parent row. |
Revise DELETE statement and retry. |
|
23512 |
A check constraint add failed: one or more base table rows conflict. |
Revise INSERT statement and retry. |
|
23513 |
A check constraint prevented an INSERT/UPDATE. |
Revise INSERT/UPDATE and retry. |
|
23515 |
Create of unique index/constraint failed because of duplicate key values in base table. |
Revise CREATE INDEX/CONSTRAINT statement or delete duplicate key values from base table. |
|
24501 |
The cursor is not open. |
Contact CONNX Tech Support. |
|
24502 |
The cursor is already open. |
Contact CONNX Tech Support. |
|
24504 |
The cursor is not positioned on a row. |
Contact CONNX Tech Support. |
|
24506 |
PREPARE failed: the target statement has an open cursor. |
Contact CONNX Tech Support. |
|
24514 |
Cursor disabled by previous error. |
Contact CONNX Tech Support. |
|
24516 |
Cursor already assigned. |
Contact CONNX Tech Support. |
|
25000 |
Update operation invalid for read-only connection |
Connect in read/write mode and retry. |
|
25501 |
This statement can only begin a unit of work. |
End the current unit of work with a COMMIT/ROLLBACK and retry. |
|
26501 |
Statement is invalid or missing. |
Revise SQL statement and retry. |
|
28000 |
Invalid authorization (user) name. |
Re-enter user name in correct case and retry. |
|
2D521 |
COMMIT/ROLLBACK invalid for this environment. |
Probable cause: transaction logging/journalling is not active. |
|
2D528 |
Dynamic COMMIT invalid for this environment. |
Probable cause: transaction logging/journalling is not active. |
|
2D529 |
Dynamic ROLLBACK invalid for this environment. |
Probable cause: transaction logging/journalling is not active. |
|
34000 |
Invalid cursor name. |
Revise SQL syntax and retry; contact CONNX Tech Support. |
|
38001 |
External function is not allowed to execute SQL. |
Notify your DBA. |
|
38002 |
External function not defined as MODIFIES SQL DATA. |
Notify your DBA. |
|
38003 |
Statement not permitted in a function/procedure. |
Notify your DBA. |
|
38004 |
External function not defined as READS SQL DATA. |
Notify your DBA. |
|
38501 |
Error occurred during call to a function, procedure, or trigger. |
Retry; notify your DBA; contact CONNX Tech Support. |
|
38502 |
The external function is not allowed to execute SQL statements. |
Notify your DBA. |
|
38503 |
User-defined function abnormally terminated. |
Notify your DBA. |
|
38504 |
User-defined function interrupted by the user. |
Notify your DBA. |
|
38552 |
A function in the IBM SYSFUN schema has abnormally terminated. |
Notify your DBA. |
|
39001 |
Invalid SQLSTATE returned from a user-defined function. |
Notify your DBA. |
|
39004 |
Null value invalid for IN / INOUT argument. |
Revise SQL statement and/or parameters and retry. |
|
40001 |
Deadlock / timeout occurred with automatic rollback. |
Retry; notify your DBA. |
|
40003 |
Statement completion is unknown. |
Retry; notify your DBA. |
|
40504 |
Unit of work rolled back due to a system error. |
Retry; notify your DBA. |
|
40506 |
Current transaction rolled back due to an SQL error. |
Revise SQL statement; retry. |
|
42501 |
Your user ID does not have the privilege to perform the specified operation on the identified object. |
Request the necessary privilege from your DBA. |
|
42502 |
You are not authorized to perform the specified operation. |
Request the necessary privilege from your DBA. |
|
42505 |
The application server failed to authenticate the end user during connection processing. |
Verify userid/password and retry. |
|
42509 |
SQL statement not authorized due to STATICRULES option. |
Notify your DBA. |
|
42601 |
Invalid/missing character, token, or clause. |
Revise SQL syntax and retry. |
|
42602 |
Invalid character detected in a name. |
Revise SQL name and retry. |
|
42603 |
Unterminated string constant. |
Revise SQL string constant and retry. |
|
42604 |
Invalid numeric or string constant. |
Revise constant and retry. |
|
42605 |
Invalid number of scalar function arguments. |
Revise SQL syntax and retry. |
|
42606 |
Invalid hexadecimal constant. |
Revise SQL syntax and retry. |
|
42607 |
Invalid column function operand. |
Revise SQL syntax and retry. |
|
42608 |
Invalid use of NULL or DEFAULT in VALUES clause. |
Revise VALUES clause SQL syntax and retry. |
|
42609 |
All operands are parameter markers. |
Revise SQL syntax and retry. |
|
42610 |
Parameter marker not allowed. |
Revise SQL syntax and retry. |
|
42611 |
Invalid column/argument definition. |
Revise SQL syntax and retry. |
|
42612 |
SQL statement is not acceptable in the current context. |
Revise SQL syntax and retry. |
|
42613 |
Mutually exclusive clauses. |
Remove one or more clauses and retry. |
|
42614 |
Duplicate keyword. |
Remove duplicate keyword and retry. |
|
42615 |
Invalid alternative. |
Revise SQL syntax and retry. |
|
42617 |
Blank or empty SQL statement. |
Revise SQL syntax and retry. |
|
42618 |
Host variable not allowed. |
Revise SQL syntax and retry. |
|
42622 |
Name/label is too long. |
Revise SQL name/label and retry. |
|
42701 |
Duplicate column name in INSERT/UPDATE. |
Revise SQL syntax and retry. |
|
42702 |
Duplicate or ambiguous column reference. |
Revise SQL syntax and retry. |
|
42703 |
Undefined column, attribute, or parameter name. |
Revise SQL syntax and retry. |
|
42704 |
Undefined object or constraint name. |
Revise SQL syntax and retry. |
|
42707 |
Column name in ORDER BY is not in the SELECT clause. |
Add column name to SELECT, or remove it from the ORDER BY; retry. |
|
42710 |
Duplicate object or constraint name. |
Revise CREATE TABLE/INDEX name and retry. |
|
42711 |
Duplicate column/attribute name in object definition or ALTER statement. |
Revise CREATE TABLE/INDEX column name and retry. |
|
42712 |
Duplicate table designator in the FROM clause. |
Revise SQL syntax and retry. |
|
42713 |
Duplicate object in object list. |
Revise SQL syntax and retry. |
|
42723 |
Duplicate function signature exists in the schema. |
Revise CREATE PROCEDURE syntax and retry. |
|
42724 |
Unable to access an external program. |
Verify program/procedure name; retry; notify your DBA. |
|
42727 |
No default primary tablespace exists for the new table. |
Notify your DBA. |
|
42728 |
Duplicate node in the nodegroup. |
Notify your DBA. |
|
42729 |
Undefined node. |
Notify your DBA. |
|
42730 |
Container name in use by another tablespace. |
Notify your DBA. |
|
42731 |
Container name in use by this tablespace. |
Notify your DBA. |
|
42742 |
Subtable/view already exists in the typed table/view hierarchy. |
Revise CREATE TABLE/VIEW syntax and retry. |
|
42802 |
Number of INSERT/UPDATE values does not match the number of columns. |
Revise VALUES clause and retry. |
|
42803 |
Invalid column reference in SELECT/HAVING clause. |
Revise SELECT/HAVING; retry. |
|
42805 |
An integer in the ORDER BY clause does not map to a result column. |
Correct ORDER BY integer; retry. |
|
42806 |
Invalid host variable assignment: incompatible data types. |
Revise host variable to compatible data type; retry. |
|
42807 |
INSERT/UPDATE/DELETE not permitted on this object. |
Request privilege from your DBA. |
|
42808 |
Column in the INSERT/UPDATE statement is not updateable. |
Remove column from statement; retry. |
|
42809 |
Statement cannot be applied to/executed on the identified object. |
No action required. |
|
42811 |
Number of columns does not match the number of columns in the SELECT. |
Correct SQL syntax; retry. |
|
42815 |
Invalid data type, length, scale, value, or CCSID. |
Correct SQL syntax; retry. |
|
42816 |
Invalid datetime value or duration. |
Correct datetime literal; retry. |
|
42818 |
Incompatible operator/function operands. |
Correct SQL syntax; retry. |
|
42819 |
Non-numeric operand in arithmetic operation or function. |
Correct operand; retry. |
|
42820 |
Invalid numeric constant. |
Correct constant; retry. |
|
42821 |
UPDATE/INSERT value is incompatible with the target column. |
Revise UPDATE/INSERT VALUE to a compatible data type; retry. |
|
42823 |
Subquery SELECT clause contains multiple columns. |
Rewrite subquery to contain 1 column; retry. |
|
42824 |
LIKE operand is not a character string. |
Revise operand; retry. |
|
42827 |
The target table of the UPDATE/DELETE does not match the target table of the WHERE CURRENT OF cursor. |
Revise SELECT statement to point to target table. |
|
42828 |
The target table of the UPDATE/DELETE WHERE CURRENT OF statement is read-only, or the cursor is read-only. |
Revise SELECT statement to include FOR UPDATE OF; request read/write access to target table. |
|
42829 |
FOR UPDATE OF is invalid, because the cursor result table is read-only. |
Revise SELECT statement to include FOR UPDATE OF. |
|
42832 |
This operation is not permitted on system objects. |
Remove system object(s) from SQL statement; retry. |
|
42854 |
Data type mismatch between a select list result column and a typed view or summary table. |
Revise SELECT column list; retry. |
|
42877 |
Column name must be unqualified. |
Revise SQL column name syntax; retry. |
|
42878 |
Invalid EXTERNAL function/procedure name. |
Revise SQL syntax; retry. |
|
42882 |
Specific instance qualifier must match the function name qualifier. |
Notify your DBA; contact CONNX Tech Support. |
|
42883 |
No function found with matching signature. |
Notify your DBA; contact CONNX Tech Support. |
|
42884 |
No function/procedure found which matched the name and/or arguments. |
Notify your DBA; contact CONNX Tech Support. |
|
42889 |
Target table already has a primary key. |
Revise CREATE syntax; retry. |
|
42893 |
Object/constraint not dropped: dependent objects exist. |
Notify your DBA. |
|
42895 |
Input host variable data type does not match the parameter of a procedure or user-defined function. |
Revise parameter value and/or type; retry. |
|
42901 |
Column function does not include column name. |
Revise SQL syntax; retry. |
|
42903 |
Invalid reference in a WHERE / SET clause. |
Revise SQL syntax; retry. |
|
42907 |
String is too long. |
Revise string constant; retry. |
|
42908 |
Required column list not included in SQL statement. |
Revise SQL SELECT column list; retry. |
|
42911 |
Invalid decimal divide: result scale is negative. |
Revise DIVIDE syntax; retry. |
|
42912 |
Cannot update column: it is not in the FOR UPDATE OF clause of the SELECT statement. |
Add column to FOR UPDATE OF clause; retry. |
|
42917 |
Cannot explicitly drop object. |
Notify your DBA. |
|
42939 |
Cannot create object: identifier reserved for system use. |
Revise CREATE syntax and object name; retry. |
|
42969 |
Package not created and current unit of work rolled back due to internal limitations or invalid section number. |
Contact CONNX Tech Support. |
|
51002 |
Package not found. |
Ask your DBA to BIND the CONNX SQL packages; retry; contact CONNX Tech Support. |
|
51003 |
Package consistency tokens do not match. |
Ask your DBA to BIND the CONNX SQL packages; retry; contact CONNX Tech Support. |
|
51005 |
Function disabled by previous system error. |
Notify your DBA. |
|
51015 |
Attempt to execute an SQL package section which returned a bind time error. |
Contact CONNX Tech Support. |
|
51017 |
User not logged on. |
Retry logon; contact CONNX Tech Support. |
|
51021 |
Cannot execute SQL statements until application executes a rollback. |
Execute rollback; retry. |
|
51028 |
SQL package marked inoperative; cannot be used. |
Ask your DBA to BIND the CONNX SQL packages; retry; contact CONNX Tech Support. |
|
54001 |
Statement too long or complex. |
Simplify SQL statement; retry. |
|
54002 |
String constant too long. |
Truncate string constant; retry. |
|
54004 |
Too many table names / items in SELECT / INSERT. |
Revise SQL syntax; retry. |
|
54006 |
Concatenation result too long. |
Revise concatenation operands; retry. |
|
54008 |
Key too long or has too many columns. |
Revise CREATE TABLE/INDEX syntax; retry. |
|
54010 |
Table record length too long. |
Revise CREATE TABLE/INDEX syntax; retry. |
|
54011 |
Too many columns specified for table / view. |
Revise CREATE TABLE/INDEX syntax; retry. |
|
54032 |
Maximum table size has been reached. |
Notify your DBA. |
|
54047 |
Exceeded maximum table space size. |
Notify your DBA. |
|
54048 |
Temporary table space with sufficient page size does not exist. |
Notify your DBA. |
|
55001 |
Database must be migrated. |
Notify your DBA. |
|
55002 |
Explanation table not defined properly. |
Notify your DBA. |
|
55006 |
Cannot drop object: currently in use by the same application process. |
Revise application logic; retry; contact CONNX Tech Support |
|
55019 |
Table is in an invalid state for the operation. |
Table is not logged/journalled; retry with No Commit isolation level or ask your DBA to start logging/journalling for the table. |
|
55025 |
Database must be restarted. |
Notify your DBA. |
|
55039 |
Access / state transition not allowed: tablespace not in an appropriate state. |
Notify your DBA. |
|
56033 |
Insert / update long string column value must be a host variable or NULL. |
Revise SQL syntax to use a parameter marker. |
|
56084 |
DRDA does not support LOB data. |
Contact CONNX Tech Support. |
|
56092 |
Cannot determine authorization type: authorization name is both a user id and group id. |
Notify your DBA. |
|
56095 |
Invalid bind option; bind operation terminated. |
Contact CONNX Tech Support. |
|
56096 |
Conflicting bind options; bind operation terminated. |
Contact CONNX Tech Support. |
|
56098 |
Error during implicit rebind/prepare. |
Contact CONNX Tech Support. |
|
56099 |
Target database does not support REAL data type. |
Revise SQL syntax; retry. |
|
57001 |
Table is unavailable: no primary index defined. |
Notify your DBA. |
|
57007 |
Cannot use object: DROP / ALTER pending. |
Retry; notify your DBA. |
|
57009 |
Virtual storage / resource temporarily unavailable. |
Retry; notify your DBA. |
|
57011 |
Virtual storage / resource unavailable. |
Retry; notify your DBA. |
|
57012 |
Non-database resource unavailable; SQL statements can be successfully executed. |
Retry; notify your DBA. |
|
57013 |
Non-database resource unavailable; SQL statements cannot be successfully executed. |
Retry; notify your DBA. |
|
57014 |
Processing canceled as requested. |
No action required. |
|
57016 |
Table is inactive: it cannot be accessed. |
Retry; notify your DBA. |
|
57017 |
Character conversion undefined. |
Contact CONNX Tech Support. |
|
57019 |
The statement was unsuccessful, because of a problem with a resource. |
Retry; notify your DBA. |
|
57022 |
Table could not be created: statement authorization ID does not own any suitable dbspaces. |
Notify your DBA. |
|
57030 |
Connection attempt to application server exceeds the installation-defined limit. |
Notify your DBA. |
|
57033 |
Deadlock / timeout without automatic rollback. |
Retry; notify your DBA. |
|
57046 |
Cannot start new transaction: database or instance is quiesced. |
Notify your DBA. |
|
57047 |
Cannot create an internal database file: the directory is not accessible. |
Notify your DBA. |
|
57049 |
Operating system process limit reached. |
Notify your DBA. |
|
57051 |
CPU cost estimate exceeds resource limit. |
Notify your DBA. |
|
57055 |
Temporary table space with sufficient page size unavailable. |
Notify your DBA. |
|
57056 |
Package unavailable: database is in NO PACKAGE LOCK mode. |
Notify your DBA. |
|
57057 |
A prior condition in a DRDA chain of SQL statements prevented execution of the SQL statement. |
Contact CONNX Tech Support. |
|
58004 |
System error occurred: SQL statements can be successfully executed. |
No action required. |
|
58005 |
System error occurred: SQL statements cannot be successfully executed. |
Notify your DBA; contact CONNX Tech Support. |
|
58008 |
Execution failed: distributed protocol error will not prevent successful execution of Distributed Data Management (DDM) commands or SQL statements. |
Contact CONNX Tech Support. |
|
58009 |
Execution failed: distributed protocol error caused deallocation of the conversation. |
Contact CONNX Tech Support. |
|
58010 |
Execution failed: distributed protocol error will affect successful execution of Distributed Data Management (DDM) commands or SQL statements. |
Contact CONNX Tech Support. |
|
58011 |
The Distributed Data Management (DDM) command is invalid while the bind process in progress. |
Contact CONNX Tech Support. |
|
58012 |
The bind process with the specified package name and consistency token is not active. |
Contact CONNX Tech Support. |
|
58014 |
The Distributed Data Management (DDM) command is not supported. |
Contact CONNX Tech Support. |
|
58015 |
The Distributed Data Management (DDM) object is not supported. |
Contact CONNX Tech Support. |
|
58016 |
The Distributed Data Management (DDM) parameter is not supported. |
Contact CONNX Tech Support. |
|
58017 |
The Distributed Data Management (DDM) parameter value is not supported. |
Contact CONNX Tech Support. |
|
58018 |
The Distributed Data Management (DDM) reply message is not supported. |
Contact CONNX Tech Support. |
|
58023 |
System error: current program has been canceled. |
Notify your DBA. |
|
58028 |
Commit requested, but the unit of work was rolled back. |
Notify your DBA. |
|
58030 |
I/O error occurred. |
Notify your DBA. |
|
58031 |
System error: connection unsuccessful. |
Notify your DBA; contact CONNX Tech Support. |