Loading

DB2: SQL States

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.