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
©2001 All Rights Reserved