SQL Return Codes SQL SQL Code Explanation State ---- ----------- ----- +000 SUCCESSFUL EXECUTION 00000 -007 STATEMENT CONTAINS THE ILLEGAL 42601 CHARACTER character -010 STRING CONSTANT BEGINNING string IS 42603 NOT TERMINATED +012 THE UNQUALIFIED COLUMN NAME column-name 01545 WAS INTERPRETED AS A CORRELATED REFERENCE -029 INTO CLAUSE REQUIRED 42601 -060 INVALID type SPECIFICATION: spec 42815 -084 UNACCEPTABLE SOL STATEMENT 42612 +098 A DYNAMIC SQL STATEMENT ENDS WITH 01568 A SEMICOLON +100 ROW NOT FOUND FOR FETCH, UPDATE 02000 OR DELETE, OR THE RESULT OF A QUERY IS AN EMPTY TABLE -101 THE STATEMENT IS TOO LONG OR TOO COMPLEX 54001 -102 LITERAL STRING IS TOO LONG. STRING 54002 BEGINS string -103 literal IS AN INVALID NUMERIC LITERAL 42604 -104 ILLEGAL SYMBOL "token". SOME SYMBOLS 42601 THAT MIGHT BE LEGAL ARE: token-list -105 INVALID STRING 42604 -107 THE NAME name IS TOO LONG. MAXIMUM 42622 ALLOWABLE SIZE IS size -109 clause CLAUSE IS NOT PERMITTED 42601 +110 SQL UPDATE TO A DATA CAPTURE TABLE 01561 NOT SIGNALED TO ORIGINATING SUBSYSTEM -110 INVALID HEXADECIMAL LITERAL BEGINNING 42606 string +111 THE SUBPAGES OPTION IS NOT SUPPORTED 01590 FOR TYPE 2 INDEXES -111 A COLUMN FUNCTION DOES NOT INCLUDE 42901 A COLUMN NAME -112 THE OPERAND OF A COLUMN FUNCTION 42607 IS ANOTHER COLUMN FUNCTION -113 INVALID CHARACTER FOUND IN string, 42602 REASON CODE - nnn -114 THE LOCATION NAME location DOES NOT 42961 MATCH THE CURRENT SERVER -115 A PREDICATE IS INVALID BECAUSE THE 42601 COMPARISON OPERATOR operator IS FOLLOWED BY A PARENTHESIZED LIST OR BY ANY OR ALL WITHOUT A SUBOUERY +117 THE NUMBER OF INSERT VALUES IS NOT 01525 THE SAME AS THE NUMBER OF OBJECT COLUMNS -117 THE NUMBER OF INSERT VALUES IS NOT 42802 THE SAME AS THE NUMBER OF OBJECT COLUMNS -118 THE OBJECT TABLE OR VIEW OF THE 42902 INSERT, DELETE, OR UPDATE STATEMENT IS ALSO IDENTIFIED IN A FROM LLAUSE -119 A COLUMN IDENTIFIED IN A HAVING CLAUSE 42803 IS NOT INCLUDED IN THE GROUP BY CLAUSE -120 A WHERE CLAUSE OR SET CLAUSE INCLUDES 42903 A COLUMN FUNCTION -121 THE COLUMN name IS IDENTIFIED MORE 42701 THAN ONCE IN THE INSERT OR UPDATE STATEMENT -122 A SELECT STATEMENT WITH NO GROUP 42803 BY CLAUSE CONTAINS A COLUMN NAME AND A COLUMN FUNCTION IN THE SELECT CLAUSE OR A COLUMN NAME IS CONTAINED IN THE SELECT CLAUSE BUT NOT IN THE GROUP BY CLAUSE -125 AN INTEGER IN THE ORDER BY CLAUSE DOES 42805 NOT IDENTIFY A COLUMN OF THE RESULT -126 THE SELECT STATEMENT CONTAINS BOTH AN 42829 UPDATE CLAUSE AND AN ORDER BY CLAUSE -127 DISTINCT IS SPECIFIED MORE THAN 42905 ONCE IN A SUBSELECT -128 INVALID USE OF NULL IN A PREDICATE 42601 -129 THE STATEMENT CONTAINS TOO MANY 54004 TABLE NAMES -130 THE ESCAPE CLAUSE CONSISTS OF 22019 MORE THAN ONE CHARACTER, OR THE STRING PATTERN CONTAINS AN INVALID OCCURRENCE OF THE ESCAPE CHARACTER -131 STATEMENT WITH LIKE PREDICATE HAS 42818 INCOMPATIBLE DATA TYPES -132 A LIKE PREDICATE IS INVALID BECAUSE 42824 THE SECOND OPERAND IS NOT A STRING -133 A COLUMN FUNCTION IN A SUBQUERY OF 42906 A HAVING CLAUSE IS INVALID BECAUSE ALL COLUMN REFERENCES IN ITS ARGUMENT ARE NOT CORRELATED TO THE GROUP BY RESULT THAT THE HAVING CLAUSE IS APPLIED TO -134 IMPROPER USE OF LONG STRING COLUMN 42907 Column-name OR A HOST VARIABLE OF MAXIMUM LENGTH GREATER THAN 254 -136 SORT CANNOT BE EXECUTED BECAUSE THE SORT 54005 KEY LENGTH IS GREATER THAN 4000 BYTES -137 RESULT OF CONCATENATION TOO LONG 54006 -138 THE SECOND OR THIRD ARGUMENT OF 22011 THE SUBSTR FUNCTION IS OUT OF RANGE -144 INVALID SECTION NUMBER number 58003 -150 THE OBJECT OF THE INSERT, DELETE, 42807 OR UPDATE STATEMENT IS A VIEW FOR WHICH THE REQUESTED OPERATION IS NOT PERMITTED -151 THE UPDATE STATEMENT IS INVALID BECAUSE 42808 THE CATALOG DESCRIPTION OF COLUMN column-name INDICATES THAT IT CANNOT BE UPDATED -152 THE DROP clause CLAUSE IN THE ALTER 42809 STATEMENT IS INVALID BECAUSE constraint-name IS A constraint-type -153 THE CREATE VIEW STATEMENT DOES 42908 NOT INCLUDE A REQUIRED COLUMN LIST -154 THE CREATE VIEW FAILED BECAUSE THE 42909 VIEW DEFINITION CONTAINS A UNION, A UNION ALL, OR A REMOTE OBJECT -156 THE STATEMENT DOES NOT IDENTIFY A TABLE 42809 -157 ONLY A TABLE NAME CAN BE SPECIFIED 42810 IN A FOREIGN KEY CLAUSE. object-name IS -158 THE NUMBER OF COLUMNS SPECIFIED 42811 FOR THE VIEW IS NOT THE SAME AS THE NUMBER OF COLUMNS SPECIFIED BY THE SELECT CLAUSE -159 DROP OR COMMENT ON token IDENTIFIES 42809 1 A(N) token RATHER THAN A(N) token -160 THE WITH CHECK OPTION CANNOT BE 42813 USED FOR THE SPECIFIED VIEW -161 THE INSERT OR UPDATE IS NOT ALLOWED 44000 BECAUSE A RESULTING ROW DOES NOT SATISFY THE VIEW DEFINITION +162 TABLESPACE database-name.tablespace-name 01514 HAS BEEN PLACED IN CHECK PENDING -164 auth-id1 DOES NOT HAVE THE PRIVILEGE 42502 TO CREATE A VIEW WITH QUALIFICATION auth-id2 -170 THE NUMBER OF ARGUMENTS SPECIFIED 42605 FOR function-name IS INVALID -171 THE DATA TYPE, LENGTH, OR VALUE OF 42815 ARGUMENT nn OF function-name IS INVALID -173 UR IS SPECIFIED ON THE WITH CLAUSE 42801 BUT THE CURSOR IS NOT READ-ONLY -180 THE STRING REPRESENTATION OF A 22007 DATETIME VALUE HAS INVALID SYNTAX -181 THE STRING REPRESENTATION OF A 22007 DATETIME VALUE IS NOT A VALID DATETIME VALUE -182 AN ARITHMETIC EXPRESSION WITH 42816 DATETIME VALUE IS INVALID -183 AN ARITHMETIC OPERATION ON A DATE 22008 OR TIMESTAMP HAS A RESULT THAT IS NOT WITHIN VALID RANGE OF DATES -184 AN ARITHMETIC EXPRESSION WITH A 42610 DATETIME VALUE CONTAINS A PARAMETER MARKER -185 THE LOCAL FORMAT OPTION HAS BEEN 57008 USED WITH A DATE OR TIME AND NO LOCAL EXIT HAS BEEN INSTALLED -186 THE LOCAL DATE LENGTH OR LOCAL 22505 TIME LENGTH HAS BEEN INCREASED AND EXECUTING PROGRAM RELIES ON THE OLD LENGTH -187 A REFERENCE TO A CURRENT DATE/TIME 22506 SPECIAL REGISTER IS INVALID BECAUSE THE MVS TOD CLOCK IS BAD OR THE MVS PARMTZ IS OUT OF RANGE -188 THE STRING REPRESENTATION OF A 22503 NAME IS INVALID -189 CCSID ccsid IS UNKNOWN OR INVALID 22522 FOR THE DATA TYPE OR SUBTYPE -191 A STRING CANNOT BE USED BECAUSE IT 22504 IS INVALID MIXED DATA -197 QUALIFIED COLUMN NAMES IN ORDER BY 42877 CLAUSE NOT PERMITTED WHEN UNION OR UNION ALL SPECIFIED -198 THE OPERAND OF THE PREPARE OR 42617 EXECUTE IMMEDIATE STATEMENT IS BLANK OR EMPTY -199 ILLEGAL USE OF KEYWORD keyword. TOKEN 42601 token-list WAS EXPECTED +203 THE QUALIFIED COLUMN NAME column-name 01552 WAS RESOLVED USING A NON-UNIQUE OR UNEXPOSED NAME -203 A REFERENCE TO COLUMN column-name 42702 IS AMBIGUOUS +204 name IS AN UNDEFINED NAME 01532 -204 name IS AN UNDEFINED NAME 42704 -205 column-name IS NOT A COLUMN OF TABLE 42703 table-name +206 column-name IS NOT A COLUMN OF AN 01533 INSERTED TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE -206 column-name IS NOT A COLUMN OF AN 42703 INSERTED TABLE, UPDATED TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE -208 THE ORDER BY CLAUSE IS INVALID BECAUSE 42707 COLUMN name IS NOT PART OF THE RESULT TABLE +218 THE SQL STATEMENT REFERENCING A 01537 REMOTE OBJECT CANNOT BE EXPLAINED +219 THE REQUIRED EXPLANATION TABLE 01532 table-name DOES NOT EXIST -219 THE REQUIRED EXPLANATION TABLE 42704 table-name DOES NOT EXIST +220 THE COLUMN column-name IN EXPLANATION 01546 TABLE table-name IS NOT DEFINED PROPERLY -220 THE COLUMN column-name IN EXPLANATION 55002 TABLE table-name IS NOT DEFINED PROPERLY -221 "SET OF OPTIONAL COLUMNS" IN EXPLANATION 55002 TABLE table-name IS INCOM- PLETE. OPTIONAL COLUMN column-name IS MISSING -250 THE LOCAL LOCATION NAME IS NOT DEFINED 42718 WHEN PROCESSING A THREE-PART OBJECT NAME -251 TOKEN name IS NOT VALID 42602 -300 THE STRING CONTAINED IN HOST VARIABLE 22024 OR PARAMETER position-number IS NOT NUL-TERMINATED -301 THE VALUE OF INPUT HOST VARIABLE OR 42895 PARAMETER NUMBER position-number CANNOT BE USED AS SPECIFIED BECAUSE OF ITS DATA TYPE -302 THE VALUE OF INPUT VARIABLE OR PARAMETER 22001 NUMBER position-number IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET VALUE -303 A VALUE CANNOT BE ASSIGNED TO OUTPUT 42806 HOST VARIABLE NUMBER position-number BECAUSE THE DATA TYPES ARE NOT COMPARABLE +304 A VALUE WITH DATA TYPE data-typel 01515 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 -304 A VALUE WITH DATA TYPE data-typel 22003 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 22002 TO OUTPUT HOST VARIABLE NUMBER position-number BECAUSE NO INDICATOR VARIABLE IS SPECIFIED -309 A PREDICATE IS INVALID BECAUSE A 22512 REFERENCED HOST VARIABLE HAS THE NULL VALUE -310 DECIMAL HOST VARIABLE OR PARAMETER 22023 number CONTAINS NON DECIMAL DATA. -311 THE LENGTH OF INPUT HOST VARIABLE 22501 NUMBER position-number IS NEGATIVE OR GREATER THAN THE MAXIMUM -312 UNDEFINED OR UNUSABLE HOST VARIABLE 42618 variable-name -313 THE NUMBER OF HOST VARIABLES 07001 SPECIFIED IS NOT EQUAL TO THE NUMBER OF PARAMETER MARKERS -314 THE STATEMENT CONTAINS AN AMBIGUOUS 42714 HOST VARIABLE REFERENCE -330 A STRING CANNOT BE USED BECAUSE IT 22021 CANNOT BE TRANSLATED. REASON reason-code, CHARACTER code-point, HOST VARIABLE position-number +331 THE NULL VALUE HAS BEEN ASSIGNED 01520 TO A HOST VARIABLE BECAUSE THE STRING CANNOT BE TRANSLATED. REASON reason-code, CHARACTER code-point, HOST VARIABLE position number -331 A STRING CANNOT BE ASSIGNED TO A 22021 HOST VARIABLE BECAUSE IT CANNOT BE TRANSLATED. REASON reason-code, CHARACTER code-point, POSITION position I number -332 SYSSTRINGS DOES NOT DEFINE A 57017 TRANSLATION FROM CCSID ccsid TO ccsid -333 THE SUBTYPE OF A STRING VARIABLE IS 56010 NOT THE SAME AS THE SUBTYPE KNOWN AT BIND TIME AND THE DIFFERENCE CANNOT BE RESOLVED BY TRANSLATION -338 AN ON CLAUSE IS INVALID 42972 +339 THE SQL STATEMENT HAS BEEN SUCCESSFULLY 01569 EXECUTED, BUT THERE MAY BE SOME CHARACTER CONVERSION INCONSISTENCIES -339 THE SOL STATEMENT CANNOT BE EXECUTED 56082 FROM AN ASCII BASED DRDA APPLICATION REQUESTOR TO A V2R2 DB2 SUBSYSTEM -400 THE CATALOG HAS THE MAXIMUM NUMBER 54027 OF USER DEFINED INDEXES -401 THE OPERANDS OF AN ARITHMETIC OR 42818 COMPARISON OPERATION ARE NOT COMPARABLE +402 LOCATION location IS UNKNOWN 01521 -402 AN ARITHMETIC FUNCTION OR OPERATOR 42819 arith-fop IS APPLIED TO CHARACTER OR DATETIME DATA +403 THE LOCAL OBJECT REFERENCED BY 01522 THE CREATE ALIAS STATEMENT DOES NOT EXIST -404 THE UPDATE OR INSERT STATEMENT 22001 SPECIFIES A STRING THAT IS TOO LONG column-name -405 THE NUMERIC LITERAL literal CANNOT BE 42820 USED AS SPECIFIED BECAUSE IT IS OUT OFRANGE -406 A CALCULATED OR DERIVED NUMERI 22003 VALUE IS NOT WITHIN THE RANGE OF TS OBJECT COLUMN -407 AN UPDATE OR INSERT VALUE IS NULL, 23502 BUT THE OBJECT COLUMN column-name CANNOT CONTAIN NULL VALUES -408 AN UPDATE OR INSERT VALUE IS NOT 42821 COMPARABLE WITH THE DATA TYPE OF ITS OBJECT COLUMN column-name -409 INVALID OPERAND OF A COUNT FUNCTION 42607 -410 THE FLOATING POINT LITERAL literal 42820 CONTAINS MORE THAN 30 CHARACTERS -411 CURRENT SOLID CANNOT BE USED IN A 56040 STATEMENT THAT REFERENCES REMOTE OBJECTS -412 THE SELECT CLAUS OF A SUBQUERY 42823 SPECIFIES MULTIPLE COLUMNS -414 A LIKE PREDICATE IS INVALID BECAUSE 42824 THE FIRST OPERAND IS NOT A STRING -415 THE CORRESPONDING COLUMNS, column- 42825 number, OF THE OPERANDS OF A UNION OR A UNION ALL DO NOT HAVE COMPARABLE COLUMN DESCRIPTIONS -416 AN OPERAND OF A UNION CONTAINS A 42907 LONG STRING COLUMN -417 A STATEMENT STRING TO BE PREPARED 42609 INCLUDES PARAMETER MARKERS AS THE OPERANDS OF THE SAME OPERATOR -418 A STATEMENT STRING TO BE PREPARED 42610 CONTAINS AN INVALID USE OF PARAMETER MARKERS -419 THE DECIMAL DIVIDE OPERATION IS INVALID 42911 BECAUSE THE RESULT WOULD HAVE A NEGATIVE SCALE -420 THE VALUE OF A CHARACTER STRING 22018 ARGUMENT WAS NOT ACCEPTABLE TO THE function-name FUNCTION -421 THE OPERANDS OF A UNION OR UNION-ALL 42826 DO NOT HAVE THE SAME NUMBER OF COLUMNS -426 DYNAMIC COMMIT NOT VALID AT AN 2D528 APPLICATION SERVER WHERE UPDATES ARE NOT ALLOWED -427 DYNAMIC ROLLBACK NOT VALID AT AN 2D529 APPLICATION SERVER WHERE UPDATES ARE NOT ALLOWED -440 THE NUMBER OF PARAMETERS IN THE 42884 PARAMETER LIST DOES NOT MATCH THE NUMBER OF PARAMETERS EXPECTED FOR STORED PROCEDURE name, AUTHID authid, LUNAME luname.number PARAMETERS WERE EXPECTED. -444 USER PROGRAM name COULD NOT BE 42724 FOUND -450 STORED PROCEDURE name, PARAMETER 39501 NUMBER number, OVERLAYED STORAGE BEYOND ITS DECLARED LENGTH -469 SQL CALL STATEMENT MUST SPECIFY AN 42886 OUTPUT HOST VARIABLE FOR PARAMETER number. -470 SQL CALL STATEMENT SPECIFIED A NULL 39002 VALUE FOR INPUT PARAMETER number, BUT THE STORED PROCEDURE DOES NOT SUPPORT NULL VALUES. -471 SQL CALL FOR STORED PROCEDURE 55023 name FAILED DUE TO REASON rc -500 THE IDENTIFIED CURSOR WAS CLOSED 24501 WHEN THE CONNECTION WAS DESTROYED -501 THE CURSOR IDENTIFIED IN A FETCH OR 24501 CLOSE STATEMENT IS NOT OPEN -502 THE CURSOR IDENTIFIED IN AN OPEN 24502 STATEMENT IS ALREADY OPEN -503 A COLUMN CANNOT BE UPDATED BECAUSE 42912 IT IS NOT IDENTIFIED IN THE UPDATE CLAUSE OF THE SELECT STATEMENT OF THE CURSOR -504 THE CURSOR NAME cursor-name IS NOT 34000 DEFINED -507 THE CURSOR IDENTIFIED IN THE UPDATE 24501 OR DELETE STATEMENT IS NOT OPEN -508 THE CURSOR IDENTIFIED IN THE UPDATE 24504 OR DELETE STATEMENT IS NOT POSITIONED ON A ROW -509 THE TABLE IDENTIFIED IN THE UPDATE 42827 OR DELETE STATEMENT IS NOT THE SAME TABLE DESIGNATED BY THE CURSOR -510 THE TABLE DESIGNATED BY THE CURSOR 42828 OF THE UPDATE OR DELETE STATEMENT CANNOT BE MODIFIED -511 THE FOR UPDATE CLAUSE CANNOT BE 42829 SPECIFIED BECAUSE THE TABLE DESIGNATED BY THE CURSOR CANNOT BE MODIFIED -512 STATEMENT REFERENCE TO REMOTE 56023 OBJECT IS INVALID -513 THE ALIAS alias-name MUST NOT BE DEFINED 42924 ON ANOTHER LOCAL OR REMOTE ALIAS -514 THE CURSOR cursor-name IS NOT IN A 26501 PREPARED STATE -516 THE DESCRIBE STATEMENT DOES NOT 26501 IDENTIFY A PREPARED STATEMENT -517 CURSOR cursor-name CANNOT BE USED 07005 BECAUSE ITS STATEMENT NAME DOES NOT IDENTIFY A PREPARED SELECT STATEMENT -518 THE EXECUTE STATEMENT DOES NOT 07003 IDENTIFY A VALID PREPARED STATEMENT -519 THE PREPARE STATEMENT IDENTIFIES 24506 THE SELECT STATEMENT OF THE OPENED CURSOR cursor-name -525 THE SQL STATEMENT CANNOT BE EXECUTED 51015 BECAUSE IT WAS IN ERROR AT BIND TIME FOR SECTION = sectno PACKAGE = pkgname CONSISTENCY TOKEN X'contoken' -530 THE INSERT OR UPDATE VALUE OF FOREIGN 23503 KEY constraint-name IS INVALID -531 THE PRIMARY KEY IN A PARENT ROW 23504 CANNOT BE UPDATED BECAUSE IT HAS ONE OR MORE DEPENDENT ROWS IN RELATIONSHIP constraint-name -532 THE RELATIONSHIP constraint-name RESTRICTS 23504 THE DELETION OF ROW WITH RID X'rid-number' -533 INVALID MULTIPLE-ROW INSERT 21501 -534 THE PRIMARY KEY CANNOT BE UPDATED 21502 BECAUSE OF MULTIPLE-ROW UPDATE +535 THE RESULT OF THE POSITIONED UPDATE 01591 OR DELETE MAY DEPEND ON THE ORDER OF THE ROWS. -536 THE DELETE STATEMENT IS INVALID BECAUSE 42914 TABLE table-name CAN BE AFFECTED BY THE OPERATION -537 THE PRIMARY KEY CLAUSE, A FOREIGN 42709 KEY CLAUSE, OR A UNIQUE CLAUSE IDENTIFIES COLUMN column-name MORE THAN ONCE -538 FOREIGN KEY name DOES NOT CONFORM 42830 TO THE DESCRIPTION OF THE PRIMARY KEY OF TABLE table-name -539 TABLE table-name DOES NOT HAVE A 42888 PRIMARY KEY -540 THE DEFINITION OF TABLE table-name IS 57001 INCOMPLETE BECAUSE IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE INDE +541 THE REFERENTIAL OR UNIQUE CONSTRAINT 01543 name HAS BEEN IGNORED BECAUSE IT IS A DUPLICATE -542 column-name CANNOT BE A COLUMN OF A 42831 PRIMARY KEY OR A UNIQUE CONSTRAINT BECAUSE IT CAN CONTAIN NULL VALUES -543 A ROW IN A PARENT TABLE CANNOT BE 23511 DELETED BECAUSE THE CHECK CONSTRAINT check-constraint RESTRICTS THE DELETION -544 THE CHECK CONSTRAINT SPECIFIED IN 23512 THE ALTER TABLE STATEMENT CANNOT BE ADDED BECAUSE AN EXISTING ROW VIOLATES THE CHECK CONSTRAINT -545 THE REQUESTED OPERATION IS NOT 23513 ALLOWED BECAUSE A ROW DOES NOT SATISFY THE CHECK CONSTRAINT check-constraint -546 THE CHECK CONSTRAINT constraint-name 42621 IS INVALID -548 A CHECK CONSTRAINT THAT IS DEFINED 42621 WITH column-name IS INVALID -549 THE statement STATEMENT IS NOT ALLOWED 42509 FOR object-typel object-name BECAUSE THE BIND OPTION DYNAMIC-RULES(BIND) IN THE object-type2 IS IN EFFECT. +551 auth-id DOES NOT HAVE THE PRIVILEGE 01548 TO PERFORM OPERATION operation ON OBJECT object-name -551 auth-id DOES NOT HAVE THE PRIVILEGE 42501 TO PERFORM OPERATION operation ON OBJECT object-name +552 auth-id DOES NOT HAVE THE PRIVILEGE 01542 TO PERFORM OPERATION operation -552 auth-id DOES NOT HAVE THE PRIVILEGE 42502 TO PERFORM OPERATION operation -553 auth-id SPECIFIED IS NOT ONE OF THE 42503 VALID AUTHORIZATION IDS -554 AN AUTHORIZATION ID CANNOT GRANT A 42502 PRIVILEGE TO ITSELF -555 AN AUTHORIZATION ID CANNOT REVOKE 42502 A PRIVILEGE FROM ITSELF -556 auth-id2 CANNOT HAVE THE privilege 42504 PRIVILEGE on-object REVOKED BY auth-idl BECAUSE THE REVOKEE DOES NOT POSSESS THE PRIVILEGE OR THE REVOKER DID NOT MAKE THE GRANT. -557 INCONSISTENT GRANT/REVOKE KEYWORD 42852 keyword. PERMITTED KEYWORDS ARE keyword-list +558 THE WITH GRANT OPTION IS IGNORED 01516 -558 INVALID CLAUSE OR COMBINATION OF 56025 CLAUSES ON A GRANT OR REVOKE -559 ALL AUTHORIZATION FUNCTIONS HAVE 57002 BEEN DISABLED +561 THE ALTER, INDEX, AND REFERENCES 01523 PRIVILEGES CANNOT BE GRANTED TO PUBLIC AT ALL LOCATIONS +562 A GRANT OF A PRIVILEDGE WAS IGNORED 01560 BECAUSE THE GRANTEE ALREADY HAS THE PRIVILEGE FROM THE GRANTOR -567 bind-type AUTHORIZATION ERROR USING 42501 auth-id AUTHORITY PACKAGE = package-name PRIVILEGE = privilege -571 THE STATEMENT WOULD RESULT IN A 25000 MULTIPLE SITE UPDATE -574 THE SPECIFIED DEFAULT VALUE 42894 CONFLICTS WITH THE COLUMN DEFINITION -601 THE NAME OF THE OBJECT TO BE CREATED 42710 IS IDENTICAL TO THE EXISTING NAME name OF THE OBJECT TYPE obj-type -602 TOO MANY COLUMNS SPECIFIED IN A 54008 CREATEINDEX -603 A UNIQUE INDEX CANNOT BE CREATED 23515 BECAUSE THE TABLE CONTAINS ROWS WHICH ARE DUPLICATES WITH RESPECT TO THE VALUES OF THE IDENTIFIED COLUMNS -604 A COLUMN DEFINITION SPECIFIES AN 42611 INVALID LENGTH, PRECISION, OR SCALE ATTRIBUTE -667 OPERATION OR OPTION operation IS NOT 42832 DEFINED FOR THIS OBJECT +610 INDEX index-name HAS BEEN PLACED IN 01566 RECOVER PENDING -611 ONLY LOCKMAX 0 CAN BE SPECIFIED 53088 WHEN THE LOCK SIZE OF THE TABLESPACE IS TABLESPACE OR TABLE. -612 column-name IS A DUPLICATE COLUMN 42711 NAME -613 THE PRIMARY KEY OR A UNIQUE CONSTRAINT 54008 3S TOO LONG OR HAS TOO MANY COLUMNS -614 THE INDEX CANNOT BE CREATED BECAUSE 54008 THE SUM OF THE INTERNAL LENGTHS OF THE IDENTIFIED COLUMNS IS GREATER THAN THE ALLOWABLE MAXIMUM -615 operation-type IS NOT ALLOWED ON A 55006 PACKAGE IN USE -616 obj-typel obj-namel CANNOT BE DROPPED 42893 BECAUSE IT IS REFERENCED BY obj-type2 obJ-name2 -617 A TYPE 1 INDEX CANNOT BE DEFINED ON 56089 A TABLE IN A TABLE SPACE WITH LOCKSIZE ROW -618 OPERATION operation IS NOT ALLOWED T2832 ON SYSTEM DATABASES -619 OPERATION DISALLOWED BECAUSE THE 55011 WORKFILE DATABASE IS NOT STOPPED -620 KEYWORD keyword IN stmt type 6 STATEMENT 53OUl IS NOT PERMITTED FOR A TABLE SPACE IN THE WORK FILE DATABASE -621 DUPLICATE DBID dbid WAS DETECTED 58001 AND PREVIOUSLY ASSIGNED TO database-name -622 FOR MIXED DATA IS INVALID BECAUSE 56031 THE MIXED DATA INSTALL OPTION IS NO -623 A CLUSTERING INDEX ALREADY EXISTS 55012 ON TABLE table-name -624 TABLE table-name ALREADY HAS A PRIMARY 42889 KEY +625 THE DEFINITION OF TABLE table-name 01518 HAS BEEN CHANGED TO INCOMPLETE -625 TABLE table-name DOES NOT HAVE AN 55014 INDEX TO ENFORCE THE UNIQUENESS OF THE PRIMARY KEY +626 DROPPING THE INDEX TERMINATES 01529 ENFORCEMENT OF THE UNIQUENESS OF A KEY THAT WAS DEFINED WHEN THE TABLE WAS CREATED -626 THE ALTER STATEMENT IS NOT EXECUTABLE 55015 BECAUSE THE PAGE SET IS NOT STOPPED -627 THE ALTER STATEMENT IS INVALID BECAUSE 55016 THE PAGESET HAS USER-MANAGED DATA SETS -628 THE CLAUSES ARE MUTUALLY EXCLUSIVE 42613 -629 SET NULL CANNOT BE SPECIFIED BECAUSE 42834 FOREIGN KEY name CANNOT CONTAIN NULL VALUES -630 THE WHERE NOT NULL SPECIFICATION IS 56089 INVALID FOR TYPE 1 INDEXES -631 FOREIGN KEY name IS TOO LONG OR HAS 54008 TOO MANY COLUMNS -632 THE TABLE CANNOT BE DEFINED AS A 42915 DEPENDENT OF table-name BECAUSE OF DELETE RULE RESTRICTIONS -633 THE DELETE RULE MUST BE delete-rule 42915 -634 THE DELETE RULE MUST NOT BE CASCADE 42915 -635 THE DELETE RULES CANNOT BE DIFFERENT 42915 OR CANNOT BE SET NULL -636 THE PARTITIONING KEYS ARE NOT 56016 SPECIFIED IN ASCENDING OR DESCENDING ORDER -637 DUPLICATE keyword KEYWORD 42614 -638 TABLE table-name CANNOT BE CREATED 42601 BECAUSE COLUMN DEFINITION IS MISSING -639 A NULLABLE COLUMN OF A FOREIGN KEY 56027 WITH A DELETE RULE OF SET NULL CANNOT BE A COLUMN OF THE KEY OF A PARTITIONED INDEX -640 LOCKSIZE ROW CANNOT BE SPECIFIED 56089 BECAUSE TABLE IN THIS TABLESPACE HAS TYPE 1 INDEX -642 TOO MANY COLUMNS IN UNIQUE CONSTRAINTS 54021 -643 CHECK CONSTRAINT EXCEEDS MAXIMUM 54024 ALLOWABLE LENGTH -644 INVALID VALUE SPECIFIED FOR KEYWORD 42615 keyword IN stmt-type STATEMENT +645 WHERE NOT NULL IS IGNORED BECAUSE 01528 THE INDEX KEY CANNOT CONTAIN NULL VALUES -646 TABLE table-name CANNOT BE CREATED 55017 IN PARTITIONED/DEFAULT TABLE SPACE tspace-name BECAUSE IT ALREADY CONTAINS A TABLE -647 BUFFERPOOL bp-name CANNOT BE 57003 SPECIFIED BECAUSE IT HAS NOT BEEN ACTIVATED +650 THE TABLE BEING CR EATED OR ALTERED 01538 CANNOT BECOME A DEPENDENT TABLE -650 THE ALTER INDEX CANNOT BE EXECUTED, 56090 REASON reason -651 TABLE DESCRIPTION EXCEEDS MAXIMUM 54025 SIZE OF OBJECT DESCRIPTOR -652 VIOLATION OF INSTALLATION DEFINED 23506 EDIT OR VALIDATION PROCEDURE proc_name +653 TABLE table-name IN PARTITIONED 01551 TABLESPACE tspace-name IS NOT AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS NOT BEEN CREATED -653 TABLE table-name IN PARTITIONED TABLE 57004 SPACE tspace-name IS NOT AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS NOT BEEN CREATED -655 THE CREATE OR ALTER STOGROUP IS 56036 INVALID BECAUSE THE STORAGE GROUP WOULD HAVE BOTH SPECIFIC AND NONSPECIFIC VOLUME IDS +658 THE SUBPPAGES VALUE IS IGNORED FOR 01600 THE CATALOG INDEX index-name -660 INDEX index-name CANNOT BE CREATED 53035 ON PARTITIONED TABLE SPACE tspace-name BECAUSE KEY LIMITS ARE NOT SPECIFIED -661 INDEX index-name CANNOT BE CREATED 53036 ON PARTITIONED TABLE SPACE tspace-name BECAUSE THE NUMBER OF PART SPECIFICATIONS IS NOT EQUAL TO THE NUMBER OF PARTITIONS OF THE TABLE SPACE -662 A PARTITIONED INDE-X CANNOT BE CREATED 53037 ON A NON-PARTITIONED TABLE SPACE tspace-name -663 THE NUMBER OF KEY LIMIT VALUES IS 53038 EITHER ZERO, OR GREATER THAN THE NUMBER OF COLUMNS IN THE KEY OF INDEX index-name +664 THE INTERNAL LENGTH OF THE LIMIT-KEY 01540 FIELDS FOR PARTITIONED INDEX index-name EXCEEDS THE LENGTH IMPOSED BY THE INDEX MANAGER -665 THE PART CLAUSE OF AN ALTER STATE- 53039 MENT IS OMITTED OR INVALID -666 stmt-verb object CANNOT BE EXECUTED 57005 BECAUSE function IS IN PROGRESS -667 THE CLUSTERING INDEX FOR A PARTITIONED 42917 TABLE SPACE CANNOT BE EXPLICITLY DROPPED -668 THE COLUMN CANNOT BE ADDED TO THE 56018 TABLE BECAUSE THE TABLE HAS AN EDIT PROCEDURE -669 A TABLE IN A PARTITIONED TABLE SPACE 42917 CANNOT BE EXPLICITLY DROPPED -670 THE RECORD LENGTH OF THE TABLE 54010 EXCEEDS THE PAGE SIZE LIMIT -671 THE BUFFERPOOL ATTRIBUTE OF THE 53040 TABLE SPACE CANNOT BE ALTERED AS SPECIFIED BECAUSE IT WOULD CHANGE THE PAGE SIZE OF THE TABLE SPACE -672 OPERATION DROP NOT ALLOWED ON 55035 TABLE table-name -676 A 32K PAGE BUFFERPOOL MAY NOT BE 53041 USED FOR AN INDEX -677 INSUFFICIENT VIRTUAL STORAGE FOR 57011 BUFFERPOOL EXPANSION -678 THE LITERAL literal SPECIFIED FOR THE 53045 INDEX LIMIT KEY MUST CONFORM TO THE DATA TYPE data-type OF THE CORRESPONDING COLUMN column-name -679 THE OBJECT name CANNOT BE CREATED 57006 BECAUSE A DROP IS PENDING ON THE OBJECT -680 TOO MANY COLUMNS SPECIFIED FOR A 54011 TABLE -681 COLUMN column-name IN VIOLATION OF 23507 INSTALLATION DEFINED FIELD PROCEDURE. RT: return-code, RS: reason-code, MSG: message-token -682 FIELD PROCEDURE procedure-name 57010 COULD NOT BE LOADED -683 INVALID COLUMN TYPE FOR FIELDPROC, 42842 BIT DATA, SBCS DATA, OR MIXED DATA I OPTION, column-name -684 THE LENGTH OF LITERAL LIST BEGINNING 54012 string IS TOO LONG -685 INVALID FIELD TYPE. column-name 58002 -686 COLUMN DEFINED WITH A FIELD PROCEDURE 53043 CANNOT COMPARE WITH ANOTHER COLUMN WITH DIFFERENT FIELD PROCEDURE -687 FIELD TYPES INCOMPARABLE 53044 -688 INCORRECT DATA RETURNED FROM 58002 FIELD PROCEDURE, column-name, msgno -689 TOO MANY COLUMNS DEFINED FOR A 54011 DEPENDENTTABLE -690 THE STATEMENT IS REJECTED BY DATA 23508 DEFINITION CONTROL SUPPORT. REASON reason-code -691 THE REQUIRED REGISTRATION TABLE 57018 table-name DOES NOT EXIST -692 THE REQUIRED UNIQUE INDEX index-name 57018 FOR DDL REGISTRATION TABLE table-name DOES NOT EXIST -693 THE COLUMN column-name IN DDL REGISTRATION 55003 TABLE OR INDEX table-name (index-name) IS NOT DEFINED PROPERLY -694 THE DDL STATEMENT CANNOT BE EXECUTED 57023 BECAUSE A DROP IS PENDING ON THE DDL REGISTRATION TABLE table-name -713 THE REPLACEMENT VALUE FOR special 42815 register IS INVALID -715 PROGRAM program-name WITH MARK 56064 release-dependency-mark FAILED BECAUSE IT DEPENDS ON FUNCTIONS OF THE RELEASE FROM WHICH FALLBACK HAS OCCURRED -716 PROGRAM program-name PRECOMPILED 56065 WITH INCORRECT LEVEL FOR THIS RELEASE -717 bind type FOR object-type object-name WITH 56066 MARK release-dependency-mark FAILED BECAUSE object-type DEPENDS ON FUNCTIONS OF THE RELEASE FROM WHICH FALLBACK HAS OCCURRED -718 REBIND FOR PACKAGE package-name 56067 FAILED BECAUSE IBMREQD OF ibmreqd IS INVALID -719 BIND ADD ERROR USING auth-id 42710 AUTHORITY PACKAGE package-name ALREADY EXISTS -720 BIND ERROR, ATTEMPTING TO REPLACE 42710 PACKAGE = package-name WITH VERSION = version2 BUT THIS VERSION ALREADY EXISTS -721 BIND ERROR FOR PACKAGE = pkg-id 42710 CONTOKEN ='contoken'X IS NOT UNIQUE SO IT CANNOT BE CREATED -722 bind-type ERROR USING auth-id AUTHORITY 42704 PACKAGE package-name DOES NOT EXIST -726 BIND ERROR ATTEMPTING TO REPLACE 55030 PACKAGE =. THERE ARE ENABLE OR DISABLE ENTRIES CURRENTLY ASSOCIATED WITH THE PACKAGE -730 THE PARENT OF A TABLE IN A READ-ONLY 56053 SHARED DATABASE MUST ALSO BE A TABLE IN A READ-ONLY SHARED DATABASE -731 USER DEFINED DATASET dsname MUST 56054 BE DEFINED WITH SHAREOPTIONS(1,3) -732 THE DATABASE IS DEFINED ON THIS 56055 SUBSYSTEM WITH THE ROSHARE READ ATTRIBUTE BUT THE TABLE SPACE OR INDEX SPACE HAS NOT BEEN DEFINED ON THE OWNING SUBSYSTEM -733 THE DESCRIPTION OF A TABLE SPACE, 56056 INDEX SPACE, OR TABLE IN A ROSHARE READ DATABASE MUST BE CONSISTENT WITH ITS DESCRIPTION IN THE OWNER SYSTEM -734 THE ROSHARE ATTRIBUTE OF A DATABASE 56057 CANNOT BE ALTERED FROM ROSHARE READ -735 DATABASE dbid CANNOT BE ACCESSED 55004 BECAUSE IT IS NO LONGER A SHARED DATABASE -736 INVALID OBID obid SPECIFIED 53014 -737 IMPLICIT TABLE SPACE NOT ALLOWED 56056 +738 DEFINITION CHANGE OF object object-name 01530 MAY REQUIRE SIMILAR CHANGE ON READ-ONLY SYSTEMS -741 A WORK FILE DATABASE IS ALREADY 55020 DEFINED FOR MEMBER member-name -742 DSNDBO7 IS THE IMPLICIT WORK FILE 53004 DATABASE -751 A STORED PROCEDURE HAS BEEN 42987 PLACED IN MUST-ROLLBACK STATE DUE TO SQL OPERATION name -752 THE CONNECT STATEMENT IS INVALID 0A001 BECAUSE THE PROCESS IS NOT IN THE CONNECTABLE STATE +802 EXCEPTION ERROR exception-type HAS 22003 OCCURRED DURING operation-type 22012 OPERATION ON data-type DATA, POSITION position-number -802 EXCEPTION ERROR 'exception-type' HAS 22003 OCCURRED DURING 'operation-type' OPERATION ON 'data-type' DATA, POSITION 'position-number' -803 AN INSERTED OR UPDATED VALUE IS 23505 INVALID BECAUSE THE INDEX IN INDEX SPACE indexspace-name CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X'rid' -804 AN ERROR WAS FOUND IN THE APPLICATION 07002 PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT. REASON reaSON -805 DBRM OR PACKAGE NAME location- 51002 name.collection-id.dbrm-name.consistency- token NOT FOUND IN PLAN plan-name. REASON reason +806 BIND ISOLATION LEVEL RR CONFLICTS 01553 WITH TABLESPACE LOCKSIZE PAGE OR LOCKSIZE ROW AND LOCKMAX 0 +807 THE RESULT OF DECIMAL MULTIPLICATION 01554 MAY CAUSE OVERFLOW -807 ACCESS DENIED: PACKAGE package-name 23509 IS NOT ENABLED FOR ACCESS FROM connection-type connection-name -808 THE CONNECT STATEMENT IS NOT 08001 CONSISTENT WITH THE FIRST CONNECT STATEMENT -811 THE RESULT OF AN EMBEDDED SELECT 21000 STATEMENT IS A TABLE OF MORE THAN ONE ROW, OR THE RESULT OF THE SUBOUERY OF A BASIC PREDICATE 16 MORE THAN ONE VALUE -812 THE SQL STATEMENT CANNOT BE PROCESSED 22508 BECAUSE A BLANK COLLECTION-ID WAS FOUND IN THE CURRENT PACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM A QUALIFIED PACKAGE NAME FOR PROGRAM program-name.con- sistency-token USING PLAN plan-name -815 A GROUP BY OR HAVING CLAUSE IS IMPLICITLY 42920 OR EXPLICITLY SPECIFIED IN AN EMBEDDED SELECT STATEMENT OR A SUBQUERY OF A BASIC PREDICATE -817 THE SQL STATEMENT CANNOT BE EXECUTED 25000 BECAUSE THE STATEMENT WILL RESULT IN A PROHIBITED UPDATE OPERATION -818 THE PRECOMPILER-GENERATED TIMESTAMP 51003 x IN THE LOAD MODULE IS DIFFERENT FROM THE BIND TIMESTAMP y BUILT FROM THE DBRM z -819 THE VIEW CANNOT BE PROCESSED BECAUSE 58004 THE LENGTH OF ITS PARSE TREE IN THE CATALOG IS ZERO -820 THE SQL STATEMENT CANNOT BE PROCESSED 58004 BECAUSE catalog-table CONTAINS A VALUE THAT IS NOT VALID IN THIS RELEASE -822 THE SQLDA CONTAINS AN INVALID DATA 51004 ADDRESS OR INDICATOR VARIABLE ADDRESS -840 TOO MANY ITEMS RETURNED IN A SELECT 54004 OR INSERT LIST -842 A CONNECTION TO location-name ALREADY 08002 EXISTS -843 THE SET CONNECTION OR RELEASE 08003 STATEMENT MUST SPECIFY AN EXISTING CONNECTION +863 THE CONNECTION WAS SUCCESSFUL 01539 BUT ONLY SBCS WILL BE SUPPORTED -870 THE NUMBER OF HOST VARIABLES IN 58026 THE STATEMENT IS NOT EQUAL TO THE NUMBER OF DESCRIPTORS -900 THE SQL STATEMENT CANNOT BE EXECUTED 08003 BECAUSE THE APPLICATION PROCESS IS NOT CONNECTED TO AN APPLICATION SERVER -901 UNSUCCESSFUL EXECUTION CAUSED BY 58004 A SYSTEM ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS -902 POINTER TO THE ESSENTIAL CONTROL 58005 BLOCK (CT/RDA) HAS A VALUE 0, REBIND REQUIRED -904 UNSUCCESSFUL EXECUTION CAUSED BY 57011 AN UNAVAILABLE RESOURCE. REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name -905 UNSUCCESSFUL EXECUTION DUE TO 57014 RESOURCE LIMIT BEING EXCEEDED, RESOURCE NAME = resource-name LIMIT = limit-amountl CPU SECONDS (limit-amount2 SERVICE UNITS) DERIVED FROM limit-source -906 THE SQL STATEMENT CANNOT BE EXECUTED 51005 BECAUSE THIS FUNCTION IS DISABLED DUE TO A PRIOR ERROR -908 bind-type ERROR USING auth-id AUTHORITY 23510 BIND, REBIND OR AUTO-REBIND OPERATION IS NOT ALLOWED -909 THE OBJECT HAS BEEN DELETED 57007 -910 THE SQL STATEMENT CANNOT ACCESS 57007 AN OBJECT ON WHICH A DROP OR ALTER IS PENDING -911 THE CURRENT UNIT OF WORK HAS BEEN 40001 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 57033 DEADLOCK OR TIMEOUT. REASON CODE reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE NAME resource-name -917 BIND PACKAGE FAILED 42969 -918 THE SQL STATEMENT CANNOT BE EXECUTED 51021 BECAUSE A CONNECTION HAS BEEN LOST -919 A ROLLBACK OPERATION IS REQUIRED 56045 -922 AUTHORIZATION FAILURE: error-type ERROR. 42505 REASON reason-code -923 CONNECTION NOT ESTABLISHED: DB2 57015 condition REASON reason-code, TYPE resource-type, NAME resource-name -924 DB2 CONNECTION INTERNAL ERROR, 58006 function-code, return-code, reason-code -925 COMMIT NOT VALID IN IMSNS OR CICS 2D521 ENVIRONMENT -926 ROLLBACK NOT VALID IN IMSNS OR CICS 2D521 ENVIRONMENT -927 THE LANGUAGE INTERFACE (LI) WAS 51006 CALLED WHEN THE CONNECTING ENVIRONMENT WAS NOT ESTABLISHED. THE PROGRAM SHOULD BE INVOKED UNDER THE DSN COMMAND -929 FAILURE IN A DATA CAPTURE EXIT: token 58002 -939 ROLLBACK REQUIRED DUE TO UNREQUESTED 51021 ROLLBACK OF A REMOTE SERVER -947 THE SQL STATEMENT FAILED BECAUSE IT 56038 WILL CHANGE A TABLE DEFINED WITH DATA CAPTURE CHANGES, BUT THE DATA CANNOT BE PROPAGATED -948 DISTRIBUTED OPERATION IS INVALID 56062 -950 THE LOCATION NAME SPECIFIED IN THE 42705 CONNECT STATEMENT IS INVALID OR NOT LISTED IN THE COMMUNICATIONS DATABASE -965 STORED PROCEDURE procname TERMINATED 51021 ABNORMALLY -2000 SUBPAGES GREATER THAN 1 IS NOT 56094 SUPPORTED FOR TYPE 1 INDEXES IN A DATA SHARING ENVIRONMENT. -2001 THE NUMBER OF HOST VARIABLE PARAMETERS 53089 FOR A STORED PROCEDURE IS NOT EQUAL TO THE NUMBER OF EXPECTED HOST VARIABLE PARAMETERS. ACTUAL NUMBER sqldanum, EXPECTED NUMBER opnum -30000 EXECUTION FAILED DUE TO A DISTRIBUTION 58008 PROTOCOL ERROR THAT WILL NOT AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS OR SQL STATEMENTS: REASON reason-code (subcode) -30020 EXECUTION FAILED DUE TO A DISTRIBUTION 58009 PROTOCOL ERROR THAT CAUSED DEALLOCATION OF THE CONVERSATION: REASON -30021 EXECUTION FAILED DUE TO A DISTRIBUTION 58010 PROTOCOL ERROR THAT WILL AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS OR SQL STATEMENTS: MANAGER manager AT LEVEL level NOT SUPPORTED ERROR -30030 COMMITREQUESTWASUNSUCCESSFUL, 58013 58013 A DISTRIBUTION PROTOCOL VIOLATION HAS BEEN DETECTED, THE CONVERSATION HAS BEEN DEALLOCATED. ORIGINAL SQLCODE=original-sqlcode AND ORIGINAL SQLSTATE=original-sqlstate -30040 EXECUTION FAILED DUE TO UNAVAILABLE 57012 RESOURCES THAT WILL NOT AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS OR SQL STATEMENTS. REASON TYPE OF RESOURCE RESOURCE NAME PROD- UCT ID RDBNAME -30041 EXECUTION FAILED DUE TO UNAVAILABLE 57013 RESOURCES THAT WILL AFFECT THE SUCCESSFUL EXECUTION OF SUBSEQUENT COMMANDS AND SQL STATEMENTS REASON TYPE OF RESOURCE RESOURCE NAME PRODUCT ID RDBNAME -30050 COMMAND 58011 OR SQL STATEMENT INVALID WHILE BIND PROCESS IN PROGRESS -30051 BIND PROCESS WITH SPECIFIED PACKAGE 58012 NAME AND CONSISTENCY TOKEN NOT ACTIVE -30052 PROGRAM PREPARATION ASSUMPTIONS 42932 ARE INCORRECT -30053 OWNER AUTHORIZATION FAILURE 42506 -30060 RDB AUTHORIZATION FAILURE 08004 -30061 RDB NOT FOUND 08004 -30070 COMMAND NOT SUPPORTED 58014 ERROR -30071 OBJECT NOT SUPPORTED 58015 ERROR -30072 : PARAMETER NOT 58016 SUPPORTED ERROR -30073 : PARAMETER 58017 VALUE NOT SUPPORTED ERROR -30074 REPLY MESSAGE WITH codepoint (svrcod) 58018 NOT SUPPORTED ERROR -30080 COMMUNICATION ERROR code (subcode) 08001 -30090 REMOTE OPERATION INVALID FOR APPLICATION 25000 EXECUTION ENVIRONMENT +30100 OPERATION COMPLETED SUCESSFULLY 01558 BUT A DISTRIBUTION PROTOCOL VIOLATION HAS BEEN DETECTED. ORIGINAL SOLCODE=original-sqlcode AND ORIGINAL SOLSTATE=original-sqlstate
Last Modified: Tuesday, 06-Feb-2001 13:39:09 CST
©2001 All Rights Reserved