SQL States
The following table summarizes the potential SQL state 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 a Software AG technical representative.
07005 | Statement cursor name does not match any prepared statement. | Contact a Software AG technical representative.
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 a Software AG technical representative.
08002 | Connection already exists. | Verify connection parameters; retry; Contact a Software AG technical representative.
08003 | Connection does not exist. | Verify connection parameters; retry; Contact a Software AG technical representative.
08004 | DRDA AS (application server) rejected the connection request. | Verify connection parameters; retry; Contact a Software AG technical representative.
09000 | Triggered SQL statement failed. | Notify your DBA.
0A001 | Invalid CONNECT statement: process not in the connectable state. | Verify connection parameters; retry; Contact a Software AG technical representative.
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 a Software AG technical representative.
0A502 | Action/operation disabled. | Notify your DBA; Contact a Software AG technical representative.
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 a Software AG technical representative.
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 a Software AG technical representative.
24502 | The cursor is already open. | Contact a Software AG technical representative.
24504 | The cursor is not positioned on a row. | Contact a Software AG technical representative.
24506 | PREPARE failed: the target statement has an open cursor. | Contact a Software AG technical representative.
24514 | Cursor disabled by previous error. | Contact a Software AG technical representative.
24516 | Cursor already assigned. | Contact a Software AG technical representative.
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 a Software AG technical representative.
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 a Software AG technical representative.
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 a Software AG technical representative.
42883 | No function found with matching signature. | Notify your DBA; Contact a Software AG technical representative.
42884 | No function/procedure found which matched the name and/or arguments. | Notify your DBA; Contact a Software AG technical representative.
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 a Software AG technical representative.
51002 | Package not found. | Ask your DBA to BIND the CONNX SQL packages; retry; Contact a Software AG technical representative.
51003 | Package consistency tokens do not match. | Ask your DBA to BIND the CONNX SQL packages; retry; Contact a Software AG technical representative.
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 a Software AG technical representative.
51017 | User not logged on. | Retry logon; Contact a Software AG technical representative.
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 a Software AG technical representative.
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 a Software AG technical representative.
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 a Software AG technical representative.
56096 | Conflicting bind options; bind operation terminated. | Contact a Software AG technical representative.
56098 | Error during implicit rebind/prepare. | Contact a Software AG technical representative.
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 a Software AG technical representative.
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 a Software AG technical representative.
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 a Software AG technical representative.
58008 | Execution failed: distributed protocol error will not prevent successful execution of Distributed Data Management (DDM) commands or SQL statements. | Contact a Software AG technical representative.
58009 | Execution failed: distributed protocol error caused deallocation of the conversation. | Contact a Software AG technical representative.
58010 | Execution failed: distributed protocol error will affect successful execution of Distributed Data Management (DDM) commands or SQL statements. | Contact a Software AG technical representative.
58011 | The Distributed Data Management (DDM) command is invalid while the bind process in progress. | Contact a Software AG technical representative.
58012 | The bind process with the specified package name and consistency token is not active. | Contact a Software AG technical representative.
58014 | The Distributed Data Management (DDM) command is not supported. | Contact a Software AG technical representative.
58015 | The Distributed Data Management (DDM) object is not supported. | Contact a Software AG technical representative.
58016 | The Distributed Data Management (DDM) parameter is not supported. | Contact a Software AG technical representative.
58017 | The Distributed Data Management (DDM) parameter value is not supported. | Contact a Software AG technical representative.
58018 | The Distributed Data Management (DDM) reply message is not supported. | Contact a Software AG technical representative.
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 a Software AG technical representative.