If you have the Remote unit of work feature, the SQLSTATE value can provide
application programs with common codes for common error conditions that can
occur in any
of the DB2 family of database systems including DB2 Server for VSE.
An SQLSTATE field is returned in the SQLCA for all warnings and errors that
can be returned from executing SQL statements. The SQLCA contains both
an SQLCODE and a corresponding SQLSTATE value, if applicable. If,
however, you are running an SQL/DS Version 2 Release 2 or earlier database
that is connected to a DB2 Server for VSE Version 7 Release 1 user
machine, the DB2 Server for VSE system has no control of the SQLSTATE value
returned to you.
The application programs, when SQLSTATEs are fully implemented, can test
for classes of errors that are common to all products, or for specific errors
that are unique to a product.
SQLSTATE values are comprised of a two-character class code value, followed
by a three-character subclass code value. Class code values represent
classes of successful (class codes 00 and 01) and unsuccessful (all other
class codes) execution conditions.
Programmers who want to use SQLSTATE as the basis of their
application's return codes may define SQLCODE numbers above 32767,
SQLSTATE classes beginning with the characters '7' through
'9' or 'I' through 'Z' and subclasses for any
class beginning with the characters 'I' through
'Z'. These value ranges will not be used by IBM SQL or
ISO/ANSI.
IBM standardized diagnostic reporting across its various databases by
complying with the SQLSTATE mechanism proposed in the ISO/ANSI SQL2 the
(DIS 9075:199x(E) Database Language SQL2) draft a few years ago. However, the SQLSTATE values in the final
published version of SQL92 deviate in many ways from the scheme that SQL/DS
was planning to follow a few years ago. As a result, SQL/DS is
implementing those changes in Version 3 Release 5 to comply with SQL92.
The SQLSTATEs and their corresponding SQLCODEs are listed below. In
some cases, the SQLSTATE occurs when a particular situation caused the
SQLCODE, and these situations are also listed. For more information
about the corresponding SQLCODEs, a page number is provided with each
reference.
- SQLSTATE
- Meaning and SQLCODE
- 00000
- 0 on page *** for no warnings
- 0A001
- This SQLSTATE was formerly 51011.
The CONNECT statement is invalid, because the process is not in the
connectable state.
-
- -752 on page ***
- 0F001
- The locator value does not currently represent any value.
-
- -423 on page ***
- 0A501
- Security Failure
-
- -30080 on page ***
- 01003
- This SQLSTATE was formerly 01502.
Null values were eliminated from the argument of a column function.
-
- 0 on page *** for SQLWARN2=W
- 01004
- This SQLSTATE was formerly 01501.
The value of a string column was truncated when assigned to a host
variable.
-
- 0 on page *** for SQLWARN1=W
- 01501
- This SQLSTATE has been changed to 01004.
- 01502
- This SQLSTATE has been changed to 01003.
- 01503
- The number or result columns is larger than the number of host variables
provided.
-
- 0 on page *** for SQLWARN3=W
- 01504
- The UPDATE or DELETE statement does not include a WHERE clause.
-
- 0 on page *** for SQLWARN4=W
- 01506
- An adjustment was made to a DATE or TIMESTAMP value to correct an invalid
date resulting from an arithmetic operation.
-
- 0 on page *** for SQLWARN7=W
- 01507
- One or more non-zero digits were eliminated from the fractional part of a
number used as the operand of a multiply or divide operation.
-
- 0 on page *** for SQLWARN7=Z
- 01508
- The statement was disqualified for blocking for reasons other than
storage.
-
- 0 on page *** for SQLWARN8=W
- 01509
- Blocking was cancelled for a cursor, because there is insufficient storage
in the user virtual machine.
-
- 0 on page *** for SQLWARN9=W
- 01510
- Blocking was canceled for a cursor, because a blocking factor of at least
two rows could not be maintained.
-
- 0 on page *** for SQLWARNA=W
- 01511
- Performance may not be optimum because of the number of predicates
specified in the WHERE clause.
-
- 0 on page *** for SQLWARN5=W
- 01512
- The REVOKE operation has no effect on CONNECT privileges.
-
- +150 on page ***
- 01513
- A subsequent commit operation will revoke all EXECUTE privileges on the
package except for that of the owner.
-
- +200 on page ***
- 01515
- The null value has been assigned to a host variable, because the non-null
value of the column is not within the range of the host variable.
-
- +304 on page ***
- 01516
- An inapplicable WITH GRANT OPTION has been ignored.
-
- +558 on page ***
- 01517
- A character that could not be translated was replaced with a substitute
character.
-
- 0 on page *** for SQLWARN8=Z
- 01519
- The null value has been assigned to a host variable, because an arithmetic
exception occurred in computing the value of the column.
-
- +802 on page ***
- 01520
- The null value has been assigned to a host variable, because the
characters cannot be translated.
-
- +331 on page ***
- 01525
- The number of INSERT values is not the same as the number of
columns.
-
- +117 on page ***
- 01532
- An undefined object name was detected.
-
- +204 on page ***
- 01533
- An undefined column name was detected.
-
- +202 on page ***
-
- +205 on page ***
-
- +206 on page ***
- 01536
- During remote bind where existence checking is deferred, the server name
specified does not match the current server.
-
- +114 on page ***
- 01539
- Connection is successful, but only SBCS characters should be used.
-
- +863 on page ***
- 01541
- Operator command processing has completed successfully.
-
- +825 on page ***
- 01542
- Authorization ID does not have the privilege to perform the operation as
specified.
-
- +552 on page ***
- 01543
- A duplicate constraint has been ignored.
-
- +541 on page ***
- 01545
- An unqualified column name has been interpreted as a correlated
reference.
-
- +12 on page ***
- 01548
- Authorization ID does not have the privilege to perform the specified
operation on the identified object.
-
- +551 on page ***
- 01555
- Mixed data is invalid and has been truncated according to SBCS
rules.
-
- 0 on page *** for SQLWARN1=Z
- 01570
- The bind process detected a character string in an INSERT or UPDATE
statement that is too large for the target column.
-
- +404 on page ***
- 01571
- The bind process detected a numeric value that is out of range.
-
- +414 on page ***
- 01572
- The bind process detected an invalid datetime format; that is, an
invalid string representation or an invalid value.
-
- +180 on page ***
- 01573
- The bind process detected a null insert or update value is null for a
column that cannot contain null values.
-
- +407 on page ***
- 01574
- The bind process detected an INSERT, UPDATE, or DELETE that is not
permitted on this object.
-
- +149 on page ***
- 01575
- The bind process detected a non-updateable column in an INSERT or UPDATE
statement.
-
- +151 on page ***
- 01576
- The bind process detected a CREATE INDEX statement for a view.
-
- +154 on page ***
- 01577
- The bind process detected a CREATE VIEW statement that includes an
operator or operand that is not valid for views.
-
- +154 on page ***
- 01578
- The bind process detected operands of an operator that are not
compatible.
-
- +401 on page ***
- 01579
- The bind process detected a numeric constant that is either too long or
has a value that is not within the range of its data type.
-
- +405 on page ***
- 01580
- The bind process detected an update or insert value that is not compatible
with the column.
-
- +408 on page ***
- 01581
- The bind process detected incompatible operands of a UNION
operation.
-
- +415 on page ***
- 01582
- The bind process detected a string that is too long.
-
- +134 on page ***
-
- +416 on page ***
- 01583
- The bind process detected a decimal divide operation that is invalid
because the result would have a negative scale.
-
- +419 on page ***
- 01584
- The bind process detected an insert or update value of a long string
column that is neither a host variable or NULL.
-
- +135 on page ***
- 01585
- The bind process detected a table that cannot be accessed because it is
inactive.
-
- +668 on page ***
- 01609
- The procedure generated more than the maximum allowed number of result
sets. Only the first integer result sets have been returned to the
caller.
-
- +464 on page ***
- 01610
- One or more ad hoc results sets were returned from the procedure.
-
- +466 on page ***
- 01614
- There are fewer locations than the number of result sets.
-
- +494 on page ***
- 02000
- One of the following exceptions occurred:
- The result of the SELECT INTO statement or the subselect of the INSERT
statement was an empty table.
- The number of rows identified in the searched UPDATE or DELETE statement
was zero.
- The position of the cursor referenced in the FETCH statement was after the
last row of the result table.
-
- +100 on page ***
- 07001
- This SQLSTATE was formerly 53017.
The number of host variables is not the same as the number of parameter
markers.
-
- -313 on page ***
- 07002
- This SQLSTATE was formerly 51001.
An invalid call parameter list or control block was detected.
-
- -804 on page ***
- 07003
- This SQLSTATE was formerly 26504.
The statement identified in the EXECUTE is a select-statement, or it is not
in a prepared state.
-
- -160 on page *** for using EXECUTE
-
- -504 on page *** when statement not prepared
-
- -516 on page *** for EXECUTE
-
- -826 on page *** for reason code 4 and EXECUTE
- 07004
- This SQLSTATE was formerly 53017.
The statement contains parameter markers but the USING clause is not
specified.
-
- -313 on page ***
- 07005
- This SQLSTATE was formerly 26503.
The statement-name of the cursor identifies a prepared statement that
cannot be associated with a cursor.
-
- -512 on page ***
-
- -826 on page *** for reason code 3.
- 07006
- This SQLSTATE was formerly 22507.
An input host variable cannot be used because of its data type.
-
- -301 on page ***
- 07007
- This SQLSTATE was formerly 26506.
INTO DESCRIPTOR clause must be specified on an Extended EXECUTE against a
statement that was prepared via an Extended PREPARE - Single Row.
-
- -811 on page ***
- 08001
- Communication error occurred.
-
- -30080 on page ***
- 08003
- This SQLSTATE was formerly 51018.
An error has left the application in an unconnected state.
-
- -900 on page ***
- 08004
- The application server rejected establishment of the connection.
-
- -30060 on page ***
-
- -30061 on page ***
- 2D528
- A COMMIT WORK statement cannot be dynamically prepared or executed.
-
- -515 on page ***
- 2D529
- A ROLLBACK WORK statement cannot be dynamically prepared or
executed.
-
- -515 on page ***
- 21000
- The result of a SELECT INTO is a table of more than one row, or the result
of the subquery of a basic predicate is more than one value.
-
- -810 on page ***
- 21501
- A multiple-row INSERT into a self-referencing table is invalid.
- 21502
- A multiple-row UPDATE of a Primary Key is invalid.
-
- -534 on page ***
- 21504
- A multiple-row DELETE from a self-referencing table with a delete rule of
RESTRICT or SET NULL is invalid.
- 22001
- Character data, right truncation occurred; for example, an update or
insert value is a string that is too long for the column.
-
- -302 on page *** when character or graphic string is too long
-
- -304 on page *** when date or time value is too large for host variable
-
- -404 on page ***.
- 22002
- A null value or the absence of an indicator parameter was detected;
for example, the null value cannot be assigned to a host variable, because no
indicator variable is specified.
-
- -305 on page ***
- 22003
- A numeric value is out of range.
-
- -302 on page *** for numeric overflow or underflow
-
- -304 on page *** for numeric overflow or underflow
-
- -413 on page ***
-
- -425 on page ***
-
- -801 on page *** for arithmetic overflow and underflow
-
- -802 on page *** for arithmetic overflow and underflow.
- 22007
- An invalid datetime format was detected; that is, an invalid string
representation or an invalid value was specified.
-
- -180 on page ***
-
- -181 on page ***.
- 22008
- Datetime field overflow occurred; for example, an arithmetic
operation on a date or timestamp has a result that is not within the valid
range of dates, or a datetime value cannot be assigned to a host variable
because it is too small.
-
- -183 on page ***
- 22011
- A substring error occurred; for example, an argument of SUBSTR is out
of range.
-
- -171 on page *** when an argument of SUBSTR is out of range
- 22012
- Division by zero is invalid.
-
- -801 on page *** for division by zero
-
- -802 on page *** for division by zero.
- 22019
- The LIKE predicate has an invalid escape character.
-
- -131 on page ***
- 22021
- This SQLSTATE was formerly 22517 or 22518.
Character is not in the coded character set.
-
- -330 on page ***
-
- -331 on page ***
- 22024
- This SQLSTATE was formerly 22510.
A C NUL-terminated input host variable with length greater than 1, did not
contain a NUL.
-
- -302 on page ***
- 22025
- The LIKE predicate string pattern contains an invalid occurrence of an
escape character.
-
- -131 on page ***
- 22501
- The length control field of a variable length string is negative or
greater than the maximum.
-
- -311 on page ***
-
- -821 on page ***.
- 22502
- Miscellaneous data exceptions occurred; for example, a floating-point
NAN (not a number) or invalid data in a packed decimal field was
detected.
-
- -424 on page ***
-
- -801 on page *** for general errors
-
- -802 on page *** for general errors.
- 22504
- Mixed data value is improperly formed.
-
- -191 on page ***
- 22507
- This SQLSTATE has been changed to 07006.
- 22509
- This SQLSTATE has been changed to 42806.
- 22510
- This SQLSTATE has been changed to 22024.
- 22512
- A host variable in a predicate is invalid, because its indicator variable
is negative.
-
- -309 on page ***
- 22515
- This SQLSTATE has been changed to 23515.
- 22517
- This SQLSTATE has been changed to 22021.
- 22518
- This SQLSTATE has been changed to 22021.
- 22519
- The Primary or Foreign Key cannot be activated.
-
- -667 on page ***
- 22520
- This SQLSTATE has been changed to 23520.
- 22521
- The Foreign Key cannot be defined, because the Primary Key of the parent
table is inactive.
-
- -670 on page *** for reason code 1
- 22522
- CCSID value is not valid at all, not valid for the data type or subtype,
or not valid for the encoding scheme.
-
- -189 on page ***
- 22524
- A string conversion resulted in truncation.
-
- -334 on page ***
- 23501
- This SQLSTATE has been changed to 44000.
- 23502
- An insert or update value is null, but the column cannot contain null
values.
-
- -407 on page ***
- 23503
- The insert or update value of a foreign key is invalid.
-
- -530 on page ***
- 23504
- The operation is prevented by the RESTRICT update or delete rule.
-
- -532 on page ***
- 23505
- A violation of the constraint imposed by a unique index occurred.
-
- -803 on page ***
- 23507
- A violation of a constraint imposed by a field procedure occurred.
-
- -681 on page ***
- 23515
- This SQLSTATE was formerly 22515.
The unique index could not be created, because the table contains duplicate
values of the specified key.
-
- -603 on page ***
- 23520
- This SQLSTATE was formerly 22520.
The Foreign Key cannot be defined, because all of its values are not equal
to the primary key of the parent table.
-
- -670 on page *** for reason code 2
- 24501
- The identified cursor is not open.
-
- -160 on page *** for using FETCH
-
- -501 on page ***
-
- -507 on page ***.
- 24502
- The cursor identified in an OPEN statement is already open.
-
- -502 on page ***
- 24503
- The cursor identified in the PUT statement is a select cursor, or the
cursor identified in the FETCH statement is an insert cursor.
-
- -160 on page *** for using PUT
- 24504
- The cursor identified in the UPDATE or DELETE statement is not positioned
on a row.
-
- -508 on page ***
- 24505
- COMMIT is invalid, because blocking is in effect and an insert cursor is
open.
-
- -519 on page ***
- 24506
- The statement identified in the PREPARE is the select-statement of an open
cursor.
-
- -519 on page ***
- 24506
- The statement identified in the PREPARE is the select-statement of an open
cursor.
- 24516
- A cursor has already been assigned to a result set.
-
- -499 on page ***
- 25000
- Operation is invalid for the application execution enviro nment.
-
- -30090 on page ***
- 26501
- The statement identified does not exist.
-
- -516 on page *** for DESCRIBE or dynamic cursor operation
-
- -826 on page *** for reason code 1 and 2 DECLARE CURSOR, DESCRIBE, DROP
STATEMENT, and PREPARE (Filling empty section)
- 26503
- This SQLSTATE has been changed to 07005.
- 26504
- This SQLSTATE has been changed to 07003.
- 26505
- An extended EXECUTE, DECLARE CURSOR, or DESCRIBE has been issued against
an empty section.
-
- -504 on page *** when trying to execute a NULL section
- 26506
- This SQLSTATE has been changed to 07007.
- 26507
- An extended EXECUTE with an OUTPUT DESCRIPTOR has been issued against a
section that is not a Single Row SELECT.
-
- -826 on page *** for reason code 6
- 26508
- The statement identified in an extended PREPARE Single Row is not a
select-statement.
-
- -826 on page *** for reason code 5
- 28000
- This SQLSTATE was formerly 53056.
Authorization-name or password on CONNECT is missing or invalid.
-
- -564 on page ***
- 3C000
- This SQLSTATE was formerly 52013.
A duplicate cursor name was detected.
-
- -517 on page ***
- 34000
- This SQLSTATE was formerly 52008.
An undefined cursor name was detected.
-
- -504 on page *** when cursor name not declared
- 37501
- This SQLSTATE has been changed to 42601.
- 37502
- This SQLSTATE has been changed to 42602.
- 37503
- This SQLSTATE has been changed to 42603.
- 37504
- This SQLSTATE has been changed to 42604.
- 37505
- This SQLSTATE has been changed to 42605.
- 37506
- This SQLSTATE has been changed to 42606.
- 37507
- This SQLSTATE has been changed to 42607.
- 37509
- This SQLSTATE has been changed to 42609.
- 37510
- This SQLSTATE has been changed to 42610.
- 37511
- This SQLSTATE has been changed to 42611.
- 37514
- This SQLSTATE has been changed to 42614.
- 37515
- This SQLSTATE has been changed to 42615.
- 37517
- This SQLSTATE has been changed to 42617.
- 37518
- This SQLSTATE has been changed to 42618.
- 38003
- The statement is not allowed in a function or procedure.
-
- -751 on page ***
- 39002
- A null value is not allowed for an IN or INOUT argument when using the
SIMPLE CALL calling convention.
-
- -470 on page ***
- 39501
- An output argument value returned from a function or a procedure was too
long.
-
- -450 on page ***
- 40000
- This SQLSTATE has been changed to 40001.
- 40001
- This SQLSTATE was formerly 40000.
Deadlock or timeout with automatic rollback occurred.
-
- -911 on page ***
- 40003
- This SQLSTATE was formerly 58022.
A system error has caused the unit of work to be rolled back.
-
- -903 on page ***
-
- -933 on page *** for a for a system error.
- 40503
- PRIVATE dbspace is in use by another process.
-
- -710 on page ***
- 42501
- Authorization ID does not have the privilege to perform the specified
operation on the identified object.
-
- -551 on page ***
-
- -566 on page ***.
- 42502
- Authorization ID does not have the privilege to perform the operation as
specified.
-
- -552 on page ***
-
- -554 on page ***
-
- -555 on page ***
-
- -556 on page ***
-
- -606 on page ***
-
- -610 on page ***
-
- -708 on page ***.
- 42504
- A specified privilege cannot be revoked from a specified
authorization-name.
-
- -556 on page *** when revokee does not have privilege
-
- -558 on page ***.
- 42505
- Connection authorization failure occurred.
-
- -560 on page ***
-
- -561 on page ***
-
- -815 on page ***.
- 42506
- Owner authorization failure occurred.
-
- -30053 on page ***
- 42601
- This SQLSTATE was formerly 37501.
A character, token, or clause is invalid or missing.
-
- -104 on page *** for general errors
-
- -105 on page ***
-
- -106 on page *** for general errors
-
- -109 on page ***
-
- -110 on page ***
-
- -115 on page ***
-
- -128 on page ***
-
- -130 on page ***
-
- -159 on page ***
-
- -160 on page *** for using ALL, REFERENCE, STRUCTURE, COST, or PLAN
-
- -162 on page *** when the name is missing
-
- -524 on page ***
-
- -611 on page ***.
- 42602
- This SQLSTATE was formerly 37502.
An invalid character in a name has been detected.
-
- -162 on page *** when the name is incorrect
-
- -165 on page ***
-
- -210 on page ***.
- 42603
- This SQLSTATE was formerly 37503.
An unterminated string constant has been detected.
-
- -106 on page *** for an unterminated string constant
- 42604
- This SQLSTATE was formerly 37504.
An invalid numeric or string constant has been detected.
-
- -103 on page ***
-
- -164 on page ***
-
- -166 on page ***
-
- -170 on page ***.
- 42605
- This SQLSTATE was formerly 37505.
The number of arguments specified for a scalar function is invalid.
-
- -172 on page ***
- 42606
- This SQLSTATE was formerly 37506.
An invalid hexadecimal constant has been detected.
-
- -167 on page ***
- 42607
- This SQLSTATE was formerly 37507.
An invalid operand of a column function has been detected.
-
- -112 on page ***
-
- -409 on page ***.
- 42609
- This SQLSTATE was formerly 37509.
All operands of an operator or predicate are parameter markers.
-
- -417 on page ***
- 42610
- This SQLSTATE was formerly 37510.
An invalid use of parameter markers has been detected.
-
- -184 on page ***
-
- -418 on page ***.
- 42611
- This SQLSTATE was formerly 37511.
An invalid column definition has been detected.
-
- -604 on page ***
- 42612
- The statement string is an SQL statement that
is not acceptable in the context in which it is presented.
-
- -084 on page ***
-
- -836 on page ***
- 42614
- This SQLSTATE was formerly 37514.
Invalid duplication of keyword has been detected.
-
- -630 on page ***
- 42615
- This SQLSTATE was formerly 37515.
Invalid alternative has been detected.
-
- -168 on page ***
-
- -705 on page ***
- 42617
- This SQLSTATE was formerly 37517.
The statement string is blank or empty.
-
- -104 on page *** when statement string is empty or blank
- 42618
- This SQLSTATE was formerly 37518.
Host variable is not allowed.
-
- -163 on page ***
-
- -312 on page ***.
- 42622
- This SQLSTATE was formerly 54003.
A name or label is too long.
-
- -107 on page ***
-
- -108 on page ***
-
- -116 on page ***
-
- -162 on page *** when the name is too long.
- 42701
- This SQLSTATE was formerly 52001.
A duplicate column name in INSERT or UPDATE statement was detected.
-
- -121 on page ***
- 42702
- This SQLSTATE was formerly 52002.
A column reference is ambiguous because of duplicate names.
-
- -203 on page ***
-
- -209 on page ***
- 42703
- This SQLSTATE was formerly 52003.
An undefined column name was detected.
-
- -201 on page ***
-
- -202 on page ***
-
- -205 on page ***
-
- -666 on page ***.
- 42704
- This SQLSTATE was formerly 52004.
An undefined object or constraint name was detected.
-
- -204 on page *** for general errors
-
- -206 on page ***
-
- -608 on page ***
-
- -805 on page *** for a GRANT, REVOKE or DROP statement.
-
- -649 on page *** for a missing EXPLAIN table.
- 42705
- This SQLSTATE was formerly 52005.
An undefined server name was detected.
-
- -929 on page ***
- 42706
- This SQLSTATE was formerly 52006.
Column names in ORDER BY are invalid, because all columns of the result
table are unnamed.
-
- -207 on page ***
- 42707
- This SQLSTATE was formerly 52007.
Column name in ORDER BY does not identify a column of the result
table.
-
- -208 on page ***
- 42709
- This SQLSTATE was formerly 52009.
A duplicate column name in a PRIMARY or FOREIGN KEY clause was
detected.
-
- -537 on page ***
- 42710
- This SQLSTATE was formerly 52010.
A duplicate object name was detected.
-
- -601 on page ***
-
- -618 on page ***
-
- -644 on page ***.
- 42711
- This SQLSTATE was formerly 52011.
A duplicate column name in an object definition was detected.
-
- -612 on page ***
- 42712
- This SQLSTATE was formerly 52012.
A duplicate table designator in a FROM clause was detected.
-
- -211 on page ***
- 42719
- This SQLSTATE was formerly 52019.
The cursor referenced in the extended OPEN, FETCH, PUT, or CLOSE has not
been declared in the current unit of work.
-
- -518 on page ***
- 42724
- Unable to access an external program used for a user-defined function or a
procedure.
-
- -444 on page ***
- 42802
- This SQLSTATE was formerly 53002.
The number of insert values is not the same as the number of
columns.
-
- -117 on page ***
- 42803
- This SQLSTATE was formerly 53003.
A column reference in the SELECT or HAVING clause is invalid, because it is
not a grouping column or a column reference in the GROUP BY clause is
invalid.
-
- -119 on page ***
- 42805
- This SQLSTATE was formerly 53005.
An integer in the ORDER BY clause does not identify a column of the result
table.
-
- -125 on page ***
- 42806
- This SQLSTATE was formerly 22509.
A value cannot be assigned to a host variable, because the data types are
not compatible.
-
- -303 on page ***
- 42807
- This SQLSTATE was formerly 53007.
The INSERT, UPDATE, or DELETE is not permitted on this object.
-
- -149 on page ***
- 42808
- This SQLSTATE was formerly 53008.
A column identified in the INSERT or UPDATE statement is not
updateable.
-
- -151 on page ***
- 42809
- This SQLSTATE was formerly 53009.
The identified object is not the type of object to which the statement
applies.
-
- -154 on page *** for using CREATE INDEX on a view.
-
- -204 on page *** for DROP VIEW table or DROP TABLE view
-
- -657 on page ***
-
- -813 on page ***.
- 42810
- This SQLSTATE was formerly 53010.
A view is identified in a FOREIGN KEY clause.
-
- -157 on page *** for general errors
- 42811
- This SQLSTATE was formerly 53011.
The number of columns specified is not the same as the number of columns in
the SELECT clause.
-
- -158 on page ***
- 42813
- This SQLSTATE was formerly 53013.
WITH CHECK OPTION cannot be used for the specified view.
-
- -140 on page ***
- 42815
- This SQLSTATE was formerly 53015.
The data type, length, value, or CCSID of an operand is invalid.
-
- -171 on page *** for general errors
-
- -713 on page ***.
- 42816
- This SQLSTATE was formerly 53016.
An invalid use of a datetime value or duration in an expression has been
detected.
-
- -182 on page ***
-
- -187 on page ***.
- 42818
- This SQLSTATE was formerly 53018.
The operands of an operator are not compatible.
-
- -401 on page ***
- 42819
- This SQLSTATE was formerly 53019.
An operand of an arithmetic operation is not a number.
-
- -402 on page ***
- 42820
- This SQLSTATE was formerly 53020.
A numeric constant is too long, or it has a value that is not within the
range of its data type.
-
- -405 on page ***
- 42821
- This SQLSTATE was formerly 53021.
An update or insert value is not compatible with the column.
-
- -408 on page ***
- 42823
- This SQLSTATE was formerly 53023.
The SELECT clause of a subquery specifies multiple columns.
-
- -412 on page ***
- 42824
- This SQLSTATE was formerly 53024.
An operand of LIKE is not a string, or the first operand not a
column.
-
- -132 on page ***
-
- -414 on page ***.
- 42825
- This SQLSTATE was formerly 53025.
The operands of UNION do not have compatible columns.
-
- -415 on page ***
- 42826
- This SQLSTATE was formerly 53026.
The operands of UNION do not have the same number of columns.
-
- -422 on page *** for different number of items in select lists
- 42827
- This SQLSTATE was formerly 53027.
The table identified in the UPDATE or DELETE is not the same table
designated by the cursor.
-
- -509 on page ***
- 42828
- This SQLSTATE was formerly 53028.
The table designated by the cursor of the UPDATE or DELETE statement cannot
be modified, or the cursor is read-only.
-
- -510 on page ***
-
- -520 on page ***.
- 42829
- This SQLSTATE was formerly 53029.
FOR UPDATE OF is invalid, because the table designated by the cursor cannot
be modified.
-
- -126 on page ***
-
- -511 on page ***.
- 42830
- This SQLSTATE was formerly 53030.
The Foreign Key does not conform to the description of the Primary
Key.
-
- -538 on page ***
- 42831
- This SQLSTATE was formerly 53031.
A column of a Primary Key cannot allow null values.
-
- -542 on page ***
- 42832
- This SQLSTATE was formerly 53032.
The operation is not allowed on system objects.
-
- -609 on page ***
-
- -709 on page ***
-
- -814 on page ***
-
- -823 on page ***.
- 42834
- This SQLSTATE was formerly 53034.
SET NULL cannot be specified, because the Foreign Key does not allow null
values.
-
- -629 on page ***
- 42842
- This SQLSTATE was formerly 53042.
A column definition is invalid, because a specified option is inconsistent
with the column description.
-
- -683 on page ***
- 42852
- This SQLSTATE was formerly 53052.
Privileges specified in GRANT or REVOKE are invalid or inconsistent.
-
- -557 on page ***
- 42853
- This SQLSTATE was formerly 53053.
Both alternatives of an option were specified, or the same option was
specified more than once.
-
- -161 on page ***
- 42859
- This SQLSTATE was formerly 53059.
An extended PREPARE or DROP STATEMENT cannot be used to change a
non-modifiable package.
-
- -830 on page ***
- 42862
- This SQLSTATE was formerly 53062.
An extended dynamic statement cannot be executed against a non-extended
dynamic package.
-
- -827 on page ***
- 42867
- This SQLSTATE was formerly 53067.
Conflicting options have been specified.
-
- -160 on page *** for the inconsistent use of the NEW, CHECK, or ERROR clauses
- 42878
- An invalid function or procedure name was used with the EXTERNAL
keyword.
-
- -449 on page ***
- 42884
- No function or procedure was found with the specified name and compatible
arguments.
-
- -440 on page ***
- 42886
- The IN, OUT, or INOUT parameter attributes do not match.
-
- -469 on page ***
- 42888
- This SQLSTATE was formerly 55008.
The nominated parent table does not have a Primary Key.
-
- -539 on page ***
- 42889
- This SQLSTATE was formerly 55013.
The table already has a primary key.
-
- -656 on page ***
- 42893
- The object or constraint cannot be dropped, because other objects are
dependent on it.
-
- -478 on page ***
- 42895
- For static SQL, an input host variable cannot be used, because its data
type is not compatible with the parameter of a procedure or user-defined
function.
-
- -302 on page ***
- 42901
- This SQLSTATE was formerly 56001.
A column function does not include a column name.
-
- -111 on page ***
- 42902
- This SQLSTATE was formerly 56002.
The object of the INSERT, UPDATE, or DELETE is also identified in a FROM
clause.
-
- -118 on page ***
- 42903
- This SQLSTATE was formerly 56003.
A WHERE clause or SET clause includes an invalid reference such as a column
function.
-
- -120 on page ***
- 42905
- This SQLSTATE was formerly 56005.
DISTINCT is specified more than once in a subselect.
-
- -127 on page ***
- 42906
- This SQLSTATE was formerly 56006.
A column function in a subquery of a HAVING clause includes an expression
that applies an operator to a correlated reference.
-
- -133 on page ***
- 42907
- This SQLSTATE was formerly 56007.
The string is too long.
-
- -134 on page ***
-
- -416 on page ***.
- 42908
- This SQLSTATE was formerly 56008.
The statement does not include a required column list.
-
- -153 on page ***
- 42909
- This SQLSTATE was formerly 56009.
The CREATE VIEW includes an operator or operand that is not valid for
views.
-
- -154 on page *** for general errors
- 42911
- This SQLSTATE was formerly 56011.
A decimal divide operation is invalid, because the result would have a
negative scale.
-
- -419 on page ***
- 42912
- This SQLSTATE was formerly 56012.
A column cannot be updated, because it is not identified in the UPDATE
clause of the select-statement of the cursor.
-
- -503 on page ***
- 42913
- This SQLSTATE was formerly 56013.
An invalid UPDATE or DELETE WHERE CURRENT OF has been detected.
-
- -535 on page ***
- 42914
- This SQLSTATE was formerly 56014.
The DELETE is invalid, because a table referenced in a subquery can be
affected by the operation.
-
- -536 on page ***
- 42915
- This SQLSTATE was formerly 56015.
One or more invalid referential constraints have been detected.
-
- -632 on page ***
-
- -648 on page ***
- 42917
- This SQLSTATE was formerly 56017.
The object cannot be explicitly dropped.
-
- -669 on page ***
- 42932
- Program preparation
assumptions are incorrect.
-
- -30052 on page ***
- 42937
- This SQLSTATE was formerly 56037.
Parameter must not have a subtype of mixed.
-
- -192 on page ***
- 42939
- This SQLSTATE was formerly 56039.
The object cannot be created, because the specified qualifier (or an DB2
Server for VSE DBSPACE name that starts with SYS) is reserved for system
use.
-
- -550 on page ***
-
- -707 on page ***.
- 42943
- This SQLSTATE was formerly 56043.
The database manager has not committed package package-name because it is a
modifiable package and it contains no statements.
-
- -759 on page ***
- 42961
- This SQLSTATE was formerly 56061.
The server name specified does not match the current server.
-
- -114 on page ***
- 42969
- This SQLSTATE was formerly 56069.
The package was not created and the unit of work was rolled back because of
either an invalid section number or internal limitations.
-
- -917 on page ***
- 44000
- This SQLSTATE was formerly 23501.
The INSERT or UPDATE is not allowed, because a resulting row does not
satisfy the view definition.
-
- -141 on page ***
- 51001
- This SQLSTATE has been changed to 07002.
- 51002
- The package corresponding to an SQL statement execution request was not
found.
-
- -805 on page *** for any statement other than GRANT, REVOKE or DROP
- 51003
- Consistency tokens do not match.
-
- -818 on page ***
- 51004
- An address in the SQLDA is invalid.
-
- -935 on page ***
- 51007
- A CONNECT statement has not been executed.
-
- -563 on page ***
- 51010
- The programmable interface for operator commands is not valid when within
a unit of work.
-
- -825 on page ***
- 51011
- This SQLSTATE has been changed to 0A001.
- 51012
- Index has been marked invalid.
-
- -923 on page ***
- 51013
- An attempt has been made to use an index that has been marked as
invalid.
-
- -621 on page ***
- 51015
- An attempt was made to execute a section that was found to be in error at
bind time.
-
- -525 on page ***
- 51016
- A package or view cannot be rebound, because the character set under which
it was originally bound is different than the character set under which the
database manager is running.
-
- -833 on page ***
- 51018
- This SQLSTATE has been changed to 08003.
- 51021
- SQL statements cannot be executed until the application process executes a
rollback operation.
-
- -965 on page ***
- 51030
- The procedure referenced in a DESCRIBE PROCEDURE statement or an ALLOCATE
CURSOR statement has not yet been called within the application
process.
-
- -480 on page ***
-
- -482 on page ***
- 52001
- This SQLSTATE has been changed to 42701.
- 52002
- This SQLSTATE has been changed to 42702.
- 52003
- This SQLSTATE has been changed to 42703.
- 52004
- This SQLSTATE has been changed to 42704.
- 52005
- This SQLSTATE has been changed to 42705.
- 52006
- This SQLSTATE has been changed to 42706.
- 52007
- This SQLSTATE has been changed to 42707.
- 52008
- This SQLSTATE has been changed to 34000.
- 52009
- This SQLSTATE has been changed to 42709.
- 52010
- This SQLSTATE has been changed to 42710.
- 52011
- This SQLSTATE has been changed to 42711.
- 52012
- This SQLSTATE has been changed to 42712.
- 52013
- This SQLSTATE has been changed to 3C000.
- 52017
- This SQLSTATE has been changed to 08004.
- 52019
- This SQLSTATE has been changed to 42719.
- 53002
- This SQLSTATE has been changed to 42802.
- 53003
- This SQLSTATE has been changed to 42803.
- 53005
- This SQLSTATE has been changed to 42805.
- 53007
- This SQLSTATE has been changed to 42807.
- 53008
- This SQLSTATE has been changed to 42808.
- 53009
- This SQLSTATE has been changed to 42809.
- 53010
- This SQLSTATE has been changed to 42810.
- 53011
- This SQLSTATE has been changed to 42811.
- 53013
- This SQLSTATE has been changed to 42813.
- 53015
- This SQLSTATE has been changed to 42815.
- 53016
- This SQLSTATE has been changed to 42816.
- 53017
- This SQLSTATE has been changed to 07001 and 07004.
- 53018
- This SQLSTATE has been changed to 42818.
- 53019
- This SQLSTATE has been changed to 42819.
- 53020
- This SQLSTATE has been changed to 42820.
- 53021
- This SQLSTATE has been changed to 42821.
- 53023
- This SQLSTATE has been changed to 42823.
- 53024
- This SQLSTATE has been changed to 42824.
- 53025
- This SQLSTATE has been changed to 42825.
- 53026
- This SQLSTATE has been changed to 42826.
- 53027
- This SQLSTATE has been changed to 42827.
- 53028
- This SQLSTATE has been changed to 42828.
- 53029
- This SQLSTATE has been changed to 42829.
- 53030
- This SQLSTATE has been changed to 42830.
- 53031
- This SQLSTATE has been changed to 42831.
- 53032
- This SQLSTATE has been changed to 42832.
- 53034
- This SQLSTATE has been changed to 42834.
- 53042
- This SQLSTATE has been changed to 42842.
- 53043
- Columns with different field procedures cannot be compared.
-
- -686 on page ***
- 53044
- The columns have a field procedure, but the field types are not
compatible.
-
- -687 on page ***
- 53052
- This SQLSTATE has been changed to 42852.
- 53053
- This SQLSTATE has been changed to 42853.
- 53056
- This SQLSTATE has been changed to 28000.
- 53059
- This SQLSTATE has been changed to 42859.
- 53060
- Public dbspaces must be acquired from a recoverable storage pool.
-
- -706 on page ***
- 53062
- This SQLSTATE has been changed to 42862.
- 53067
- This SQLSTATE has been changed to 42867.
- 54001
- The statement is too long or too complex.
-
- -101 on page ***
- 54002
- A string constant is too long.
-
- -102 on page ***
- 54003
- This SQLSTATE has been changed to 42622.
- 54004
- The statement has too many table names or too many items in a SELECT or
INSERT list.
-
- -129 on page *** for too many table names or columns
- 54005
- The sort key is too long, or it has too many columns.
-
- -124 on page ***
- 54006
- The result of concatenation is too long.
-
- -137 on page ***
- 54008
- The key is too long, or it has too many columns.
-
- -614 on page ***
-
- -617 on page ***.
- 54011
- Too many columns were specified for a table or view.
-
- -602 on page ***
- 54012
- The FIELDPROC literal list is too long.
-
- -684 on page ***
- 54013
- The statement has too many host variables.
-
- -129 on page *** for too many variables or too many characters in variable
names
- 54014
- Too many cursors are open.
-
- -522 on page ***
- 54015
- Section was not created as a result of executing the null form of an
extended dynamic PREPARE or preprocessing a PREPARE statement.
-
- -523 on page ***
- 54016
- Too many tables were detected in a DBSPACE.
-
- -607 on page ***
- 54017
- The maximum number of active packages for a unit of work has been
exceeded.
-
- -807 on page ***
- 54018
- The row is too long.
-
- -809 on page ***
- 54019
- The maximum number of late descriptions has been exceeded, probably
because too many different CCSIDs were used.
-
- -129 on page ***
- 54020
- Too many indexes were detected for a table.
-
- -605 on page ***
- 55002
- The explanation table is not defined properly.
-
- -619 on page ***
- 55008
- This SQLSTATE has been changed to 42888.
- 55013
- This SQLSTATE has been changed to 42889.
- 55021
- Change of data type or length of host variable is invalid, because
blocking is in effect.
-
- -521 on page ***
- 55023
- An error occurred calling a procedure.
-
- -471 on page ***
-
- -928 on page
- 55044
- The PROCEDURE must have a status of STOP-REJ, or the PSERVER must be
stopped with IMPL=N, before it can be altered or dropped.
-
- -15000 on page ***
- 56001
- This SQLSTATE has been changed to 42901.
- 56002
- This SQLSTATE has been changed to 42902.
- 56003
- This SQLSTATE has been changed to 42903.
- 56004
- The statement failed, because the Invalid Entities table is full.
-
- -698 on page ***
- 56005
- This SQLSTATE has been changed to 42905.
- 56006
- This SQLSTATE has been changed to 42906.
- 56007
- This SQLSTATE has been changed to 42907.
- 56008
- This SQLSTATE has been changed to 42908.
- 56009
- This SQLSTATE has been changed to 42909.
- 56011
- This SQLSTATE has been changed to 42911.
- 56012
- This SQLSTATE has been changed to 42912.
- 56013
- This SQLSTATE has been changed to 42913.
- 56014
- This SQLSTATE has been changed to 42914.
- 56015
- This SQLSTATE has been changed to 42915.
- 56017
- This SQLSTATE has been changed to 42917.
- 56026
- This SQLSTATE has been changed to 25000.
- 56031
- The clause or scalar function is invalid, because mixed and graphic data
are not supported on this system.
-
- -640 on page ***
- 56032
- This SQLSTATE has been changed to 42932.
- 56033
- The insert or update value of a long string column must be a host variable
or NULL.
-
- -135 on page ***
- 56034
- ALLUSERS can only be used in GRANT CONNECT without a password.
-
- -562 on page ***
- 56035
- Referential constraints cannot cross DBSPACEs resident in different types
of storage pools.
-
- -714 on page ***
- 56037
- This SQLSTATE has been changed to 42937.
- 56038
- Requested feature is not supported in this environment.
-
- -947 on page ***
- 56039
- This SQLSTATE has been changed to 42939.
- 56042
- Only one package can be created or modified in a unit of work, and, while
that package is being created or modified, all statements in that unit of work
must be issued against that package. If the package is non-modifiable,
only Extended PREPARE statements can be issued.
-
- -565 on page ***
-
- -756 on page ***
-
- -757 on page ***
-
- -758 on page ***
-
- -832 on page ***.
- 56043
- This SQLSTATE has been changed to 42943.
- 56044
- An attempt was made to execute a section that has been marked as invalid
in a modifiable package that is undergoing modification.
-
- -760 on page ***
- 56046
- CREATE PACKAGE with the REPLACE option cannot be issued against a
modifiable package.
-
- -829 on page ***
- 56047
- PREPARE Adding Empty Section was not preceded by a CREATE PACKAGE with the
NOMODIFY option.
-
- -834 on page ***
- 56048
- Three part package name is not supported.
-
- -136 on page ***
- 56049
- An unexpected error occurred when attempting to rebind a view with a new
version of the database manager. The view must be dropped and
recreated.
-
- -835 on page ***
- 56058
- This SQLSTATE has been changed to 2D528 and 2D529.
- 56061
- This SQLSTATE has been changed to 42961.
- 56069
- This SQLSTATE has been changed to 42969.
- 56079
- Neither protocol option AUTO nor DRDA can be specified because the DRDA
facility has not been installed for the application requester.
-
- -861 on page
- 57008
- The date or time local format exit has not been installed.
-
- -185 on page ***
- 57010
- A field procedure could not be loaded.
-
- -682 on page ***
- 57011
- Virtual storage or database resource is not available.
-
- -674 on page ***
-
- -701 on page ***
-
- -702 on page ***
-
- -703 on page ***
-
- -704 on page ***
-
- -711 on page ***
-
- -712 on page ***
-
- -930 on page ***
-
- -932 on page *** when obtaining dynamic storage
-
- -940 on page *** when server-name resource is not available.
-
- -942 on page ***.
- 57012
- A non-database resource is not available. This will not affect
successful execution of subsequent statements.
-
- -30040 on page ***
- 57013
- A non-database resource is not available. This will affect the
successful execution of subsequent statements.
-
- -30041 on page
- 57014
- Processing was canceled as requested.
-
- -914 on page ***.
- 57016
- Table cannot be accessed, because it is inactive.
-
- -668 on page ***
- 57017
- Character conversion is not defined.
-
- -332 on page ***
- 57022
- Table could not be created, because the authorization ID of the statement
does not own any suitable dbspaces.
-
- -620 on page ***
- 57024
- No appropriate message repository can be accessed.
-
- -720 on page ***
-
- -721 on page ***.
- 57025
- There is not enough room in the dbspaces allocated to hold
packages.
-
- -945 on page ***
-
- -946 on page ***.
- 57026
- The system dbspace SYS002 does not exist. This dbspace is used to
store packages.
-
- -944 on page ***
- 57027
- Connection to the application server has been severed by the
operator.
-
- -916 on page ***
-
- -933 on page for operator action
- 57028
- Unit of work has been rolled back due to an excessive number of
system-wide lock requests.
-
- -912 on page ***
- 57029
- Unit of work has been rolled back due to an excessive number of lock
requests by the unit of work.
-
- -915 on page ***
- 57030
- Connection to the application server would exceed the installation-defined
limit.
-
- -933 on page *** when maximum number of connections exceeded
- 57033
- Deadlock or timeout occurred without automatic rollback.
-
- -913 on page ***
- 57037
- The ACQUIRE DBSPACE command failed, because all storage pools for
available
dbspaces are full.
-
- -699 on page ***
- 57038
- No space is
available in the storage pool.
-
- -700 on page ***
- 57039
- Online
support is ending.
-
- -937 on page ***
- 57040
- DBNAME
Directory error.
-
- -841 on page ***
- 57044
- Resource adapter cannot find file.
-
- -993 on page ***
- 57045
- The Resource Adapter cannot find an entry for the character set in the
file.
-
- -994 on page ***
- 58002
- An exit has returned an error or invalid data.
-
- -685 on page ***
-
- -688 on page ***
-
- -816 on page ***
- 58003
- An invalid section number was detected.
-
- -144 on page ***
- 58004
- A system error (that does not necessarily preclude the successful
execution of subsequent SQL statements) occurred.
-
- -753 on page ***
-
- -824 on page ***
-
- -901 on page ***
-
- -931 on page ***
-
- -932 on page *** when freeing dynamic storage
-
- -941 on page ***.
- 58005
- A system error (that prevents the successful execution of subsequent SQL
statements) occurred.
-
- -902 on page ***
-
- -754 on page ***
- 58009
- Execution failed due to a distribution protocol error that caused
deallocation of the conversation.
-
- -30020 on page ***
- 58010
- Execution failed due to a distribution protocol error that will affect the
successful execution of subsequent DDM commands or SQL statements.
-
- -30021 on page ***
- 58011
- The DDM command is invalid while the bind process in progress.
-
- -30050 on page ***
- 58012
- The bind process with the specified package name and consistency token is
not active.
-
- -30051 on page ***
- 58014
- The DDM command is not supported.
-
- -30070 on page ***
- 58015
- The DDM object is not supported.
-
- -30071 on page ***
- 58016
- The DDM parameter is not supported.
-
- -30072 on page
- 58017
- The DDM parameter value is not supported.
-
- -30073 on page ***
- 58018
- DDM reply message is not supported.
-
- -30074 on page ***
- 58019
- This SQLSTATE has been changed to 08001.
- 58021
- A system error occurred while loading a program or control block.
-
- -934 on page ***
- 58022
- This SQLSTATE has been changed to 40003.
- 58023
- System error has caused the current program to be canceled.
-
- -906 on page ***
- 58024
- An error occurred in the underlying operating system.
-
- -949 on page ***
- 58025
- A column in a catalog table has the wrong data type.
-
- -921 on page ***
- 58027
- The package was not created and the unit of work was rolled back due to an
earlier system error.
-
- -917 on page ***
- 58029
- An internal error has occurred while attempting to log user data.
-
- -754 on page ***