IMPORTANT SQL CODES

Successful Execution SQLCODE

000 SUCCESSFUL EXECUTION

Warning SQLCODES

m
+100 ROW NOT FOUND FOR FETCH, UPDATE OR DELETE, OR THE RESULT OF A

.co
QUERY IS AN EMPTY TABLE

+162 TABLE SPACE database-name, tablespace-name HAS BEEN PLACED IN CHECK

ES
PENDING
+304 A VALUE WITH DATA TYPE data-type1 CANNOT BE ASSIGNED TO A HOST
VARIABLE BECAUSE THE VALUE IS NOT WITHIN THE RANGE OF THE
HOST VARIABLE IN POSITION position-number WITH DATA TYPE data-type2

M
+402 LOCATION location IS UNKNOWN
+403 THE LOCAL OBJECT REFERENCED BY THE CREATE ALIAS STATEMENT
DOES NOT EXIST
A
+558 THE WITH GRANT OPTION IS IGNORED BECAUSE GRANT IS TO PUBLIC
FR
+560 THE WITH GRANT OPTION IS IGNORED FOR UPDATE (COLUMN-LIST)
+561 THE ALTER AND INDEX PRIVILEGES CANNOT BE GRANTED TO “PUBLIC
AT ALL LOCATIONS”
IN

+625 THE DEFINITION OF TABLE table-name HAS BEEN CHANGED TO

INCOMPLETE
+802 EXCEPTION ERROR exception-type HAS OCCURRED DURING operation-type
A

OPERATION ON data-type DATA, POSITION position-number.

M

Error SQLCODES

-007 STATEMENT CONTAINS THE ILLEGAL CHARACTER character

M

-010 THE STRING CONSTANT BEGINNING string IS NOT TERMINATED

-060 INVALID type SPECIFICATION: spec
IB

-084 UNACCEPTABLE SQL STATEMENT

-101 THE STATEMENT IS TOO LONG OR TOO COMPLEX
-102 THE LENGTH OF THE STRING CONSTANT BEGINNING string IS GREATER
THAN 254 CHARACTERS OR 124GRAPHIC CHARACTERS
-103 literal IS AN INVALID NUMERIC LITERAL
-104 ILLEGAL SYMBOL token VALID SYMBOLS ARE token-list
-105 INVALID STRING
 -107 THE NAME name IS TOO LONG. MAXIMUM ALLOWABLE SIZE IS size
-109 clause CLAUSE IS NOT PERMITTED
-110 INVALID HEXADECIMAL LITERAL BEGINNING string
-111 A COLUMN FUNCTION DOES NOT INCLUDE A COLUMN NAME
-112 THE OPERAND OF A COLUMN FUNCTION IS ANOTHER COLUMN
FUNCTION OR DISTINCT FOLLOWED BY AN EXPRESSION
-113 INVALID CHARACTER FOUND IN NAME: name

m
-115 A PREDICATE IS INVALID BECAUSE THE COMPARISON OPERATOR operator
IS FOLLOWED BY A PARENTHESIZED LIST OR BY ANY OR ALL WITHOUT

.co
A SUBQUERY
-117 THE NUMBER OF INSERT VALUES IS NOT THE SAME AS THE NEMBER OF
OBJECT COLUMNS

ES
-118 THE OBJECT TABLE OR VIEW OF THE INSERT, DELETE, OR UPDATE
STATEMENT IS ALSO INDENTIFIED IN A FROM CLAUSE
-119 A COLUMN IDENTIFIED IN A HAVING CLAUSE IS NOT INCLUDED IN THE
GROUP BY CLAUSE

M
-120 A WHERE CLAUSE OR SET CLAUSE INCLUDES A COLUMN FUNCTION OR A
WHERE CLAUSE REFERENCES A COLUMN [column-name] WHICH IS
A
DERIVED FROM A COLUMN FUNCTION OR EXPRESSION IN A VIEW
DEFINITION
FR
-121 THE COLUMN name IS IDENTIFIED MORE THAN ONCE IN THE INSERT OR
UPDATE STATEMENT
-122 A SELECT STATEMENT WITH NO GROUP BY CLAUSE CONTAINS A
COLUMN NAME AND A COLUMN FUNCTION IN THE SELECT CLAUSE OR A
IN

COLUMN NAME IS CONTAINED IN THE SELECT CLAUSE BUT NOT IN THE

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

OF THE RESULT
-126 THE SELECT STATEMENT CONTAINS BOTH AN UPDATE CLAUSE AND AN
M

ORDER BY CLAUSE
-127 DISTINCT IS SPECIFIED MORE THAN ONCE IN A SUBSELECT
M

-128 INVALID USE OF NULL IN A PREDICATE

-129 THE STATEMENT CONTAINS TOO MANY TABLE NAMES
-131 STATEMENT WITH LIKE PREDICATE HAS INCOMPATIBLE DATA TYPES
IB

-132 A LIKE PREDICATE IS INVALID BECAUSE THE FIRST OPERAND IS NOT A

COLUMN OR THE SECOND OPERAND IS NOT A STRING
-133 A COLUMN FUNCTION IN A SUBQUERY OF A HAVING CLAUSE IS INVALID
BECAUSE IT INCLUDES AN EXPRESSION THAT APPLIES AN OPERATIOR TO
A CORRELATED REFERENCE
-134 IMPROPER USE OF LONG STRING COLUMN column-name OR A HOST
VARIABLE OF MAXIMUM LENGTH GREATER THAN 254
 -136 SORT CANNOT BE EXECUTED BECAUSE THE SORT KEY LENGTH IS
GREATER THAN 4000 BYTES
-137 RESULT OF CONCATENATION TOO LONG
-138 THE SECOND OR THIRD ARGUMENT OF THE SUBSTR FUNCTION IS OUT OF
RANGE
-150 THE OBJECT OF THE INSERT, DELETE, OR UPDATE STATEMENT IS A VIEW
FOR WHICH THE REQUESTED OPERATION IS NOT PERMITTED

m
-151 THE UPDATE STATEMENT IS INVALID BECAUSE THE CATALOG
DESCRIPTION OF COLUMN column-name INDICATES THAT IT CANNOT BE
UPDATED

.co
-153 THE CREATE VIEW STATEMENT DOES NOT INCLUDE A REQUIRED
COLUMN LIST
-154 THE CREATE VIEW FAILED BECAUSE THE VIEW DEFINITION CONTAINS A

ES
UNION, A UNION ALL, OR A REMOTE OBJECT
-156 THE STATEMENT DOES NOT IDENTIFY A TABLE
-157 ONLY A TABLE NAME CAN BE SPECIFIED IN A FOREIGN KEY CLAUSE.

M
Object-name IS NOT THE NAME OF A TABLE
-158 THE NUMBER OF COLUMNS SPECIFIED FOR THE VIEW IS NOT THE SAME
A
AS THE NUMBER OF COLUMNS SPECIFIED BY THE SELECT CLAUSE
-159 DROP OR COMMENT ON token IDENTIFIES A(N) token RATHER THAN A(N)
FR
token
-160 THE WITH CHECK OPTION CANNOT BE USED FOR THE SPECIFIED VIEW
-172 function-name IS NOT A VALID FUNCTION NAME
-180 THE STRING REPRESENTATION OF DATETIME VALUE HAS INVALID
IN

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

-182 AN ARITHMETIC EXPRESSION WITH DATETIME VALUE IS INVALID

M

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

THAT IS NOT WITHIN VALID RANGE OF DATES
-184 AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE CONTAINS A
M

PARAMETER MARAKER
-185 THE LOCAL FORMAT OPTION HAS BEEN USED WITH A DATE OR TIME
AND NO LOCAL EXIT HAS BEEN INSTALLED
IB

-186 THE LOCAL DATE OR TIME LENGTH HAS BEEN INCREASED AND
EXECUTING PROGRAM RELIES ON OLD LENGTH
-187 A REFERENCE TO A CURRENT DATE/TIME SPECIAL REGISTER IS INVALID
BECAUSE THE MVS TOO CLOCT IS BAD OR THE MVS PARMTE IS OUT OF
RANGE
-198 THE OPERAND OF THE PREPARE OF THE EXECUTE IMMEDIATE
STATEMENT IS BLANK OR EMPTY
 -199 ILLEGAL USE OF KEYWORD keyword, TOKEN token-list WAS EXPECTED
-203 A REFERENCE TO COLUMN col-name IS AMBIGOUS
-204 name IS AN UNQUALIFIED NAME
-205 column-name IS NOT A COLUMN OF TABLE table-name
-206 column-name IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE
OR ANY TABLE IDENTIFIED IN THE FROM CLAUSE
-207 ORDER BY CLAUSE IS INVALID BECAUSE IT INCLUDES A COLUMN NAME

m
BUT IT APPLIES TO RESULT OF A UNION OR UNION ALL
-208 THE ORDER BY CLAUSE IS INVALID BECAUSE COLUMN col-name IS NOT

.co
PART OF THE RESULT TABLE
-219 THE REQUIRED EXPLANATION TABLE table-name DOES NOT EXIST
-220 THE COLUMN NAME col-name IN EXPALANATION TABLE table-name IS NOT

ES
DEFINED PROPERLY
-301 THE VALUE OF THE INPUT HOST VARIABLE NUMBER position-num CANNOT
BE USED AS SPECIFIED BECAUSE OF ITS DATA TYPE

M
-302 THE VALUE OF INPUT VARIBLE NUMBER position-num IS TOO LARGE TO
THE TARGET COLUMN
-303 VALUE CANNOT BE ASSIGNED TO THE OUTPUT HOST VARIABLE NUMBER
A
position-num BECAUSE DATA TYPES ARE NOT COMPARABLE
-304 A VALUE WITH DATA TYPE data-type1 CANNOT BE ASSIGNED TO HOST
FR
VARIABLE BECAUSE THE VALUE IS NOT WITHIN RANGE OF HOST
VARIABLE IN POSITION posit-num WITH DATATYPE data-type2
-305 THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE
NUMBER posit-num BECAUSE NO INDICATOR VARIABLE IS SPECIFIED
IN

-309 A PREDICATE IS INVALID BECAUSE A REFERENCED HOST VARIABLEHAS

THE NULL VALUE
-312 UNDEFINED OR UNUSABLE HOST VARIABLE variable-name
A

-313 THE NUMBER OF HOST VARIABLES SPECIFIED IS NOT EQUAL TO THE

M

NUMBER OF PARAMETER MARKERS

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

-402 AN ARITHMETIC FUNCTION OR OPERATOR arith-top IS APPLIED TO

CHARACTER OR DATETIME DATA
IB

-404 THE UPDATE OR INSERT STATEMENT SPECIFIES A STRING THAT IS TOO

LONG column-name
-405 THE NUMERIC LITERAL literal CANNOT BE USED AS SPECIFIED BECAUSE
IT IS OUT OF RANGE
-406 A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE
RANGE OF ITS OBJECT COLUMN
-407 AN UPDATE OR INSERT VALUE IS NULL BUT THE OBJECT COLUMN column
name CANNOT CONTAIN NULL VALUES
 -408 AN UPDATE OR INSERT VALUE IS NOT COMPARABLE WITH THE DATA
TYPE OF ITS OBJECT COLUMN column name
-409 INVALID OPERAND OF A COUNT FUNCTION
-410 THE FLOATING POINT LITERAL literal CONTAINS MORE THAN 30
CHARACTERS
-411 THE CURRENT DATETIME, CURRENT SQLID OR USER KEYWORD CANNOT
BE USED AS SPECIFIED

m
-412 THE SELECT CLAUSE OF A SUBQUERY SPECIFIES MULTIPLE COLUMNS
-414 THE NUMERIC OR DATETIME COLUMN column-name IS SPECIFIED IN A LIKE

.co
PREDICATE
-415 THE CORRESPONDING COLUMNS, column-number, OF THE OPERANDS OF A
UNION OR UNION ALL DO NOT HAVE COMPARABLE COLUMN
DESCRIPTIONS

ES
-416 AN OPERAND OF A UNION CONTAINS A LONG STRING COLUMN
-417 A STATEMENT STRING TO BE PREPARED INCLUDES PARAMENTER
MARKERS AS THE OPERANDS, THE SAME OPERATOR

M
-418 STATEMENT STRING TO BE PREPARED OR AN EXECUTE IMMEDIATE
STMNT CONTAINS INVALID US OF PARM MARKERS
-419
A
DECIMAL DIVIDE OPERATION IS INVALID BECAUSE RESULT WOULD
HAVE A NEGATIVE SCALE
FR
-421 THE OPERANDS OF A UNION OR UNION ALL DO NOT HAVE THE SAME
NUMBER OF COLUMNS
-501 CURSOR INDENTIFIED IN FETCH OR CLOSE IS NOT OPEN
-502 CURSOR IDENTIFIED IN OPEN IS ALREADY OPEN
IN

-503 A COLUMN CANNOT BE UPDATED BECAUSE IT IS NOT IDENTIFIED IN THE

UPDATE CLAUSE OF THE SELECT STATEMENT OF THE CURSOR
-504 THE CURSOR NAME cursor-name IS NOT DEFINED
A

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

M

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

-509 THE TABLE IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT

THE SAME TABLE DESIGNATED BY THE CURSOR
IB

-510 THE TABLE DESIGNATED BY THE CURSOR OF THE UPDATE OR DELETE

STATEMENT CANNOT BE MODIFIED
-511 THE FOR UPDATE CLAUSE CANNOT BE SPECIFIED BECAUSE TABLE
DESIGNATED BY THE CURSOR CANNOT BE MODIFIED
-514 THE CURSOR cursor-name IS NOT IN A PREPARED STATE
-516 THE DESCRIBE STATEMENT DOES NOT IDENTIFY A PREPARED
STATEMENT
-517 CURSOR cursor-name CANNOT BE USED BECAUSE ITS STATEMENT NAME
 DOES NOT IDENTIFY A PREPARED SELECT STATEMENT
-518 THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED
STATEMENT
-519 THE PREPARE STATEMENT IDENTIFIES THE SELECT STATEMENT OF THE
OPENED CURSOR cursor-name
-530 THE INSERT OR UPDATE VALUE OF FOREIGN DEY constraint-name IS
INVALID

m
-531 THE PRIMARY KEY IN A PARENT ROW CANNOT BE UPDATED BECAUSE IT
HAS ONE OR MORE DEPENDENT ROWS IN A RELATIONSHIP constraint-name

.co
-532 THE RELATIONSHIP constraint-name RESTRICTS THE DELETION OF ROW
WITH RIX X ‘rid-number’
-533 INVALID MULTIPLE-ROW INSERT
-534 THE PRIMARY KEY CANNOT BE UPDATED BECAUSE OF MULTIPLE-ROW

ES
UPDATE
-535 INVALID UPDATE OR DELETE WITH WHERE CURRENT OF
-536 THE DELETE STATEMENT IS INVALID BECAUSE TABLE table-name CAN BE

M
AFFECTED BY THE OPERATION
-537 THE PRIMARY KEY OR FOREIGN KEY CLAUSE IDENTIFIES COLUMN
A
column-name MORE THEN ONCE
-538 FOREIGN KEY name DOES NOT CONFORM TO THE DESCRIPTION OF THE
FR
PRIMARY KEY OF TABLE table- name
-539 TABLE table-name DOES NOT HAVE A PRIMARY KEY
-540 THE DEFINITION OF TABLE table-name IS INCOMPLETE BECAUSE IT DOES
NOT HAVE A PRIMARY INDEX
IN

-541 FOREIGN KEY name IS INVALID BECAUSE IT IS A DUPLICATE

REFERENTIAL CONSTRAINT
-542 column-name CANNOT BE A COLUMN OF A PRIMARY KEY BECAUSE IT CAN
A

CONTAIN NULL VALUES

M

-551 auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation
ON OBJECT object-name
-552 auth-id DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION operation
M

-553 auth-id SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION IDS

-554 AN AUTHORIZATION ID CANNOT GRANT A PRIVILEGE TO ITSELF
IB

-555 AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF

-556 A PRIVILEGE CANNOT BE REVOKED BECAUSE IT IS NOT POSSESSED BY
authorization ID
-557 INCONSISTENT GRANT/REVOKE KEYWORD keyword. PERMITTED
KEYWORDS ARE keyword-list
-558 INVALID CLAUSE OR COMBINATION OF CLAUSES ON A GRANT OR
REVOKE
-559 ALL AUTHORIZATION FUNCTIONS HAVE BEEN DISABLED
 -571 THE STATEMENT WOULD RESULT IN A MULTIPLE SITE UPDATE
-601 THE NAME OF THE OBJECT TO BE CREATED IS IDENTICAL TO THE
EXISTING NAME name OF THE OBJECT TYPE obj-type
-602 TOO MANY COLUMNS SPECIFIED IN A CREATE INDEX
-603 A UNIQUE INDEX CANNOT BE CREATED BECAUSE THE TABLE CONTAINS
ROWS WHICH ARE DUPLICATES WITH RESPECT TO THE VALUES OF THE
IDENTIFIED COLUMNS

m
-604 A COLUMN DEFINITION SPECIFIES AN INVALID LENGTH, PRECISION, OR
SCALE ATTRIBUTE

.co
-607 OPERATION operation IS NOT DEFINED FOR SYSTEM TABLES
-612 column-name IS A DUPLICATE COLUMN NAME
-613 THE PRIMARY KEY IS TOO LONG OR HAS TOO MANY COLUMNS

ES
-614 THE INDEX CANNOT BE CREATED BECAUSE THE SUM OF THE INTERNAL
LENGTHS OF THE IDENTIFIED COLUMNS IS GREATER THAN THE
ALLOWABLE MAXIMUM
-616 obj-type1 obj-name1 CANNOT BE DROPPED BECAUSE IT IS REFERENCED BY

M
obj-type2 obj-name2\
-618 OPERATION operation IS NOT ALLOWED ON SYSTEM DATA BASES
-619
A
OPERATION DISALLOWED BECAUSE THE WORKFILE DATA BASE IS NOT
STOPPED
FR
-620 KEYWORD keyword IN stmt type STATEMENT IS NOT PERMITTED FOR A
TABLESPACE IN THE WORKFILE DATABASE
-621 DUPLICATE DBID dbid WAS DETECTED AND PREVIOUSLY ASSIGNED TO
database-name
IN

-623 A CLUSTERING INDEX ALREADY EXISTS ON TABLE table-name

-624 TABLE table-name ALREADY HAS A PRIMARY KEY
A

-625 TABLE table-name DOES NOT HAVE AN INDEX TO ENFORCE THE

UNIQUENESS OF THE PRIMARY KEY
M

-626 THE ALTER STATEMENT IS NOT EXECUTABLE BECAUSE THE PAGESET IS

NOT STOPPED
-627 THE ALTER STATEMENT IS INVALID BECAUSE THE PAGESET HAS USER-
M

NANAGED DATA SETS

-628 A SEGMENTED TABLESPACE MAY NOT BE PARTITIONED
IB

-629 SET NULL CANNOT BE SPECIFIED BECAUSE FOREIGN KEY NAME CANNOT
CONTAIN NULL VALUES
-631 FOREIGN DEY NAME IS TOO LONG OR HAS TOO MANY COLUMNS
-632 THE TABLE CANNOT BE DEFINED AS DEPENDENT OF table-name BECAUSE
OF DELETE RULE RESTRICTIONS
-633 THE DELETE RULE MUST BE delete-rule
-634 THE DELETE RULE MUST NOT BE CASCADE
 -635 THE DELETE RULES CANNOT BE DIFFERENT OR CANNOT BE SET NULL
-636 THE PARTITIONING KEYS ARE NOT SPECIFIED IN ASCENDING OR
DESCENDING ORDER
-637 DUPLICATE keyword KEYWORD
-638 TABLE table-name CANNOT BE CREATED BECAUSE COLUMN DEFINITION IS
MISSING
-639 A NULLABLE COLUMN OF A FOREIGN DEY WITH A DELETE RULE OF SET

m
NULL NCANNOT BE A COLUMN OF THE DEY OF A PARTITIONED INDEX
-644 INVALID VALUE SPECIFIED FOR KEYWORD deyword IN STMT-TYPE

.co
STATEMENT
-646 TABLE table-name CANNOT BE CREATED IN PARTITIONED/DEFAULT
TABLESPACE tspace-name BECAUSE IT ALREADY CONTAINS A TABLE
-647 BUFFERPOOL bp-name CANNOT BE SPECIFIED BECAUSE IT HAS NOT BEEN

ES
ACTIVATED
-652 VIOLATION OF INSTALLATION DEFINED EDIT OR VALIDATION
PROCEDURE proc-name

M
-653 TABLE table-neme IN PARTITIONED TABLESPACE tspace-name IS NOT
AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS NOT BEEN CREATED
-660
A
INDEX index-name CANNOT BE CREATED ON PARTITIONEDTABLESPACE
tsspace-name BECAUSE KEY LIMITS ARE NOT SPECIFIED
FR
-661 INDEX index-name CANNOT BE CREATED ON PARTITIONED TABLESPACE
tspace-name BECAUSE THE NUMBER OF PART SPECIFICATIONS IS NOT
EQUAL TO THE NUMBER OF PARTITIONS OF THE TABLESPACE
-662 A PARTITIONED INDEX CANNOT BE CREATED ON A NON-PARTITIONED
IN

TABLESPACE tspace-name
-663 THE NUMBER OF KEY LIMIT VALUES IS EITHER ZERO OR GREATER THAN
THE NUMBER OF COLUMNS IN THE KEY OF INDEX index-name
A

-664 THE INTERNAL LENGTH OF THE LIMIT-KEY FIELDS FOR THE

PARTITIONED INDEX index-name EXCEEDS THE LENGTH IMPOSED BY THE
M

INDEX MANAGER
-665 THE PART CLAUSE OF AN ALTER STATEMENT IS OMITTED OR INVALID
M

-666 stmt-verb object CANNOT BE EXECUTED BECAUSE function IS IN PROGRESS

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

-668 THE COLUMN CANNOT BE ADDED TO THE TABLE BECAUSE THE TABLE
HAS AN EDIT PROCEDURE
-669 A TABLE IN A PARTITIONED TABLESPACE CANNOT BE EXPLICITLY
DROPPED
-670 THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT
-671 THE BUFFERPOOL ATTRIBUTE OF THE TABLESPACE CANNOT BE
ALTERED AS SPECIFIED BECAUSE IT WOULD CHANGE THE PAGE SIZE OF
 THE TABLESPACE
-676 A 32K PAGE BUFFERPOOL MAY NOT BE USED FOR AN INDEX
-677 INSUFFICIENT VIRTUAL STORAGE FOR BUFFERPOOL EXPANSION
-678 THE LITERAL literal SPECIFIED FOR THE INDEX LIMIT KEY MUST
CONFORM TO THE DATA TYPE data-type OF THE CORRESPONDING
COLUMN column-name
-679 THE OBJECT name CANNOT BE CREATED BECAUSE A DROP IS PENDING ON

m
THE OBJECT
-680 TOO MANY COLUMNS SPECIFIED FOR A TABLE

.co
-681 COLUMN column-name IN VIOLATION OF INSTALLATION DEFINED FIELD
PROCEDURE RT: return-code RS: reason-code, MSG : message-token
-682 FIELD PROCEDURE procedure-name COULD NOT BE LOADED

ES
-683 INVALID COLUMN TYPE FOR FIELDPROC OR BIT DATA OPTION, COLUMN-
NAME
-684 THE LENGTH OF LITERAL LIST BEGINNING string IS TOO LONG

M
-685 INVALID FIELD TYPE , column-name
-686 COLUMN DEFINED WITH A FIELD PROCEDURE CANNOT COMPARE WITH
ANOTHER COLUMN WITH DIFFERENT FIELD PROCEDURE
A
-687 FIELD TYPES INCOMPARABLE
-688 INCORRECT DATA RETURNED FROM FIELD PROCEDURE, column-name,
FR
msgno
-802 EXCEPTION ERROR ‘exception-type’ HAS OCCURRED DURING ‘operation-type’
OPERATION ON ‘data-type’ DATA, POSITION ‘position-number’
IN

-803 AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE THE INDEX

index-name CONSTRAINS COLUMNS OF THE TABLE SUCH THAT NO TWO
ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS RID OF
EXISTINGF ROW IS X’rid’
A

-804 AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT

M

PARAMETERS FOR THE SQL STATEMENT

-805 PROGRAM NAME program-name NOT FOUND IN PLAN plan-name
-811 THE RESULT OF AN EMBEDDED SELECT STATEMENT IS A TABLE OF
M

MORE THAN ONE ROW OR THE RESULT OF THE SUBQUERY OF A BASIC

PREDICATE IS NORE THAN ONE VALUE
IB

-815 A GROUP BY OR HAVING CLAUSE IS IMPLICITLY OR EXPLICITLY

SPECIFIED IN AN EMBEDDED SELECT STATEMENT OR A SUBQUERY OF A
BASIC PREDICATE
-817 THE INSERT, UPDATE, DELETE, DDL, OR AUTHORIZATION STATEMENT
CANNOT BE EXECUTED BECAUSE THE IMS/VS TRANSACTION IS INQUIRY
ONLY
-818 THE PRECOMPLIER-GENERATED TIMESTAMP x IN THE LOAD MODULE IS
DIFFERENT FROM THE BIND TIMESTAMP y BUILT FROM THE DBRM
 -819 THE VIEW CANNOT BE PROCESSED BECAUSE THE LENGTH OF ITS PARSE
TREE IN THE CATALOG IS ZERO
-820 THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE catalog-table
CONTAINS A VALUE THAT IS NOT VALID IN THIS RELEASE
-822 THE SQLDA CONTAINS AN INVALID DATA ADDRESS OR INDICATOR
VARIABLE ADDRESS
-840 TOO MANY ITEMS RETURNED IN A SELECT OR INSERT LIST

m
-901 UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES
NOT PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL
STATEMENTS

.co
-904 UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE,
REASON reason-code, TYPE OF RESOURCE resource-type, AND RESOURCE
NAME resource-name

ES
-905 UNSUSCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING
EXCEEDED, RESOURCE NAME = resource name LIMIT = limit-amount1 CPU
SECONDS (limit-amount2 SERVICE UNITS) DERIVED FROM limit-source

M
-906 THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE THIS FUNCTION
IS DISABLED DUE TO A PRIOR ERROR
-907 UNABLE TO DETERMINE IF THE ATTEMPT TO COMMIT UPDATES MADE
A
AT A REMOTE SITE WAS SUCCESSFUL OR NOT
-909 THE OBJECT HAS BEEN DELETED
FR

-910 THE SQL STATEMENT CANNOT ACCESS AN OBJECT ON WHICH A DROP OR

ALTER IS PENDING
-911 THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO
IN

DEADLOCK OR TIMEOUT, REASON reason-code, TYPE OF RESOURCE

resource-type, AND RESOURCE NAME resource-name
-913 UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT,
A

REASON CODE reason-code, TYPE OF RESOURCE resource-type, AND

RESOURCE NAME resource-name
M

-922 CONNECTION AUTHORIZATION FAILURE error-type ERROR

-923 CONNECTION NOT ESTABLISED DB2 condition REASON reason-code, TYPE
resource-type, NAME resource-name
M

-924 DB2 CONNECTION INTERNAL ERROR, function-code, return-code, reason-code

-925 COMMIT NOT VALID IN IMS/VS OR CICS ENVIRONMENT
IB

-927 THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING
ENVIRONMENT WAS NOT ESTABLISHED THE PROGRAM SHOULD BE
INVOKED UNDER THE DSN COMMAND