Z#SQLCOD

+100 Row not found or end of cursor

-102 String constant is too long

-117 values to INSERT not match number of columns

-180 Bad data in Date/Time/Timestamp

-181 Bad data in Date/Time/Timestamp

-199 Illegal use of the specified keyword.

-204 Object not defined to DB2

-205 Column name not in specified table

-206 Column does not exist in any table in the SELECT

-216 Diferent number of expressions on Comparison sides

+222 Trying to fetch a row that fell through a DELETE hole

+223 Trying to fetch a row that fell through an UPDATE hole

-224 FETCH cannot make an INSENSITIVE cursor SENSITIVE

-229 Locale specified in a SET LOCALE statement not found.

+231 FETCH BEFORE or AFTER not on a valid row

+304 Value out of range cannot be assigned to host variable.

-305 Null indicator needed

-311 Varchar, insert or update. -LEN field not set.

-482 he procedure returned no locators

-501 Cursor not open on FETCH

-502 Opening cursor that is already open

-503 Updating column which needs to be specified in FOR UPDATE OF

-530 Referential integrity prevents the INSERT/UPDATE

-532 Referential integrity (DELETE RESTRICT rule) prevents the DELETE

-536 Referential integrity (DELETE RESTRICT rule) prevents the DELETE

-545 Check constraint prevents the INSERT/UPDATE

-747 The table is not available. Tables and/or indexes need to be created.

+802 The null indicator was set to -2. An arithmetic statement didn't work.

-803 Duplicate key on insert or update

-805 DBRM or package not found in plan. Is plan name correct?

-811 More than one row retrieved in SELECT INTO

-818 Plan and program: timestamp mismatch

-904 Unavailable resource. Someone is locking the data you need.

-911 Deadlock or timeout. Rollback has been done.

-913 Deadlock or timeout. NO rollback has been done.

-922 Authorization needed

-927 LI WAS CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED.

-991 CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO DB2.

-981 RRSAF CONNECTION IS NOT IN A STATE THAT ALLOWS SQL OPERATIONS.

-950 LOCATION NAME IN THE CONNECT STATEMENT IS INVALID OR NOT LISTED.

-948 DISTRIBUTED OPERATION IS INVALID.

-947 DATA CANNOT BE PROPAGATED

-939 ROLLBACK REQUIRED DUE TO UNREQUESTED ROLLBACK OF A REMOTE SERVER

-929 FAILURE IN A CHANGED DATA CAPTURE EXIT:

-926 ROLLBACK NOT VALID IN IMS OR CICS ENVIRONMENT

-925 COMMIT NOT VALID IN IMS OR CICS ENVIRONMENT

-924 DB2 CONNECTION INTERNAL ERROR

-923 CONNECTION NOT ESTABLISHED

-919 A ROLLBACK OPERATION IS REQUIRED

-918 CONNECTION HAS BEEN LOST

-917 BIND PACKAGE FAILED

-910 DROP OR ALTER IS PENDING

-909 THE OBJECT HAS BEEN DELETED OR ALTERED

-908 ERROR USING AUTHORITY. BIND, REBIND, OR AUTO-REBIND IS NOT ALLOWED

-906 THIS FUNCTION IS DISABLED DUE TO A PRIOR ERROR

-905 UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING EXCEEDED.

-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE.

-902 POINTER TO ESSENTIAL CONTROL BLOCK(RDA/CT) HAS VALUE 0, REBIND REQUIRED

-901 SYSTEM ERROR.

-900 APPLICATION PROCESS IS NOT CONNECTED TO AN APPLICATION SERVER

-882 SAVEPOINT DOES NOT EXIST

-881 SAVEPOINT NAME CANNOT BE REUSED. SAVEPOINT ALLREADY EXISTS

-880 SAVEPOINT DOES NOT EXIST OR IS INVALID IN THIS CONTEXT

-879 INVALID CREATE OR ALTER STATEMENT.

-878 THE PLAN_TABLE USED FOR EXPLAIN CANNOT BE ASCII

-877 CCSID ASCII IS NOT ALLOWED FOR THIS DATABASE OR TABLE SPACE

-876 CANNOT BE CREATED, REASON

-875 CANNOT BE USED WITH THE ASCII DATA REFERENCED

-874 INVALID ENCODING SCHEME.

-873 DATA ENCODED WITH DIFFERENT CCSIDS CANNOT BE REF. IN THE SAME SQL STATEMENT

-872 A VALID CCSID HAS NOT YET BEEN SPECIFIED FOR THIS SUBSYSTEM

-870 NUMBER OF HOST VARIABLES IS NOT EQUAL TO THE NUMBER OF DESCRIPTORS

-867 INVALID SPECIFICATION OF A ROWID COLUMN

-846 INVALID SPECIFICATION OF AN IDENTITY COLUMN

-843 THE SET CONNECTION OR RELEASE STATEMENT MUST SPECIFY AN EXISTING CONNECTION

-842 A CONNECTION TO x ALREADY EXISTS

-840 TOO MANY ITEMS RETURNED IN A SELECT OR INSERT LIST

-822 THE SQLDA CONTAINS AN INVALID DATA ADDRESS OR INDICATOR VARIABLE ADDRESS

-820 SQL STATEMENT CANNOT BE PROCESSED. VALUE THAT IS NOT VALID IN THIS RELEASE

-819 VIEW CANNOT BE PROCESSED. LENGTH OF PARSE TREE IN THE CATALOG IS ZERO

-818 GENERATED TIMESTAMP IN THE LOAD MODULE IS DIFFERENT FROM THE BIND

-817 STATEMENT WILL RESULT IN A PROHIBITED UPDATE OPERATION

-815 INVALID GROUP BY OR HAVING CLAUSE.

-812 BLANK COLLECTION-ID WAS FOUND IN THE CURRENT PACKAGESET SPECIAL REGISTER.

-811 SELECT STATEMENT OR A SUBSELECT IN THE SET CLAUSE OF AN UPDATE IS INVALID.

-808 THE CONNECT STATEMENT IS NOT CONSISTENT WITH THE FIRST CONNECT STATEMENT

-807 ACCESS DENIED: PACKAGE IS NOT ENABLED FOR ACCESS FROM

-805 DBRM OR PACKAGE NAME NOT FOUND IN PLAN . REASON

-804 ERROR IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT

-803 AN INSERTED OR UPDATED VALUE IS INVALID. DUPLICATE VALUES

-802 EXCEPTION ERROR HAS OCCURRED DURING OPERATION ON DATA, POSITION

-798 INSERT NOT ALOWED

-797 ATTEMPT TO CREATE TRIGGER WITH AN UNSUPPORTED TRIGGERED SQL STATEMENT

-771 INVALID SPECIFICATION OF A ROWID COLUMN

-770 TABLE CANNOT HAVE A LOB COLUMN UNLESS IT ALSO HAS A ROWID COLUMN

-769 AUX TABLE DOES NOT MATCH THE CHARACTERISTICS OF THE BASE TABLE

-768 AN AUXILIARY TABLE ALREADY EXISTS FOR THE SPECIFIED COLUMN OR PARTITION

-767 MISSING OR INVALID COLUMN SPECIFICATION FOR INDEX

-766 REQUESTED OPERATION IS NOT PERMITTED FOR THE OBJECT

-765 TABLE IS NOT COMPATIBLE WITH DATABASE

-764 LOB TAB. SPACE AND ITS ASSOC. BASE TAB. SPACE MUST BE IN SAME DATABASE

-763 INVALID TABLE SPACE NAME

-752 THE CONNECT STATEMENT IS INVALID. THE PROCESS IS NOT IN CONNECTABLE STATE

-751 (SPECIFIC NAME ) ATTEMPTED TO EXECUTE AN SQL STATEMENT THAT IS NOT ALLOWED

-750 THE SOURCE TAB. CANNOT BE RENAMED. IT IS REFERENCED IN EXISTING VIEW

-748 AN INDEX ALREADY EXISTS ON AUXILIARY TABLE

-747 TABLE IS NOT AVAILABLE.

-746 THE SQL STATEMENT VIOLATES THE NESTING SQL RESTRICTION

-742 DSNDB07 IS THE IMPLICIT WORK FILE DATABASE

-741 A DATABASE IS ALREADY DEFINED FOR MEMBER

-740 FUNCTION IS DEFINED WITH THE OPTION MODIFIES SQL DATA WHICH IS NOT VALID.

-739 ALTER FUNCTION CANNOT MODIFY DATA WHEN THEY ARE PROCESSED IN PARALLEL

-737 IMPLICIT TABLE SPACE NOT ALLOWED

-736 INVALID OBID SPECIFIED

-735 DATABASE CANNOT BE ACCESSED BECAUSE IT IS NO LONGER A SHARED DATABASE

-734 THE ROSHARE ATTRIBUTE OF A DATABASE CANNOT BE ALTERED FROM ROSHARE READ

-733 INVALID DESCRIPTION OF THE OBJECT.

-732 DATABASE IS DEFINED AND TABLESPACE WITH INCONSISTENT ATTRIBUTS.

-731 USER-DEFINED DATASET MUST BE DEFINED WITH SHAREOPTIONS (1,3)

-730 INVALID PARENT OF A TABLE IN A READ-ONLY SHARED DATABASE

-729 STORED PROCEDURE CANNOT BE THE TARGET OF A NESTED CALL STATEMENT

-728 DATA TYPE IS NOT ALLOWED IN DB2 PRIVATE PROTOCOL PROCESSING

-726 BIND ERROR ATTEMPTING TO REPLACE PACKAGE.

-725 SPECIAL REGISTER AT LOCATION WAS SUPPLIED AN INVALID VALUE

-724 ACTIVATION OF THE OBJECT WOULD EXCEED THE MAXIMUM LEVEL.

-723 AN ERROR OCCURRED IN A TRIGGERED SQL STATEMENT.

-722 ERROR USING AUTHORITY PACKAGE DOES NOT EXIST

-721 BIND ERROR FOR PACKAGE.

-720 BIND ERROR, ATTEMPTING TO REPLACE PACKAGE WITH VERSION THAT ALREADY EXISTS

-719 BIND ADD ERROR USING AUTHORITY PACKAGE ALREADY EXISTS

-718 REBIND OF PACKAGE FAILED BECAUSE IBMREQD OF IS INVALID

-717 DEPENDS ON FUNCTIONS OF THE RELEASE FROM WHICH FALLBACK HAS OCCURRED

-716 PROGRAM PRECOMPILED WITH INCORRECT LEVEL FOR THIS RELEASE

-715 DEPENDS ON FUNCTIONS OF THE RELEASE FROM WHICH FALLBACK HAS OCCURRED

-713 THE REPLACEMENT VALUE FOR IS INVALID

-697 CORRELATION NAMES ARE NOT ALLOWED IN THE TRIGGER DEFINED

-696 TRIGGER HAVE AN INVALID USE OF CORRELATION NAME OR TRANSITION TABLE NAME.

-694 DROP IS PENDING ON THE DDL REGISTRATION TABLE

-693 THE COLUMN IN DDL REGISTRATION TABLE OR INDEX IS NOT DEFINED PROPERLY

-692 THE REQUIRED UNIQUE INDEX FOR DDL REGISTRATION TABLE DOES NOT EXIST

-691 THE REQUIRED REGISTRATION TABLE DOES NOT EXIST

-690 THE STATEMENT IS REJECTED BY DATA DEFINITION CONTROL SUPPORT. REASON

-689 TOO MANY COLUMNS DEFINED FOR A DEPENDENT TABLE

-688 INCORRECT DATA RETURNED FROM FIELD PROCEDURE, ,

-687 FIELD TYPES INCOMPARABLE

-686 COMPARE WITH ANOTHER COLUMN WITH DIFFERENT FIELD PROCEDURE

-685 INVALID FIELD TYPE,

-684 THE LENGTH OF LITERAL LIST BEGINNING IS TOO LONG

-683 SPECIFICATION CONTAINS INCOMPATIBLE CLAUSES

-682 FIELD PROCEDURE COULD NOT BE LOADED

-681 COLUMN IN VIOLATION OF INSTALLATION DEFINED FIELD PROCEDURE.

-680 TOO MANY COLUMNS SPECIFIED FOR A TABLE, VIEW, OR TABLE FUNCTION

-679 OBJECT CANNOT BE CREATED BECAUSE A DROP IS PENDING ON THE OBJECT

-678 INVALID LITERAL SPECIFIED FOR THE INDEX LIMIT.

-677 INSUFFICIENT VIRTUAL STORAGE FOR BUFFERPOOL EXPANSION

-676 ONLY A 4K PAGE BUFFERPOOL CAN BE USED FOR AN INDEX

-672 OPERATION DROP NOT ALLOWED ON TABLE

-671 BUFFERPOOL ATTRIBUTE OF THE TABLE SPACE CANNOT BE ALTERED AS SPECIFIED.

-670 THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT

-669 TABLE IN A PARTITIONED TABLE SPACE CANNOT BE EXPLICITLY DROPPED

-668 COLUMN CANNOT BE ADDED THE TABLE HAS AN EDIT PROCEDURE

-667 CLUSTERING INDEX FOR A PARTITIONED TABLE SPACE CANNOT BE EXPLICITLY DROPPED

-666 CANNOT BE EXECUTED BECAUSE IS IN PROGRESS

-665 PART CLAUSE OF AN ALTER STATEMENT IS OMITTED OR INVALID

-663 KEY LIMIT VALUES IS ZERO, OR GREATER THAN NUMBER OF COLUMNS INDEX

-662 A PARTITIONED INDEX CANNOT BE CREATED ON A NON-PARTITIONED TABLE SPACE

-661 NUMBER OF PART SPECIFICATIONS NOT EQUAL NUMBER PARTITIONS THE TABLE SPACE

-660 INDEX CANNOT BE CREATED. KEY LIMITS ARE NOT SPECIFIED

-658 A CANNOT BE DROPPED USING THE STATEMENT

-655 THE CREATE OR ALTER STOGROUP IS INVALID.

-653 PARTITIONED INDEX HAS NOT BEEN CREATED

-652 VIOLATION OF INSTALLATION DEFINED EDIT OR VALIDATION PROCEDURE

-651 TABLE DESCRIPTION EXCEEDS MAXIMUM SIZE OF OBJECT DESCRIPTOR

-650 THE ALTER INDEX CANNOT BE EXECUTED, REASON

-647 BUFFERPOOL CANNOT BE SPECIFIED BECAUSE IT HAS NOT BEEN ACTIVATED

-646 TABLE CANNOT BE CREATED. IT ALREADY CONTAINS A TABLE

-644 INVALID VALUE SPECIFIED FOR KEYWORD IN STATEMENT

-643 CHECK CONSTRAINT EXCEEDS MAXIMUM ALLOWABLE LENGTH

-642 TOO MANY COLUMNS IN UNIQUE CONSTRAINTS

-640 LOCKSIZE ROW CANNOT BE SPECIFIED

-639 INVALID NULLABLE COLUMN OF A FOREIGN KEY

-638 TABLE CANNOT BE CREATED BECAUSE COLUMN DEFINITION IS MISSING

-637 DUPLICATE KEYWORD

-636 PARTITIONING KEYS FOR PARTITION NOT SPECIFIED IN ASC OR DESC ORDER

-635 THE DELETE RULES CANNOT BE DIFFERENT OR CANNOT BE SET NULL

-634 THE DELETE RULE MUST NOT BE CASCADE

-633 THE DELETE RULE MUST BE

-632 THE TABLE CANNOT BE DEFINED AS A DEPENDENT. DELETE RULE RESTRICTIONS

-631 FOREIGN KEY IS TOO LONG OR HAS TOO MANY COLUMNS

-630 THE WHERE NOT NULL SPECIFICATION IS INVALID FOR TYPE 1 INDEXES

-629 SET NULL CANNOT BE SPECIFIED BECAUSE FOREIGN KEY CANNOT CONTAIN NULL VALUES

-628 THE CLAUSES ARE MUTUALLY EXCLUSIVE

-627 ALTER STATEMENT IS INVALID BECAUSE THE PAGESET HAS USER-MANAGED DATA SETS

-626 THE ALTER STATEMENT IS NOT EXECUTABLE BECAUSE THE PAGE SET IS NOT STOPPED

-625 TABLE DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE PARENT KEY

-624 TABLE ALREADY HAS A PRIMARY KEY

-623 A CLUSTERING INDEX ALREADY EXISTS ON TABLE

-622 FOR MIXED DATA IS INVALID BECAUSE THE MIXED DATA INSTALL OPTION IS NO

-621 DUPLICATE DBID WAS DETECTED AND PREVIOUSLY ASSIGNED TO

-620 KEYWORD IN STATEMENT IS NOT PERMITTED FOR A SPACE IN THE DATABASE

-619 OPERATION DISALLOWED BECAUSE THE WORK FILE DATABASE IS NOT STOPPED

-618 OPERATION IS NOT ALLOWED ON SYSTEM DATABASES

-617 A TYPE 1 INDEX IS NOT VALID FOR TABLE

-616 CANNOT BE DROPPED BECAUSE IT IS REFERENCED BY

-615 IS NOT ALLOWED ON A PACKAGE IN USE

-614 INDEX CANNOT BE CREATED OR THE LENGTH OF THE COLUMN CANNOT BE CHANGED.

-613 THE PRIMARY KEY OR A UNIQUE CONSTRAINT IS TOO LONG OR HAS TOO MANY COLUMNS

-612 IS A DUPLICATE COLUMN NAME

-611 ONLY LOCKMAX 0 CAN BE SPECIFIED.

-607 OPERATION OR OPTION IS NOT DEFINED FOR THIS OBJECT

-604 DATA TYPE DEFINITION SPECIFIES AN INVALID LENGTH, PRECISION, OR SCALE

-603 UNIQUE INDEX CANNOT BE CREATED. TABLE CONTAINS ROWS WHICH ARE DUPLICATES.

-602 TOO MANY COLUMNS SPECIFIED IN A CREATE INDEX

-601 NAME IS IDENTICAL TO THE EXISTING NAME OF THE OBJECT TYPE

-594 ATTEMPT TO CREATE A NULLABLE ROWID OR DISTINCT TYPE COLUMN

-593 NOT NULL MUST BE SPECIFIED FOR ROWID OR DISTINCT TYPE COLUMN

-592 NOT AUTHORIZED TO CREATE FUNCTIONS OR PROCEDURES IN WLM ENVIRONMENT

-590 PARAMETER NAME IS NOT UNIQUE IN THE CREATE FOR ROUTINE

-586 TOTAL LENGTH OF CURRENT PATH SPECIAL REGISTER CANNOT EXCEED 254 CHARACTERS

-585 SCHEMA NAME CANNOT APPEAR MORE THAN ONCE IN THE CURRENT PATH

-582 INVALID SEARCH-CONDITION IN A SEARCHED-WHEN-CLAUSE.

-581 DATA TYPES ARE NOT COMPATIBLE

-580 RESULT-EXPRESSIONS OF A CASE EXPRESSION CANNOT ALL BE NULL

-579 ATTEMPTED TO READ DATA. FUNCTION OR PROCEDURE DID NOT SPECIFY THIS ACTION

-577 ATTEMPTED TO MODIFY DATA. FUNCTION OR PROCEDURE DID NOT SPECIFY THIS ACTION

-574 SPECIFIED DEFAULT VALUE OR IDENTITY ATTRIBUTE VALUE CONFLICTS

-573 TABLE DOES NOT HAVE A UNIQUE KEY WITH THE SPECIFIED COLUMN NAMES

-571 THE STATEMENT WOULD RESULT IN A MULTIPLE SITE UPDATE

-567 AUTHORIZATION ERROR USING AUTHORITY PACKAGE = PRIVILEGE =

-559 ALL AUTHORIZATION FUNCTIONS HAVE BEEN DISABLED

-558 INVALID CLAUSE OR COMBINATION OF CLAUSES ON A GRANT OR REVOKE

-557 INCONSISTENT GRANT/REVOKE KEYWORD . PERMITTED KEYWORDS ARE

-556 CANNOT HAVE THE PRIVILEGE REVOKED.

-555 AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF

-554 AN AUTHORIZATION ID CANNOT GRANT A PRIVILEGE TO ITSELF

-553 SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION IDS

-552 DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION

-551 DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION ON OBJECT

-549 STATEMENT IS NOT ALLOWED. BIND OPTION DYNAMICRULES(RUN) IS NOT IN EFFECT.

-548 A CHECK CONSTRAINT THAT IS DEFINED WITH IS INVALID

-546 THE CHECK CONSTRAINT IS INVALID

-545 ROW DOES NOT SATISFY THE CHECK CONSTRAINT

-544 EXISTING ROW VIOLATES THE CHECK CONSTRAINT

-543 CHECK CONSTRAINT RESTRICTS THE DELETION

-542 CANNOT BE A COLUMN OF A PRIMARY KEY, A UNIQUE CONSTRAINT, OR A PARENT

-540 DEFINITION OF TABLE.LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX

-539 TABLE DOES NOT HAVE A PRIMARY KEY

-538 FOREIGN KEY DOES NOT CONFORM TO THE DESCRIPTION OF A PARENT KEY OF TABLE

-537 KEY CLAUSE IDENTIFIES COLUMN MORE THAN ONCE

-536 TABLE CAN BE AFFECTED BY THE OPERATION DELETE

-534 PRIMARY KEY CANNOT BE UPDATED BECAUSE OF MULTIPLE-ROW UPDATE

-533 INVALID MULTIPLE-ROW INSERT

-532 THE RELATIONSHIP RESTRICTS THE DELETION OF ROW WITH RID X''

-531 KEY CANNOT BE UPDATED. HAS ONE OR MORE DEPENDENT ROWS IN RELATIONSHIP

-530 THE INSERT OR UPDATE VALUE OF FOREIGN KEY IS INVALID

-526 THE REQUESTED OPERATION OR USAGE DOES NOT APPLY TO TEMPORARY TABLE

-525 STATEMENT CANNOT BE EXECUTED. WAS IN ERROR AT BIND TIME.

-519 THE PREPARE STATEMENT IDENTIFIES THE SELECT STATEMENT OF THE OPENED CURSOR

-518 THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT

-517 CURSOR CANNOT BE USED. STATEMENT NAME DOES NOT IDENTIFY A PREPARED SELECT.

-516 DESCRIBE FOR STATIC STATEMENT DOES NOT IDENTIFY A PREPARED STATEMENT

-514 CURSOR IS NOT IN A PREPARED STATE

-513 ALIAS MUST NOT BE DEFINED ON ANOTHER LOCAL OR REMOTE ALIAS

-512 STATEMENT REFERENCE TO REMOTE OBJECT IS INVALID

-511 FOR UPDATE CLAUSE CANNOT BE SPECIFIED

-510 TABLE CANNOT BE MODIFIED

-509 TABLE IDENTIFIED IS NOT THE SAME TABLEDESIGNATED BY THE CURSOR

-508 CURSOR IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT ON A ROW

-507 THE CURSOR IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT OPEN

-504 THE CURSOR NAME IS NOT DEFINED

-503 A COLUMN CANNOT BE UPDATED. NOT IN THE UPDATE CLAUSE OF THE CURSOR

-502 THE CURSOR IDENTIFIED IN AN OPEN STATEMENT IS ALREADY OPEN

-501 THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN

-500 THE IDENTIFIED CURSOR WAS CLOSED WHEN THE CONNECTION WAS DESTROYED

-499 CURSOR HAS ALREADY BEEN .

-497 THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE

-496 REFERENCES A RESULT SET THAT WAS NOT CREATED BY THE CURRENT SERVER

-495 ESTIMATED PROCESSOR COST EXCEEDS A RESOURCE LIMIT

-492 MISMATCH WITH A SOURCE FUNCTION

-491 INVALID CREATE STATEMENT FOR USER-DEFINED FUNCTION.

-487 STATEMENT ALLOWED BY HER DEFINITION

-483 NR OF PARAMETERS DOES NOT MATCH NR OF PARAMETERS OF SOURCE FUNCTION

-482 THE PROCEDURE RETURNED NO LOCATORS

-480 THE PROCEDURE HAS NOT YET BEEN CALLED

-478 DROP OR REVOKE IMPOSSIBLE. OBJECT OF TYPE IS DEPENDENT ON IT

-476 REFERENCE TO FUNCTION WAS NAMED WITHOUT A SIGNATURE.

-475 RESULT TYPE OF SOURCE FUNCTION CANNOT BE CAST TO USER-DEFINED FUNCTION

-473 USER DEFINED DATA TYPE CANNOT HAVE SAME NAME AS A SYSTEM PREDEFINED TYPE

-472 CURSOR WAS LEFT OPEN BY EXTERNAL FUNCTION (SPECIFIC NAME )

-471 INVOCATION OF FUNCTION OR PROCEDURE FAILED DUE TO REASON

-470 NULL VALUE FOR INPUT PARAMETER. PROCEDURE DOES NOT SUPPORT NULL VALUES

-469 SQL CALL STATEMENT MUST SPECIFY AN OUTPUT HOST VARIABLE FOR PARAMETER

-463 EXTERNAL FUNCTION HAS RETURNED AN INVALID SQLSTATE.

-461 A VALUE WITH DATA TYPE CANNOT BE CAST TO TYPE

-458 MATCHING FUNCTION COULD NOT BE FOUND

-457 FUNCTION RESERVED FOR SYSTEM USE

-456 IN CREATE FUNCTION FOR , THE SPECIFIC NAME ALREADY EXISTS IN THE SCHEMA

-455 NAME PROVIDED FOR SPECIFIC NAME DOES NOT MATCH SCHEMA NAME OF FUNCTION

-454 INVALID SIGNATURE PROVIDED IN CREATE FUNCTION STATEMENT.

-453 ERROR IN RETURN CLAUSE IN THE CREATE FUNCTION STATEMENT FOR

-451 DATA TYPE NOT APPROPRIATE FOR AN EXTERNAL FUNCTION.

-450 OVERLAYED STORAGE BEYOND ITS DECLARED LENGTH

-449 AN INVALID MISSING/FORMAT OF EXTERNAL NAME CLAUSE.

-444 USER PROGRAM COULD NOT BE FOUND

-443 EXTERNAL FUNCTION HAS RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC TEXT

-441 INVALID USE OF 'DISTINCT' OR 'ALL' WITH SCALAR FUNCTION

-440 NO BY THE NAME HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE CURRENT PATH

-438 APPLICATION RAISED ERROR WITH DIAGNOSTIC TEXT:

-435 AN INVALID SQLSTATE IS SPECIFIED IN THE FUNCTION RAISE_ERROR.

-433 VALUE IS TOO LONG

-430 ABNORMALLY TERMINATED

-427 DYNAMIC ROLLBACK NOT VALID. UPDATES ARE NOT ALLOWED

-426 DYNAMIC COMMIT NOT VALID. UPDATES ARE NOT ALLOWED

-423 INVALID VALUE FOR LOCATOR IN POSITION

-421 THE OPERANDS OF A UNION OR UNION ALL DO NOT HAVE THE SAME NUMBER OF COLUMNS

-420 THE VALUE OF A CHARACTER STRING ARGUMENT WAS NOT ACCEPTABLE TO THE FUNCTION

-419 DECIMAL DIVIDE OPERATION IS INVALID. RESULT WOULD HAVE A NEGATIVE SCALE

-418 STATEMENT STRING CONTAINS AN INVALID USE OF PARAMETER MARKERS

-417 STATEMENT STRING INCLUDES MARKERS AS OPERANDS OF THE SAME OPERATOR

-416 AN OPERAND OF A UNION CONTAINS A LONG STRING COLUMN

-415 THE CORRESPONDING COLUMNS DO NOT HAVE COMPARABLE COLUMN DESCRIPTIONS

-414 A LIKE PREDICATE IS INVALID BECAUSE THE FIRST OPERAND IS NOT A STRING

-413 OVERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSION

-412 THE SELECT CLAUSE OF A SUBQUERY SPECIFIES MULTIPLE COLUMNS

-411 CURRENT SQLID CANNOT BE USED IN A STATEMENT THAT REFERENCES REMOTE OBJECTS

-410 THE FLOATING POINT LITERAL CONTAINS MORE THAN 30 CHARACTERS

-409 INVALID OPERAND OF A COUNT FUNCTION

-408 THE VALUE IS NOT COMPATIBLE WITH THE DATA TYPE OF ITS TARGET

-407 OBJECT COLUMN CANNOT CONTAIN NULL VALUES

-406 CALCULATED OR DERIVED NUMERIC VALUE IS NOT IN RANGE OF ITS OBJECT COLUMN

-405 THE NUMERIC LITERAL CANNOT BE USED AS SPECIFIED BECAUSE IT IS OUT OF RANGE

-404 THE SQL STATEMENT SPECIFIES A STRING THAT IS TOO LONG

-402 AN ARITHMETIC FUNCTION OR OPERATOR IS APPLIED TO CHARACTER OR DATETIME DATA

-401 THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE

-400 THE CATALOG HAS THE MAXIMUM NUMBER OF USER DEFINED INDEXES

-399 ATTEMPTED TO INSERT AN INVALID VALUE INTO A ROWID COLUMN

-398 LOCATOR WAS REQUESTED FOR HOST VARIABLE NUMBER BUT VARIABLE IS NOT A LOB

-397 COLUMN IS NOT A ROW ID OR TYPE BASED ON A ROW ID

-396 ATTEMPTED TO EXECUTE AN SQL STATEMENT DURING FINAL CALL PROCESSING

-392 SQLDA PROVIDED FOR CURSOR HAS BEEN CHANGED FROM THE PREVIOUS FETCH

-390 FUNCTION NAME , SPECIFIC NAME , IS NOT VALID IN THE CONTEXT.

-373 DEFAULT CANNOT BE SPECIFIED FOR IDENTITY COLUMN

-372 ONLY ONE ROWID OR IDENTITY COLUMN IS ALLOWED IN A TABLE

-359 THE RANGE OF VALUES FOR THE IDENTITY COLUMN IS EXHAUSTED

-355 A LOB COLUMN IS TOO LARGE TO BE LOGGED

-352 AN UNSUPPORTED SQLTYPE WAS ENCOUNTERED IN POSITION OF THE INPUT-LIST

-351 AN UNSUPPORTED SQLTYPE WAS ENCOUNTERED IN POSITION OF THE SELECT-LIST

-350 INVALID SPECIFICATION OF A LARGE OBJECT COLUMN

-339 SQL STATEMENT CANNOT BE EXECUTED FROM AN ASCII BASED DRDA APPLICATION.

-338 AN ON CLAUSE IS INVALID

-333 SUBTYPE OF A STRING IS NOT SAME AS THE SUBTYPE KNOWN AT BIND.

-332 SYSSTRINGS DOES NOT DEFINE A TRANSLATION FROM CCSID TO

-331 STRING CANNOT BE ASSIGNED TO A HOST VARIABLE.

-330 STRING CANNOT BE USED.

-327 ROW CANNOT BE INSERTED. IS OUTSIDE THE BOUND OF THE PARTITION RANGE.

-314 STATEMENT CONTAINS AN AMBIGUOUS HOST VARIABLE REFERENCE.

-313 NR OF HOST VARIABLES IS NOT EQUAL TO THE NR OF PARAMETER MARKERS.

-312 UNDEFINED OR UNUSABLE HOST VARIABLE.

-311 LENGTH OF INPUT HOST VARIABLE NR IS NEGATIVE OR GREATER THAN MAXIMUM

-310 DECIMAL HOST VARIABLE OR PARAMETER CONTAINS NON-DECIMAL DATA

-309 PREDICATE INVALID. REFERENCED HOST VARIABLE HAS THE NULL VALUE

-305 NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER.

-304 VALUE WITH DATA TYPE CANNOT BE ASSIGNED TO HOST VARIABLE.

-303 DATA TYPES ARE NOT COMPARABLE

-302 INPUT VARIABLE OR PARAMETER IS INVALID OR TOO LARGE.

-301 INVALID DATA TYPE

-300 THE STRING CONTAINED IN HOST VARIABLE OR PARAMETER IS NOT NUL-TERMINATED

-251 TOKEN IS NOT VALID

-250 LOCAL LOCATION NAME IS NOT DEFINED WHEN PROCESSING A THREE-PART OBJECT NAME

-240 PART CLAUSE OF A LOCK TABLE STATEMENT IS INVALID

-229 LOCALE SPECIFIED IN A SET LOCALE OR OTHER STATEMENT THAT IS LOCALE.

-221 "SET OF OPTIONAL COLUMNS" IN EXPLANATION TABLE IS INCOMPLETE.

-220 THE COLUMN IN EXPLANATION TABLE IS NOT DEFINED PROPERLY

-219 THE REQUIRED EXPLANATION TABLE DOES NOT EXIST

-214 AN EXPRESSION STARTING WITH IN THE CLAUSE IS NOT VALID. REASON CODE =

-212 IS SPECIFIED MORE THAN ONCE IN THE REFERENCING CLAUSE

-208 ORDER BY CLAUSE INVALID. COLUMN IS NOT PART OF THE RESULT TABLE

-206 NOT A COLUMN OF AN INSERTED OR UPDATED TABLE,

-205 IS NOT A COLUMN OF TABLE

-204 IS AN UNDEFINED NAME

-203 A REFERENCE TO COLUMN IS AMBIGUOUS

-199 ILLEGAL USE OF KEYWORD , TOKEN WAS EXPECTED

-198 THE OPERAND OF THE PREPARE OR EXECUTE IMMEDIATE STATEMENT IS BLANK OR EMPTY

-197 COLUMN NAMES IN ORDER BY CLAUSE NOT PERMITTED WHITH UNION OR UNION ALL

-191 A STRING CANNOT BE USED BECAUSE IT IS INVALID MIXED DATA

-190 ATTRIBUTES OF COLUMN IN TABLE ARE NOT COMPATIBLE WITH THE EXISTING COLUMN

-189 CCSID IS UNKNOWN OR INVALID FOR THE DATA TYPE OR SUBTYPE

-188 THE STRING REPRESENTATION OF A NAME IS INVALID

-187 REFER. TO CURRENT DATE/TIME SPECIAL REGISTER IS INVALID. OUT OF RANGE.

-186 LOCAL DATE OR TIME LENGTH HAS BEEN INCREASED.

-185 LOCAL FORMAT OPTION USED WITH DATE OR TIME AND NO LOCAL EXIT INSTALLED.

-184 ARITHMETIC EXPRESSION WITH A DATETIME VALUE CONTAINS A PARAMETER MARKER

-183 ARITHMETIC OPERATION ON A DATE OR TIMESTAMP HAS AN INVALID RESULT

-182 AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE IS INVALID

-181 THE STRING REPRESENTATION OF A DATETIME VALUE IS NOT A VALID DATETIME VALUE

-180 THE DATE, TIME, OR TIMESTAMP VALUE IS INVALID

-173 UR IS SPECIFIED ON THE WITH CLAUSE BUT THE CURSOR IS NOT READ-ONLY

-171 THE DATA TYPE, LENGTH, OR VALUE OF ARGUMENT OF IS INVALID

-170 THE NUMBER OF ARGUMENTS SPECIFIED FOR IS INVALID

-164 DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION

-161 THE INSERT OR UPDATE IS NOT ALLOWED

-160 THE WITH CHECK OPTION CANNOT BE USED FOR THE SPECIFIED VIEW

-159 DROP OR COMMENT ON IDENTIFIES A(N) RATHER THAN A(N)

-158 NUMBER OF COLUMNS FOR VIEW NOT SAME AS SELECT CLAUSE.

-157 ONLY A TABLE NAME CAN BE SPECIFIED IN A FOREIGN KEY CLAUSE.

-156 THE STATEMENT DOES NOT IDENTIFY A TABLE

-154 THE STATEMENT IS INVALID BECAUSE THE VIEW OR TABLE DEFINITION IS NOT VALID

-153 VIEW OR TABLE DEFINITION DOES NOT INCLUDE A UNIQUE NAME FOR EACH COLUMN

-152 THE DROP CLAUSE IN THE ALTER STATEMENT IS INVALID BECAUSE IS A

-151 CATALOG DESCRIPTION OF COLUMN INDICATES THAT IT CANNOT BE UPDATED

-150 REQUESTED OPERATION IS NOT PERMITTED

-148 THE SOURCE TABLE CANNOT BE RENAMED OR ALTERED

-147 ALTER FUNCTION FAILED BECAUSE SOURCE FUNCTIONS CANNOT BE ALTERED

-144 INVALID SECTION NUMBER

-142 THE SQL STATEMENT IS NOT SUPPORTED

-138 THE SECOND OR THIRD ARGUMENT OF THE SUBSTR FUNCTION IS OUT OF RANGE

-137 THE LENGTH RESULTING FROM IS GREATER THAN

-136 KEY LENGTH IS GREATER THAN 4000 BYTES

-134 IMPROPER USE OF LONG STRING COLUMN

-133 A COLUMN FUNCTION IN A SUBQUERY OF A HAVING CLAUSE IS INVALID

-132 AN OPERAND OF x IS NOT VALID

-131 STATEMENT WITH LIKE PREDICATE HAS INCOMPATIBLE DATA TYPES

-130 ESCAPE CLAUSE CONSISTS OF MORE THAN ONE CHARACTER

-129 THE STATEMENT CONTAINS TOO MANY TABLE NAMES

-128 INVALID USE OF NULL IN A PREDICATE

-127 DISTINCT IS SPECIFIED MORE THAN ONCE IN A SUBSELECT

-126 THE SELECT STATEMENT CONTAINS BOTH AN UPDATE CLAUSE AND AN ORDER BY CLAUSE

-125 AN INTEGER IN THE ORDER BY CLAUSE DOES NOT IDENTIFY A COLUMN OF THE RESULT

-123 THE PARAMETER IN POSITION IN THE FUNCTION MUST BE A CONSTANT OR KEYWORD

-122 FUNCTION IN SELECT CLAUSE WITH NO GROUP BY CLAUSE

-121 THE COLUMN IS IDENTIFIED MORE THAN ONCE IN THE INSERT OR UPDATE

-120 WHERE CLAUSE INCLUDES COLUMN FUNCTION

-119 COLUMN IDENTIFIED IN A HAVING CLAUSE IS NOT INCLUDED IN THE GROUP BY CLAUSE

-118 TABLE OR VIEW OF DELETE OR UPDATE IS ALSO IN A FROM CLAUSE

-117 NUMBER OF ASSIGNED VALUES NOT THE SAME AS THE NUMBER OF COLUMNS

-115 COMPARISON OPERATOR IS FOLLOWED BY A PARENTHESIZED LIST WITHOUT A SUBQUERY

-114 THE LOCATION NAME DOES NOT MATCH THE CURRENT SERVER

-113 INVALID CHARACTER FOUND

-112 THE OPERAND OF A COLUMN FUNCTION IS ANOTHER COLUMN FUNCTION

-111 A COLUMN FUNCTION DOES NOT INCLUDE A COLUMN NAME

-110 INVALID HEXADECIMAL LITERAL BEGINNING

-109 CLAUSE IS NOT PERMITTED

-108 THE NAME IS QUALIFIED INCORRECTLY

-107 THE NAME IS TOO LONG. MAXIMUM ALLOWABLE SIZE IS

-105 INVALID STRING

-104 ILLEGAL SYMBOL "". SOME SYMBOLS THAT MIGHT BE LEGAL ARE:

-103 IS AN INVALID NUMERIC LITERAL

-102 LITERAL STRING IS TOO LONG. STRING BEGINS

-101 THE STATEMENT IS TOO LONG OR TOO COMPLEX

-097 THE USE OF LONG VARCHAR OR LONG VARGRAPHIC IS NOT ALLOWED IN THIS CONTEXT

-084 UNACCEPTABLE SQL STATEMENT

-079 QUALIFIER FOR DECLARED GLOBAL TEMPORARY TABLE OR INDEX MUST BE SESSION.

-060 INVALID SPECIFICATION

-029 INTO CLAUSE REQUIRED

-010 THE STRING CONSTANT BEGINNING IS NOT TERMINATED

-007 STATEMENT CONTAINS THE ILLEGAL CHARACTER

+

+000 SUCCESSFUL EXECUTION

+012 Warning: UNQUALIFIED COLUMN NAME WAS INTERPRETED AS A CORRELATED REFERENCE

+098 Warning: A DYNAMIC SQL STATEMENT ENDS WITH A SEMICOLON

+100 Warning: NOT FOUND.

+110 Warning: UPDATE TO DATA CAPTURE TABLE NOT SIGNALED TO ORIGINATING SUBSYSTEM

+111 Warning: SUBPAGES OPTION IS NOT SUPPORTED FOR TYPE 2 INDEXES

+117 Warning: NUMBER OF INSERT VALUES IS NOT THE SAME AS THE NUMBER OF COLUMNS

+162 Warning: TABLE SPACE . HAS BEEN PLACED IN CHECK PENDING

+203 Warning: QUALIFIED COLUMN NAME RESOLVED USING NON-UNIQUE OR UNEXPOSED NAME

+204 Warning: UNDEFINED NAME

+206 Warning: NOT A COLUMN OF INSERTED, UPDATED, OR ANY TABLE IN FROM CLAUSE

+218 Warning: THE SQL STATEMENT REFERENCING A REMOTE OBJECT CANNOT BE EXPLAINED

+219 Warning: THE REQUIRED EXPLANATION TABLE DOES NOT EXIST

+220 Warning: THE COLUMN IN EXPLANATION TABLE IS NOT DEFINED PROPERLY

+236 Warning: SQLDA INCLUDES SQLVAR ENTRIES, BUT ARE REQUIRED FOR COLUMNS

+237 Warning: SQLDA INCLUDES SQLVAR ENTRIES, BUT ARE REQUIRED ONE OF THE COLUMNS

+238 Warning: SQLDA INCLUDES SQLVAR ENTRIES, BUT SQLVAR ENTRIES ARE NEEDED

+239 Warning: SQLDA INCLUDES SQLVAR ENTRIES, BUT ARE REQUIRED FOR COLUMNS

+304 Warning: A VALUE WITH DATA TYPE CANNOT BE ASSIGNED TO A HOST VARIABLE

+331 Warning: NULL VALUE HAS BEEN ASSIGNED TO A HOST VARIABLE

+339 Warning: SUCCESSFULLY EXECUTED BUT MAY BE CONVERSION INCONSISTENCIES

+394 Warning: USER SPECIFIED OPTIMIZATION HINTS USED IN ACCESS PATH SELECTION

+395 Warning: USER SPECIFIED OPTIMIZATION HINTS ARE INVALID

+402 Warning: LOCATION IS UNKNOWN

+403 Warning: LOCAL OBJECT REFERENCED BY CREATE ALIAS DOES NOT EXIST

+434 Warning: OPTION IS A DEPRECATED FEATURE

+445 Warning: VALUE HAS BEEN TRUNCATED

+462 Warning: EXTERNAL FUNCTION OR PROCEDURE HAS RETURNED A WARNING SQLSTATE

+464 Warning: PROCEDURE RETURNED QUERY RESULT SETS, WHICH EXCEEDS DEFINED LIMIT

+466 Warning: PROCEDURE RETURNED QUERY RESULT SETS

+494 Warning: NUMBER OF RESULT SETS IS GREATER THAN NUMBER OF LOCATORS

+495 Warning: ESTIMATED PROCESSOR COST EXCEEDS A RESOURCE LIMIT WARNING

+535 Warning: RESULT OF POSITIONED UPDATE OR DELETE MAY DEPEND ON ORDER OF ROWS

+541 Warning: REFERENTIAL OR UNIQUE CONSTRAINT IS DUPLICATE

+551 Warning: DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION ON OBJECT

+552 Warning: DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION

+558 Warning: THE WITH GRANT OPTION IS IGNORED

+561 Warning: TRIGGER PRIVILEGES CANNOT BE GRANTED TO PUBLIC AT ALL LOCATIONS

+562 Warning: GRANTEE ALREADY HAS THE PRIVILEGE FROM THE GRANTOR

+585 Warning: THE SCHEMA NAME APPEARS MORE THAN ONCE IN THE CURRENT PATH

+599 Warning: COMPARISON FUNCTIONS ARE NOT CREATED FOR A DISTINCT TYPE

+610 Warning: A CREATE/ALTER ON OBJECT HAS PLACED OBJECT IN PENDING

+625 Warning: THE DEFINITION OF TABLE HAS BEEN CHANGED TO INCOMPLETE

+626 Warning: DROPPING INDEX TERMINATES ENFORCEMENT OF THE UNIQUENESS OF A KEY

+645 Warning: INDEX KEY CANNOT CONTAIN NULL VALUES

+650 Warning: TABLE BEING CREATED OR ALTERED CAN NOT BECOME A DEPENDENT TABLE

+653 Warning: PARTITIONED INDEX HAS NOT BEEN CREATED

+655 Warning: STOGROUP HAS BOTH SPECIFIC AND NON-SPECIFIC VOLUME IDS.

+658 Warning: THE SUBPAGES VALUE IS IGNORED FOR THE CATALOG INDEX

+664 Warning: INTERNAL LENGTH OF LIMIT-KEY FIELDS EXCEEDS THE LENGTH LIMIT

+738 Warning: DEF. CHANGE OF MAY REQUIRE SIMILAR CHANGE ON READ-ONLY SYSTEMS

+799 Warning: SET STATEMENT REFERENCES A SPECIAL REGISTER THAT DOES NOT EXIST

+802 Warning: EXCEPTION ERROR HAS OCCURRED DURING OPERATION ON DATA, POSITION

+806 Warning: BIND ISOLATION LEVEL RR CONFLICTS WITH TABLESPACE LOCKSIZE

+807 Warning: THE RESULT OF DECIMAL MULTIPLICATION MAY CAUSE OVERFLOW

+863 Warning: THE CONNECTION WAS SUCCESSFUL BUT ONLY SBCS WILL BE SUPPORTED

+883 Warning: ROLLBACK TO SAVEPOINT . THERE WERE OPERATIONS CANNOT BE UNDONE.

/*                                               2011/2012  MCSERRA  */