SQL CODES |
EXPLANATION |
-136 |
Sort Cannot be executed because the Sort Key Length is greater than 1000 bytes. |
-137 |
Result of Concatenation too long |
-138 |
The second or third Argument of the SUBSTR Function is out of Range. |
-150 |
The Object of the Insert, Delete or Update Statement is a view for which the requested operation is not permitted. |
-151 |
The Column < Column-Name > cannot be updated because it is either included in the partitioning key of a Partitioned TableSpace or derived from a SQL Function or Expression. |
-153 |
The Create View Statement does not include a required Column List. |
-154 |
The Create View Failed because the View Definition contains a union or union all. |
-156 |
The Alter Table, Drop Table, Lock Table, or Create Index Statement identifies a View. |
-158 |
The Number of Columns specified for the View is not the same as the number of columns specified by the Select Clause. |
-159 |
The Name specified on the Drop View is a Table Name |
-160 |
The WITH CHECK Option cannot be used for the Specified View. |
-161 |
The Insert or Update is not allowed because a resulting row does not satisfy the new definition. |
-164 |
It does not have the Privilege to Create the View with Qualification. |
-170 |
The number of arguments specified for Function-name is invalid. |
-171 |
The Data Type, Length, Value of Argument of Function-name is Invalid |
-172 |
Function-Name is not a Valid Function-Name. |
-180 |
The String Representation of a DATETIME value has an invalid Syntax. |
-181 |
The String Representation of DATETIME value is not a valid Value. |
-182 |
An Arithmetic Expression with a DATETIME value is Invalid. |
-183 |
An Arithmetic Operation on a Date or Timestamp as a result that is not within the valid range of Dates. |
-184 |
An Argument expression with a Date Time Value contains a Parameter marker. |
-185 |
The Local format Option has been used with a Date or Time and no Local Exit has been installed. |
-186 |
The Local date length of Local Time Length has been increased and executing Program relies on the Old Length. |
-198 |
The Operand of the Prepare or Execute Immediate Statement is Blank or Empty. |
-199 |
Illegal use of KEYWORD Keyword. Token Token-list was expected . |
-203 |
A Reference to Column Column-Name is ambiguous. |
-204 |
NAME is an undefined Name. |
-205 |
COLUMN-NAME is not a Column of Table TABLE-NAME. |
-206 |
COLUMN-NAME is not a Column of a Inserted Table, Update Table, or any Table identified in a FROM Clause. |
-207 |
The ORDER BY Clause is Invalid because it includes a Column Name but it applies to the Result of a UNION or UNION ALL. |
-208 |
The ORDER BY Clause is invalid because Column Name is not part of the Result Table. |
-219 |
The Required Explanation Table TABLE-NAME does not exist. |
-220 |
The Column COLUMN-NAME in Explanation Table TABLE-NAME is not defined Properly. |
-301 |
The Value of a host variable cannot be used as specified because of its Data Type. |
-302 |
The Value of an Input Variable is too large for the target Column. |
-303 |
A value cannot be assigned to a Host Variable because the Data types are not Compatible. |
-304 |
The Value with Data Type DATA-TYPE1 cannot be assigned to a Host Variable because the Value is not within the Range of the Host Variable in Position POSITION-NUMBER with Data-type DATA-TYPE2. |
-305 |
The Null Value cannot be assigned to a Host Variable because no Indicator Variable is specified. |
-309 |
A Predicate is Invalid because a Referenced Host Variable has the Null Value. |
-311 |
The indicated length of a Host Variable is negative. |
-312 |
Undefined or Unusable Host Variable VARIABLE-NAME. |
-313 |
The number of Host Variables specified is not equal to the number of Parameter Markers. |
-401 |
The Operands of an Arithmetic or Comparison Operation are not Comparable. |
-402 |
An Arithmetic Function or Operator ARITH-FOP is applied to Character or DATETIME Data. |
-404 |
The Update or Insert Statement Specifies a string that is too long COLUMN-NAME. |
-405 |
The Numeric Literal LITERAL Cannot be used as specified because it is out of Range. |
-406 |
A Calculated or Derived Numeric Value is not within the Range or its Object Name. |
-407 |
An Update or Insert Value is Null but the Object Column COLUMN-NAME cannot contain Null Values. |
-408 |
An Update or Insert Value is not comparable with the Data type of its object Column COLUMN –NAME. |
-409 |
Invalid Operand of a Count Function. |
-410 |
The Floating Point Literal LITERAL Contains more than 30 Characters. |
-411 |
The Current Date-Time or User keyword cannot be used as Specified. |
-412 |
The Select Clause of the Sub-query Specifies Multiple Columns. |
-413 |
Overflow Occurred during Data Type Conversion. |
-414 |
The Numeric or DateTime Column COLUMN-NAME is specified in a Like Predicate |
-415 |
The corresponding Columns, COLUMN-NUMBER, of the Operands of a UNION or UNION ALL do not have Comparable Column Descriptions. |
-416 |
An Operand of a UNION contains a Long string Column. |
-417 |
A Statement String to be Prepared includes Parameter markers as the Operands of the Same Operator. |
-418 |
A Statement String to be prepared contains an Invalid Use of Parameter Markers. |
-419 |
The Decimal Divide Operation is invalid because the result would have a negative Value. |
-421 |
The Operands of a UNION or UNION ALL do not have the same number of Columns. |
-501 |
The Cursor identified in a Fetch or Close Statement is not Open. |
-502 |
The cursor Identified in an Open statement is already Open. |
-503 |
A Column cannot be Updated because it is not identified in the Update Clause of the Select Statement of the Cursor. |
-504 |
The Cursor Name CURSOR-NAME is not defined |
-507 |
The Cursor Identified in the Update or Delete Statement is not open. |
-508 |
The Cursor identified in the update or Delete Statement is not positioned on a Row. |
-509 |
The Table identified in the Update or Delete Statement is not the same the Same Table designated by the Cursor. |
-510 |
The Table designated by the Cursor of the Update or Delete Statement cannot be modified. |
-511 |
The FOR UPDATE Clause cannot be specified because the Table designated by the Cursor cannot be Modified. |
-514 |
The Cursor CURSOR-NAME is not in a prepared Table. |
-516 |
The Describe Statement Does not identify a Prepared Statement. |
-517 |
Cursor CURSOR-NAME cannot be used because its Statement name does not identify a Prepared Select Statement. |
-518 |
The execute statement does not identify a Valid Prepared Statement. |
-519 |
The Prepare Statement identifies the Select Statement of the Opened Cursor CURSOR-NAME. |
-551 |
AUTH-ID Does not have the Privilege to perform Operation OPERATION On Object OBJECT-NAME. |
-552 |
AUTH-ID Does not have the Privilege to perform Operation OPERATION. |
-554 |
An Authorization ID cannot grant a privilege to itself. |
-555 |
An Authorization ID cannot revoke a privilege to itself. |
-556 |
A privilege cannot be Revoked because it is not possessed by AUTH-ID. |
-557 |
Inconsistent Grant/revoke Keyword, Permitted Keywords are KEYWORD-LIST. |
-559 |
All Authorization Functions have been Disabled. |
-601 |
The Name of the Object to be created is identical to the existing name NAME of the Object Type OBJ-TYPE. |
-602 |
Too many Columns specified in a Create Index. |
-603 |
A Unique Index cannot be created because The Table contains Rows which are Duplicate with respect to the Values of the identified Columns. |
-604 |
A Column definition Specifies an Invalid Length, precision or Scale Attribute. |
-607 |
Operation OPERATION is not defined for system Tables. |
-612 |
COLUMN-NAME is a duplicate Column Name. |
-614 |
The Index cannot be created because the Sum of the Internal Lengths of the identified Columns is greater than the allowable Maximum |
-616 |
OBJ-TYPE1 OBJ-NAME1 Cannot be dropped because it is referenced by OBJ-TYPE2 and OBJ-NAME2. |
-618 |
Operation OPERATION is not allowed on system Databases. |
-619 |
Operation disallowed because the WorkFile Database is not stopped. |
-620 |
Keyword KEYWORD in STMT-TYPE Statement is not permitted for a Table Space in the WorkFile Database. |
-623 |
A Clustering index already exists on the Table TABLE-NAME |
-636 |
The Partitioning Keys are not specified in Ascending/Descending Order. |
-637 |
Duplicate Keyword ( KEYWORD ). |
-644 |
Invalid Value specified for Keyword KEYWORD in STMT-TYPE Statement. |
-646 |
Table TABLE-NAME Cannot be created in Partitioned/Default TableSpace T-SPACE-NAME because it already contains a Table. |
-647 |
Buffer-pool BP-NAME Cannot be specified because it has not been activated |
-652 |
Violation of Installation Defined Edit or Validation Procedure PROC-NAME |
-653 |
Table TABLE-NAME in Partitioned TableSpace T-SPACE-NAME is not available because its Partitioned Index has not been Created. |
-660 |
Index INDEX-NAME Cannot be Created on Partitioned TableSpace T-SPACE-NAME because Key Limits are not Specified. |
-661 |
Index INDEX-NAME Cannot be created on the Partitioned TableSpace T-SPACE-NAME because the Number of part Specifications is not Equal to the Number of Partitions of the TableSpace. |
-662 |
A Partitioned Index Cannot Be Created on a Non-Partitioned TableSpace T-SPACE-NAME |
-663 |
The Number of Key Limit Values is either zero or greater than the number of columns in the Key of Index INDEX-NAME. |
-664 |
The Internal Length of the Limit Key Fields for the Partitioned Index INDEX-NAME exceeds the length imposed by the Index Manager. |
-665 |
The PART Clause of an ALTER Statement is omitted or Invalid. |
-666 |
STMT-VERB Object cannot be Executed because the utility is in Progress. |
-667 |
The Clustering Index For a Partitioned TableSpace cannot be explicitly Dropped. |
-668 |
The Column Cannot be added to the Table because the table has an Edit Procedure. |
-669 |
A Table in a Partitioned TableSpace cannot be Explicitly Dropped. |
-670 |
The Record Length of the Table exceeds the Page Size Limit. |
-671 |
The Bufferpool Attribute of the TableSpace cannot be altered as specified because it would change the Page Size of the TableSpace. |
-676 |
A 32K Page Bufferpool may not be used for BufferPool Expansion. |
-677 |
Insufficient Virtual Storage For Bufferpool Expansion. |
-678 |
The Literal LITERAL Specified for the Index Limit Key must Conform to the Data Type DATA-TYPE of the Corresponding Column COLUMN-NAME. |
-679 |
The Object NAME Cannot be Created because a drop id Pending on the Object. |
-680 |
Too Many Columns specified for a Table. |
-681 |
Column COLUMN-NAME in Violation of Installation defined field Procedure. RT: Return Code, RS : Reason Code , MSG : Message Token. |
-682 |
Field Procedure PROCEDURE-NAME could not be loaded. |
-683 |
Invalid Column Type for FIELDPROC Option, COLUMN-NAME. |
-684 |
The Length of Literal List Beginning STRING is too long. |
-685 |
Invalid Field Type, COLUMN-NAME. |
-686 |
Column Defined with a field Procedure cannot compare with Another Column with different Field Procedure. |
-687 |
Field Types Incomparable. |
-688 |
Incorrect Data Returned from Field Procedure, COLUMN-NAME, MSG-NO. |
-80N |
Usually means that the DB2 Bind did not work or was used by others. |
-802 |
Exception error EXCEPTION-TYPE has occurred during OPERATION-TYPE operation on DATA-TYPE Data, position POSITION-NO. |
-803 |
One or more insert or update values are invalid because the object columns are constrained such that no two rows of the table can be duplicates with respect to the values of those columns. |
-804 |
An error was found in the application program input parameters for the SQL statements. |
-805 |
Program name PROGRAM-NAME not found in plan PLAN-NAME. |
-811 |
The result of an embedded select statement is a table of more than one row, or the result of the subquery of a basic predicate is more than one value. |
-815 |
A GROUP BY or HAVING clause is implicitly or explicitly specified in an embedded select statement or a subquery of a basic predicate. |
-817 |
The INSERT, UPDATE, DELETE, DDL or AUTHORISATION statement cannot be executed because the IMS / VS transaction is inquiry only. |
-818 |
The precompiler generated Timestamp X in the load module is different from the Bind Timestamp Y built from the DBRM. Answer: Compile and Bind must have the same Timestamp. Rebind or Recompile and then Rebind. |
-819 |
The view cannot be recreated because it references a view that could not be recreated. |
-820 |
The SQL statement cannot be processed because CATALOG-TABLE contains a value that is not valid in this release. |
-821 |
View ‘VIEW-CREATOR’. ‘VIEW-NAME’ has been dropped during migration. Creator SYNONYM-CREATOR of synonym SYNONYM-NAME could not be resolved |
-822 |
The SQL DA contains a invalid data address or indicator variable address. |
-840 |
Too many items returned in a select or insert list. |
-901 |
Unsuccessful execution caused by a system error that does not preclude the successful execution of subsequent SQL statements. |
-902 |
Unsuccessful execution caused by a System error that precludes the successful execution of subsequent SQL Statements. |
-904 |
Unsuccessful execution caused by an unavailable Resource reason REASON-CODE, Type of Resource RESOURCE-TYPE, and Resource name RESOURCE-NAME. Unavailable Resource reason 00c90097, TYPE=200 means that you are trying to insert to a Table that does not have write Capability authorized for it. Contact your DB2 Authorization God. Unavailable Resource Reason 00d70024, TYPE=220 DB2 Table Migrated. Do HRECALL on the Dataset named on Error Line beginning with NW20DB2T.DSNDBC…… |
-906 |
The SQL Statement cannot be executed because this function is disabled due to a Prior Error. |
-909 |
The Object has been Deleted. |
-910 |
The SQL Statement Cannot access an object on which a Drop or Alter is Pending. |
-911 |
The current unit of work has been rolled back due to deadlock or Timeout. Reason REASON-CODE, Type of Resource RESOURCE-TYPE, and Resource Name RESOURCE-NAME. |
-913 |
UnSuccessful execution caused by deadlock or Timeout. Reason REASON-CODE, Type of Resource RESOURCE-TYPE, and Resource Name RESOURCE-NAME. |
-922 |
Connection Authorization Failure: ERROR-TYPE Error. Make sure your Plan in the DSN with the DDNAME DDITV02 is the same one you bound with. TSKXB 93-04-23 |
-923 |
Connection not Established : DB2 CONDITION Reason REASON_CODE, Type RESOURCE-TYPE, Name RESOURCE-NAME. |
-924 |
DB2 Connection Internal error : FUNCTION-CODE, RETURN-CODE, REASON-CODE. |
-925 |
Commit Not Valid in IMS/VS or CICS/OS/VS Environment. |
-926 |
RollBack Not Valid in IMS/VS or CICS/OS/VS Environment. |
-927 |
The Language Interface LI was called when the connecting environment was not established. The Program should be invoked under the DSN Command. |