SQL CODES DESCRIPTION |
| |
| 000 Sql Statement finished succesfully |
| +100 No rows satisfied the sql statement |
| +117 No of values being inserted is not equal to no. of columns in the table being inserted to |
| +162 Named table space is placed in check pending status |
| +204 Named Object is not defined to Db2 |
| +205 Named column does not exist in the named table |
| +206 Named column does not exist in any table which is named in the sql statement |
| +625 Table defination marked incomplete because primary Key index was dropped |
| +802 Data Exception error caused by data overflow/divide Exception |
| -007 Sql Statement contains illegal character |
| -029 INTO clause is required |
| -060 Specified Data type has an invalid length/scale specefication |
| -084 Sql statement can’t be excuted because it is invalid for Dynamic sql/is an sql /ds statement |
| -101 Sql statement exceeds an established DB2 limit (Too many tables / Too many bytes in the statement) |
Date/Time |
| |
| -180 Syntax for string representation of Date/Time value is invalid |
| -181 String representation of Date/Time value is invalid |
| -182 Date/Time value in an arithmetic expression is invalid |
| -183 Result of arithmetic expression Returns a Date/Time value that is not in the range of valid values |
Cursors |
| |
| -501 Cursor must be opened before attempting to fetch from it or close it |
| -502 Cursor can’t opened twise without first closing it |
| -503 Column can’t be updated because it was not specified in the FOR UPDATE OFF clause of the cursor from it was fetched |
| -504 Cursor can’t be referenced because it defined to the program |
| -507 Cursor must be opened before attempting to update/delete WHERE CURRENT OF |
| -508 You can’t update or delete because referenced cursor is not positioned in a data row |
| -509 You can’t upate from a different table than the one specified on the cursor referenced by WHERE CURRENT OF clause |
Referential Integrity |
| |
| -530 Invalid foreign key was specified for specified constraint name |
| -531 Primary key value can’t be updated if foreign keys currently exist that reference that value |
| -532 Deletion violates the named referential constraint |
| -533 Multiple row insert is invalid; Attempting to insert multiple rows into a self referencing table |
| -534 Update statement changing primary key column can’t be used to update more than one row at a time |
| -535 WHERE CURRENT OF can’t be specified when deleting from a self referencing table or updating primary key column |
| -536 Delete statement is invalid due to referential constraints existing for the specified table |
| -537 Single column can’t appear more than once in foreign/primary key clause specification |
| -538 Foreign key is invalid. Because it does not conform to the definition of referenced table primary key |
| -539 Foreign key can’t be defined because the referenced table does not have primary key |
| -540 Table definition is incomplete until unique index is created for the primary key |
| -551 User is attempting to perform an operation on the specified object for which user is not authorised or Table does not exist |
| -601 An attempt was made to create an object that already exists |
| -602 Too many columns were specified in CREATE INDEX statement |
| -603 Unique index cannot be created because duplicates were found |
| -607 INSERT,UPDATE,DELETE can’t be issued as written against the DB2 catalogue tables |
| -612 Duplicate column names are permitted in single table |
| -803 Row can’t be inserted because it would violate the constraints of the unique index |
| -818 Time Stamp Mismatch |
| -904 Specified resource is unavailable |
| -911 Current unit of work has been Rolled back |
| -913 Execution is unsuccessful due to DEADLOCK/TIME OUT |
| -922 Connection authorisation failure. Attempt made to access DB2 from TSO, CICS,IMS and appropriate attachment facility is inactive |
No comments:
Post a Comment