SQL Codes

SQL Codes
SQL Codes are returned by DB2 when an operation on the database fails. These
codes provide us with Diagnostic information and enable us to take corrective action.
Hence checking for SQL Code once a database operation (SELECT, INSERT, UPDATE,
DELETE etc) is performed.

TOP 10 SQL CODES:

The following SQL Codes are most commonly encountered SQL Codes in our

8
application programming.

8
7 78
:1
D
eI
at
o ci

The SQL Codes provided under DB2 version7 and above are tabulated below.
ss

SQL DESCRIPTION CATEGORY

CODE
A

-991 CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT Error

CONNECT OR OPEN TO DB2.

-981 THE SQL STATEMENT FAILED BECAUSE THE RRSAF Error

CONNECTION IS NOT IN A STATE THAT ALLOWS SQL
OPERATIONS.

-950 THE LOCATION NAME SPECIFIED IN THE CONNECT Error

STATEMENT IS INVALID OR NOT LISTED IN THE
COMMUNICATIONS DATABASE

-948 DISTRIBUTED OPERATION IS INVALID Error

-947 THE SQL STATEMENT FAILED BECAUSE IT WILL Error
CHANGE A TABLE DEFINED WITH DATA CAPTURE
CHANGES, BUT THE DATA CANNOT BE PROPAGATED

Page 1 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-939 ROLLBACK REQUIRED DUE TO UNREQUESTED Error
ROLLBACK OF A REMOTE SERVER
-929 FAILURE IN A CHANGED DATA CAPTURE EXIT Error

-927 THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN Error

THE CONNECTING ENVIRONMENT WAS NOT
ESTABLISHED. THE PROGRAM SHOULD BE INVOKED
UNDER THE DSN COMMAND

8
-926 ROLLBACK NOT VALID IN IMS OR CICS ENVIRONMENT Error

8
-925 COMMIT NOT VALID IN IMS OR CICS ENVIRONMENT Error

78
-924 DB2 CONNECTION INTERNAL ERROR, , , Error

-923

7
CONNECTION NOT ESTABLISHED: DB2, REASON, TYPE,
NAME
Error
:1
-922 AUTHORIZATION FAILURE: ERROR. REASON Error
D
-919 A ROLLBACK OPERATION IS REQUIRED Error
-918 THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE Error
eI

A CONNECTION HAS BEEN LOST

-917 BIND PACKAGE FAILED Error

at

-913 UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR Error

TIMEOUT. REASON CODE , TYPE OF RESOURCE , AND
ci

RESOURCE NAME

-911 THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK Error
o

DUE TO DEADLOCK OR TIMEOUT. REASON ,

TYPE OF RESOURCE , AND RESOURCE NAME
ss

-910 THE SQL STATEMENT CANNOT ACCESS AN OBJECT ON Error

WHICH A DROP OR ALTER IS PENDING
A

-909 THE OBJECT HAS BEEN DELETED OR ALTERED Error

-908 ERROR USING AUTHORITY. BIND, REBIND, OR AUTO- Error

REBIND OPERATION IS NOT ALLOWED

-906 THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE Error

THIS FUNCTION IS DISABLED DUE TO A PRIOR ERROR

-905 UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT Error

BEING EXCEEDED, RESOURCE NAME = LIMIT = CPU
SECONDS (SERVICE UNITS) DERIVED FROM

Page 2 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-904 UNSUCCESSFUL EXECUTION CAUSED BY AN Error
UNAVAILABLE RESOURCE. REASON , TYPE OF
RESOURCE , AND RESOURCE NAME

-902 POINTER TO ESSENTIAL CONTROL BLOCK(RDA/CT) HAS Error

VALUE 0, REBIND REQUIRED
-901 UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM Error
ERROR THAT DOES NOT PRECLUDE THE SUCCESSFUL
EXECUTION OF SUBSEQUENT SQL STATEMENTS

8
-900 THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE Error
THE APPLICATION PROCESS IS NOT CONNECTED

8
TO AN APPLICATION SERVER

78
-882 SAVEPOINT DOES NOT EXIST Error
-881 A SAVEPOINT WITH NAME ALREADY EXISTS, BUT THIS Error

7
SAVEPOINT NAME CANNOT BE REUSED
:1
-880 SAVEPOINT DOES NOT EXIST OR IS INVALID IN THIS Error
CONTEXT
D
-879 CREATE OR ALTER STATEMENT FOR CANNOT DEFINE A Error
COLUMN, DISTINCT TYPE, FUNCTION OR
eI

STORED PROCEDURE PARAMETER AS MIXED OR

GRAPHIC WITH ENCODING SCHEME
at

-878 THE PLAN_TABLE USED FOR EXPLAIN CANNOT BE ASCII Error

ci

-877 CCSID ASCII IS NOT ALLOWED FOR THIS DATABASE Error

OR TABLE SPACE
o

-876 CANNOT BE CREATED, REASON Error

ss

-875 CANNOT BE USED WITH THE ASCII DATA REFERENCED Error

-874 THE ENCODING SCHEME SPECIFIED FOR THE MUST BE Error

A

THE SAME AS THE CONTAINING TABLE SPACE OR

OTHER PARAMETERS
-873 DATA ENCODED WITH DIFFERENT CCSIDS CANNOT BE Error
REFERENCED IN THE SAME SQL STATEMENT
-872 A VALID CCSID HAS NOT YET BEEN SPECIFIED FOR Error
THIS SUBSYSTEM

-870 THE NUMBER OF HOST VARIABLES IN THE STATEMENT Error

IS NOT EQUAL TO THE NUMBER OF DESCRIPTORS

-867 INVALID SPECIFICATION OF A ROWID COLUMN Error

-846 INVALID SPECIFICATION OF AN IDENTITY COLUMN Error

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

Page 3 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-842 A CONNECTION TO X ALREADY EXISTS Error

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

LIST

-822 THE SQLDA CONTAINS AN INVALID DATA ADDRESS OR Error

INDICATOR VARIABLE ADDRESS

8
-820 THE SQL STATEMENT CANNOT BE PROCESSED Error
BECAUSE CONTAINS A VALUE THAT IS NOT VALID IN

8
THIS RELEASE

78
-819 THE VIEW CANNOT BE PROCESSED BECAUSE THE Error
LENGTH OF ITS PARSE TREE IN THE CATALOG IS ZERO
-818 THE PRECOMPILER-GENERATED TIMESTAMP IN THE Error

7
LOAD MODULE IS DIFFERENT FROM THE BIND
TIMESTAMP BUILT FROM THE DBRM
:1
-817 THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE Error
THE STATEMENT WILL RESULT IN A PROHIBITED
UPDATE OPERATION
D

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

eI

EXPLICITLY SPECIFIED IN A SUBSELECT OF A

BASIC PREDICATE OR A SET CLAUSE OF AN UPDATE
at

STATEMENT

-812 THE SQL STATEMENT CANNOT BE PROCESSED Error

ci

BECAUSE A BLANK COLLECTION-ID WAS FOUND IN THE

CURRENT
o

PACKAGESET SPECIAL REGISTER WHILE TRYING TO

FORM A QUALIFIED PACKAGE NAME FOR PROGRAM
ss

USING PLAN

-811 THE RESULT OF AN EMBEDDED SELECT STATEMENT OR Error

A

A SUBSELECT IN THE SET CLAUSE OF AN

UPDATE STATEMENT IS A TABLE OF MORE THAN ONE
ROW, OR THE RESULT OF A SUBQUERY OF A BASIC
PREDICATE IS MORE THAN VALUE

-808 THE CONNECT STATEMENT IS NOT CONSISTENT WITH Error

THE FIRST CONNECT STATEMENT

-807 ACCESS DENIED: PACKAGE IS NOT ENABLED FOR Error

ACCESS FROM

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

REASON

Page 4 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-804 AN ERROR WAS FOUND IN THE APPLICATION PROGRAM Error
INPUT PARAMETERS FOR THE SQL STATEMENT,
REASON

-803 AN INSERTED OR UPDATED VALUE IS INVALID Error

BECAUSE INDEX IN INDEX SPACE CONSTRAINS
COLUMNS OF THE TABLE SO NO TWO ROWS CAN
CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID
OF EXISTING ROW IS X''

8
-802 EXCEPTION ERROR HAS OCCURRED DURING Error

8
OPERATION ON DATA, POSITION

78
-798 YOU CANNOT INSERT A VALUE INTO A COLUMN THAT Error
IS DEFINED WITH THE OPTION GENERATED ALWAYS.

-797
COLUMN NAME

7
ATTEMPT TO CREATE TRIGGER WITH AN Error
:1
UNSUPPORTED TRIGGERED SQL STATEMENT

-771 INVALID SPECIFICATION OF A ROWID COLUMN Error

D

-770 TABLE CANNOT HAVE A LOB COLUMN UNLESS IT ALSO Error

eI

HAS A ROWID COLUMN

at

-769 SPECIFICATION OF CREATE AUX TABLE DOES NOT Error

MATCH THE CHARACTERISTICS OF THE BASE TABLE
ci

-768 AN AUXILIARY TABLE ALREADY EXISTS FOR THE Error

SPECIFIED COLUMN OR PARTITION
o

-767 MISSING OR INVALID COLUMN SPECIFICATION FOR Error

ss

INDEX

-766 THE OBJECT OF A STATEMENT IS AN AUXILIARY TABLE Error

A

FOR WHICH THE REQUESTED OPERATION IS NOT

PERMITTED

-765 TABLE IS NOT COMPATIBLE WITH DATABASE Error

-764 A LOB TABLE SPACE AND ITS ASSOCIATED BASE TABLE Error
SPACE MUST BE IN THE SAME DATABASE

-763 INVALID TABLE SPACE NAME Error

-752 CONNECT STATEMENT IS INVALID BECAUSE THE Error

PROCESS IS NOT IN THE CONNECTABLE STATE

-751 (SPECIFIC NAME ) ATTEMPTED TO EXECUTE AN SQL Error

STATEMENT THAT IS NOT ALLOWED

Page 5 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-750 THE SOURCE TABLE CANNOT BE RENAMED BECAUSE IT Error
IS REFERENCED IN EXISTING VIEW
DEFINITIONS OR TRIGGER DEFINITIONS

-748 AN INDEX ALREADY EXISTS ON AUXILIARY TABLE Error

-747 TABLE IS NOT AVAILABLE UNTIL THE AUXILIARY Error
TABLES AND INDEXES FOR ITS EXTERNALLY
STORED COLUMNS HAVE BEEN CREATED

8
-746 THE SQL STATEMENT IN AN EXTERNAL FUNCTION, Error
TRIGGER, OR IN STORED PROCEDURE VIOLATES

8
THE NESTING SQL RESTRICTION

78
-742 DSNDB07 IS THE IMPLICIT WORK FILE DATABASE Error
-741 A DATABASE IS ALREADY DEFINED FOR MEMBER Error
-740

7
FUNCTION IS DEFINED WITH THE OPTION MODIFIES
SQL DATA WHICH IS NOT VALID IN THE
Error
:1
CONTEXT IN WHICH IT WAS INVOKED
D
-739 ALTER FUNCTION FAILED BECAUSE FUNCTIONS Error
CANNOT MODIFY DATA WHEN THEY ARE PROCESSED IN
PARALLEL
eI

-737 IMPLICIT TABLE SPACE NOT ALLOWED Error

at

-736 INVALID OBID SPECIFIED Error

-735 DATABASE CANNOT BE ACCESSED BECAUSE IT IS NO Error
ci

LONGER A SHARED DATABASE

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

-733 THE DESCRIPTION OF A TABLE SPACE, INDEX SPACE, Error

ss

OR TABLE IN A ROSHARE READ DATABASE

MUST BE CONSISTENT WITH ITS DESCRIPTION IN THE
OWNER SYSTEM
A

-732 THE DATABASE IS DEFINED ON THIS SUBSYSTEM WITH Error

THE ROSHARE READ ATTRIBUTE BUT THE
TABLE SPACE OR INDEX SPACE HAS NOT BEEN
DEFINED ON THE OWNING SUBSYSTEM

-731 USER-DEFINED DATASET MUST BE DEFINED WITH Error

SHAREOPTIONS (1,3)

-730 THE PARENT OF A TABLE IN A READ-ONLY SHARED Error

DATABASE MUST ALSO BE A TABLE IN A
READ-ONLY SHARED DATABASE

-729 A STORED PROCEDURE SPECIFYING COMMIT ON Error

RETURN CANNOT BE THE TARGET OF A NESTED CALL
STATEMENT

Page 6 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

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

-726 BIND ERROR ATTEMPTING TO REPLACE PACKAGE = . Error

THERE ARE ENABLE OR DISABLE ENTRIES
CURRENTLY ASSOCIATED WITH THE PACKAGE

-725 THE SPECIAL REGISTER AT LOCATION WAS SUPPLIED Error

AN INVALID VALUE

8
-724 THE ACTIVATION OF THE OBJECT WOULD EXCEED Error
THE MAXIMUM LEVEL OF INDIRECT SQL CASCADING

8
-723 AN ERROR OCCURRED IN A TRIGGERED SQL Error

78
STATEMENT IN TRIGGER , SECTION NUMBER .
INFORMATION RETURNED: SQLCODE , SQLSTATE , AND
MESSAGE TOKENS

-722
7
ERROR USING AUTHORITY PACKAGE DOES NOT EXIST Error
:1
-721 BIND ERROR FOR PACKAGE = CONTOKEN = ''X IS NOT Error
UNIQUE SO IT CANNOT BE CREATED
D
-720 BIND ERROR, ATTEMPTING TO REPLACE PACKAGE = Error
WITH VERSION = BUT THIS VERSION ALREADY EXISTS
eI

-719 BIND ADD ERROR USING AUTHORITY PACKAGE Error

ALREADY EXISTS
at

-718 REBIND OF PACKAGE FAILED BECAUSE IBMREQD OF Error

IS INVALID
ci

-717 FOR WITH MARK FAILED BECAUSE DEPENDS ON Error

o

FUNCTIONS OF THE RELEASE FROM WHICH FALLBACK

HAS OCCURRED
ss

-716 PROGRAM PRECOMPILED WITH INCORRECT LEVEL FOR Error

THIS RELEASE
A

-715 PROGRAM WITH MARK FAILED BECAUSE IT DEPENDS Error

ON FUNCTIONS OF THE RELEASE FROM WHICH
FALLBACK HAS OCCURRED

-713 REPLACEMENT VALUE FOR IS INVALID Error

-697 OLD OR NEW CORRELATION NAMES ARE NOT ALLOWED Error
IN A TRIGGER DEFINED WITH THE FOR EACH
STATEMENT CLAUSE. OLD_TABLE OR NEW_TABLE
NAMES ARE NOT ALLOWED IN A TRIGGER WITH THE
BEFORE CLAUSE

-696 THE DEFINITION OF TRIGGER INCLUDES AN INVALID Error

USE OF CORRELATION NAME OR TRANSITION TABLE
NAME . REASON CODE=

Page 7 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-694 THE DDL STATEMENT CANNOT BE EXECUTED BECAUSE Error
A DROP IS PENDING ON THE DDL REGISTRATION
TABLE

-693 THE COLUMN IN DDL REGISTRATION TABLE OR INDEX Error

IS NOT DEFINED PROPERLY

-692 THE REQUIRED UNIQUE INDEX FOR DDL Error

REGISTRATION TABLE DOES NOT EXIST

8
-691 THE REQUIRED REGISTRATION TABLE DOES NOT Error
EXIST

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

-689

7
TOO MANY COLUMNS DEFINED FOR A DEPENDENT
TABLE
Error
:1
-688 INCORRECT DATA RETURNED FROM FIELD PROCEDURE Error
D
-687 FIELD TYPES INCOMPARABLE Error
eI

-686 COLUMN DEFINED WITH A FIELD PROCEDURE CAN NOT Error

COMPARE WITH ANOTHER COLUMN WITH
at

DIFFERENT FIELD PROCEDURE

-685 INVALID FIELD TYPE Error

ci

-684 THE LENGTH OF LITERAL LIST BEGINNING IS TOO Error

o

LONG
ss

-683 THE SPECIFICATION FOR COLUMN, DISTINCT TYPE, Error

FUNCTION, OR PROCEDURE CONTAINS INCOMPATIBLE
CLAUSES
A

-682 FIELD PROCEDURE COULD NOT BE LOADED Error

-681 COLUMN IN VIOLATION OF INSTALLATION DEFINED Error

FIELD PROCEDURE RT: , RS: , MSG:
-680 TOO MANY COLUMNS SPECIFIED FOR A TABLE, VIEW, Error
OR TABLE FUNCTION

-679 THE OBJECT CANNOT BE CREATED BECAUSE A DROP Error

IS PENDING ON THE OBJECT

-678 THE LITERAL SPECIFIED FOR THE INDEX LIMIT KEY Error
MUST CONFORM TO THE DATA TYPE OF THE
CORRESPONDING COLUMN

Page 8 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-677 INSUFFICIENT VIRTUAL STORAGE FOR BUFFERPOOL Error
EXPANSION

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

INDEX

-672 OPERATION DROP NOT ALLOWED ON TABLE Error

-671 THE BUFFERPOOL ATTRIBUTE OF THE TABLE SPACE Error

8
CANNOT BE ALTERED AS SPECIFIED BECAUSE IT
WOULD CHANGE THE PAGE SIZE OF THE TABLE SPACE

8
78
-670 THE RECORD LENGTH OF THE TABLE EXCEEDS THE Error
PAGE SIZE LIMIT

-669

7
A TABLE IN A PARTITIONED TABLE SPACE CANNOT BE
EXPLICITLY DROPPED
Error
:1
-668 THE COLUMN CANNOT BE ADDED TO THE TABLE Error
BECAUSE THE TABLE HAS AN EDIT PROCEDURE
D

-667 THE CLUSTERING INDEX FOR A PARTITIONED TABLE Error

eI

SPACE CANNOT BE EXPLICITLY DROPPED

-666 CANNOT BE EXECUTED BECAUSE IS IN PROGRESS Error
at

-665 THE PART CLAUSE OF AN ALTER STATEMENT IS Error

OMITTED OR INVALID
ci

-663 THE NUMBER OF KEY LIMIT VALUES IS EITHER ZERO, Error

o

OR GREATER THAN THE NUMBER OF COLUMNS IN THE

KEY OF INDEX
ss

-662 A PARTITIONED INDEX CANNOT BE CREATED ON A Error

NON-PARTITIONED TABLE SPACE
A

-661 INDEX CANNOT BE CREATED ON PARTITIONED TABLE Error

SPACE BECAUSE THE NUMBER OF PART
SPECIFICATIONS IS NOT EQUAL TO THE NUMBER OF
PARTITIONS OF THE TABLE SPACE

-660 INDEX CANNOT BE CREATED ON PARTITIONED TABLE Error

SPACE X BECAUSE KEY LIMITS ARE NOT SPECIFIED
-658 CREATION OF A STRUCTURED TYPE AUTOMATICALLY Error
GENERATES A SET OF FUNCTIONS FOR USE WITH THE
TYPE. THE GENERATED FUNCTIONS CANNOT BE
DROPPED WITHOUT DROPPING THE STRUCTURED
TYPE.

Page 9 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-655 THE CREATE OR ALTER STOGROUP IS INVALID Error
BECAUSE THE STORAGE GROUP WOULD HAVE BOTH
SPECIFIC AND NON-SPECIFIC VOLUME IDS

-653 TABLE IN PARTITIONED TABLE SPACE IS NOT Error

AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS
NOT BEEN CREATED

-652 VIOLATION OF INSTALLATION DEFINED EDIT OR Error

8
VALIDATION PROCEDURE

8
-651 TABLE DESCRIPTION EXCEEDS MAXIMUM SIZE OF Error

78
OBJECT DESCRIPTOR

-650 THE ALTER INDEX CANNOT BE EXECUTED, REASON Error

-647

7
: BUFFERPOOL CANNOT BE SPECIFIED BECAUSE IT
HAS NOT BEEN ACTIVATED
Error
:1
-646 : TABLE CANNOT BE CREATED IN SPECIFIED TABLE Error
SPACE BECAUSE IT ALREADY CONTAINS A TABLE
D

-644 INVALID VALUE SPECIFIED FOR KEYWORD IN Error

eI

STATEMENT
at

-643 CHECK CONSTRAINT EXCEEDS MAXIMUM ALLOWABLE Error

LENGTH
ci

-642 TOO MANY COLUMNS IN UNIQUE CONSTRAINTS Error

o

-640 LOCKSIZE ROW CANNOT BE SPECIFIED BECAUSE Error

TABLE IN THIS TABLESPACE HAS TYPE 1 INDEX
ss

-639 A NULLABLE COLUMN OF A FOREIGN KEY WITH A Error

DELETE RULE OF SET NULL CANNOT BE A COLUMN
A

OF THE KEY OF A PARTITIONED INDEX

-638 : TABLE CANNOT BE CREATED BECAUSE COLUMN Error

DEFINITION IS MISSING

-637 DUPLICATE KEYWORD Error

-636 THE PARTITIONING KEYS FOR PARTITION ARE NOT Error
SPECIFIED IN ASCENDING OR DESCENDING ORDER

-635 THE DELETE RULES CANNOT BE DIFFERENT OR Error

CANNOT BE SET NULL

-634 THE DELETE RULE MUST NOT BE CASCADE Error

Page 10 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-633 THE DELETE RULE MUST BE DELETE RULE. THE CODE Error
IS USED TO REPORT THAT THE 'DELETE RULE’
SPECIFIED IN A FOREIGN KEY CLAUSE OF THE ALTER
TABLE STATEMENT IS INVALID.

-632 THE TABLE CANNOT BE DEFINED AS A DEPENDENT OF Error

BECAUSE OF DELETE RULE RESTRICTIONS

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

8
COLUMNS

8
-630 THE WHERE NOT NULL SPECIFICATION IS INVALID FOR Error

78
TYPE 1 INDEXES

-629 SET NULL CANNOT BE SPECIFIED BECAUSE FOREIGN Error

7
KEY CANNOT CONTAIN NULL VALUES
:1
-628 THE CLAUSES ARE MUTUALLY EXCLUSIVE Error

-627 THE ALTER STATEMENT IS INVALID BECAUSE THE Error

D
PAGESET HAS USER-MANAGED DATA SETS
eI

-626 THE ALTER STATEMENT IS NOT EXECUTABLE BECAUSE Error

THE PAGE SET IS NOT STOPPED
at

-625 TABLE DOES NOT HAVE AN INDEX TO ENFORCE THE Error

UNIQUENESS OF THE PARENT KEY
ci

-624 TABLE ALREADY HAS A PRIMARY KEY Error

o

-623 A CLUSTERING INDEX ALREADY EXISTS ON TABLE Error

-622 FOR MIXED DATA IS INVALID BECAUSE THE MIXED Error
ss

DATA INSTALL OPTION IS NO

A

-621 DUPLICATE DBID WAS DETECTED AND PREVIOUSLY Error

ASSIGNED TO

-620 KEYWORD IN STATEMENT IS NOT PERMITTED FOR A Error

SPACE IN THE DATABASE

-619 OPERATION DISALLOWED BECAUSE THE WORK FILE Error

DATABASE IS NOT STOPPED

-618 OPERATION IS NOT ALLOWED ON SYSTEM DATABASES Error

-617 : A TYPE 1 INDEX IS NOT VALID FOR TABLE Error

-616 CANNOT BE DROPPED BECAUSE IT IS REFERENCED BY Error

-615 NOT ALLOWED ON A PACKAGE IN USE Error

Page 11 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-614 THE INDEX CANNOT BE CREATED OR THE LENGTH OF Error
THE COLUMN CANNOT BE CHANGED BECAUSE THE
SUM OF THE INTERNAL LENGTHS OF THE IDENTIFIED
COLUMNS IS GREATER THAN THE ALLOWABLE
MAXIMUM

-613 THE PRIMARY KEY OR A UNIQUE CONSTRAINT IS TOO Error

LONG OR HAS TOO MANY COLUMNS
-612 IS A DUPLICATE COLUMN NAME Error

8
-611 ONLY LOCKMAX 0 CAN BE SPECIFIED WHEN THE LOCK Error

8
SIZE OF THE TABLESPACE IS TABLESPACE OR TABLE

78
-607 OPERATION OR OPTION IS NOT DEFINED FOR THIS Error
OBJECT

-604
7
A DATA TYPE DEFINITION SPECIFIES AN INVALID Error
:1
LENGTH, PRECISION, OR SCALE ATTRIBUTE

-603 A UNIQUE INDEX CANNOT BE CREATED BECAUSE THE Error

D
TABLE CONTAINS ROWS WHICH ARE DUPLICATES
WITH RESPECT TO THE VALUES OF THE IDENTIFIED
eI

COLUMNS
at

-602 TOO MANY COLUMNS SPECIFIED IN A CREATE INDEX Error

-601 THE NAME OF THE OBJECT TO BE CREATED OR THE Error

ci

TARGET OF A RENAME STATEMENT IS IDENTICAL

TO THE EXISTING NAME OF THE OBJECT TYPE
o

-594 ATTEMPT TO CREATE A NULLABLE ROWID OR DISTINCT Error

ss

TYPE COLUMN

-593 NOT NULL MUST BE SPECIFIED FOR ROWID OR Error

A

DISTINCT TYPE COLUMN

-592 NOT AUTHORIZED TO CREATE FUNCTIONS OR Error

PROCEDURES IN WLM ENVIRONMENT
-590 PARAMETER NAME IS NOT UNIQUE IN THE CREATE Error
FOR ROUTINE

-586 THE TOTAL LENGTH OF THE CURRENT PATH SPECIAL Error

REGISTER CANNOT EXCEED 254 CHARACTERS

-585 THE SCHEMA NAME CANNOT APPEAR MORE THAN Error

ONCE IN THE CURRENT PATH
-582 THE SEARCH-CONDITION IN A SEARCHED-WHEN- Error
CLAUSE CANNOT BE A QUANTIFIED PREDICATE, IN
PREDICATE, OR AN EXISTS PREDICATE

Page 12 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-581 THE DATA TYPES OF THE RESULT-EXPRESSIONS OF A Error
CASE EXPRESSION ARE NOT COMPATIBLE

-580 THE RESULT-EXPRESSIONS OF A CASE EXPRESSION Error

CANNOT ALL BE NULL

-579 ATTEMPTED TO READ DATA WHEN THE DEFINITION OF Error

THE FUNCTION OR PROCEDURE DID NOT SPECIFY THIS
ACTION

8
-577 ATTEMPTED TO MODIFY DATA WHEN THE DEFINITION Error
OF THE FUNCTION OR PROCEDURE DID NOT SPECIFY

8
THIS ACTION

78
-574 THE SPECIFIED DEFAULT VALUE OR IDENTITY Error
ATTRIBUTE VALUE CONFLICTS WITH THE DEFINITION
OF COLUMN

7
:1
-573 TABLE DOES NOT HAVE A UNIQUE KEY WITH THE Error
SPECIFIED COLUMN NAMES
D
-571 THE STATEMENT WOULD RESULT IN A MULTIPLE SITE Error
UPDATE
eI

-567 THE AUTHORIZATION ID GIVEN DOES NOT HAVE THE Error

at

PRIVILEGE INDICATED, AND CANNOT INVOKE THE

INDICATED SUBCOMMAND AGAINST THE INDICATED
PACKAGE.
ci

-559 ALL AUTHORIZATION FUNCTIONS HAVE BEEN Error

o

DISABLED
ss

-558 INVALID CLAUSE OR COMBINATION OF CLAUSES ON A Error

GRANT OR REVOKE
A

-557 THE GRANT OR REVOKE STATEMENT CONTAINS Error

SYNTAX OR SPELLING ERROR AT OR BEFORE THE
SPECIFIED 'KEYWORD'.
-556 CANNOT HAVE THE PRIVILEGE REVOKED BY BECAUSE Error
THE REVOKEE DOES NOT POSSESS THE
PRIVILEGE OR THE REVOKER DID NOT MAKE THE
GRANT

-555 AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE Error

FROM ITSELF

-554 AN AUTHORIZATION ID CANNOT GRANT A PRIVILEGE Error

TO ITSELF

Page 13 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-553 SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION Error
IDS

-552 DOES NOT HAVE THE PRIVILEGE TO PERFORM Error

OPERATION

-551 DOES NOT HAVE THE PRIVILEGE TO PERFORM Error

OPERATION ON OBJECT

8
-549 THE STATEMENT IS NOT ALLOWED BECAUSE THE BIND Error
OPTION DYNAMIC RULES (RUN) IS NOT IN EFFECT FOR

8
THIS STATEMENT.

78
-548 A CHECK CONSTRAINT THAT IS DEFINED WITH IS Error
INVALID

-546
7
THE CHECK CONSTRAINT IS INVALID Error
:1
-545 THE REQUESTED OPERATION IS NOT ALLOWED Error
BECAUSE A ROW DOES NOT SATISFY THE CHECK
CONSTRAINT
D

-544 THE CHECK CONSTRAINT SPECIFIED IN THE ALTER Error

eI

TABLE STATEMENT CANNOT BE ADDED BECAUSE AN

EXISTING ROW VIOLATES THE CHECK CONSTRAINT
at

-543 A ROW IN A PARENT TABLE CANNOT BE DELETED Error

BECAUSE THE CHECK CONSTRAINT RESTRICTS THE
ci

DELETION
o

-542 CANNOT BE A COLUMN OF A PRIMARY KEY, A UNIQUE Error

CONSTRAINT, OR A PARENT KEY BECAUSE IT
ss

CAN CONTAIN NULL VALUES

-540 THE DEFINITION OF TABLE IS INCOMPLETE BECAUSE Error

A

IT LACKS A PRIMARY INDEX OR A REQUIRED UNIQUE

INDEX

-539 TABLE DOES NOT HAVE A PRIMARY KEY Error

-538 FOREIGN KEY DOES NOT CONFORM TO THE Error

DESCRIPTION OF A PARENT KEY OF TABLE
-537 THE PRIMARY KEY CLAUSE, A FOREIGN KEY CLAUSE, Error
OR A UNIQUE CLAUSE IDENTIFIES COLUMN MORE
THAN ONCE

-536 THE DELETE STATEMENT IS INVALID BECAUSE TABLE Error

CAN BE AFFECTED BY THE OPERATION

Page 14 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

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

-533 : INVALID MULTIPLE-ROW INSERT Error

-532 THE RELATIONSHIP RESTRICTS THE DELETION OF Error

ROW WITH RID X''

-531 : PARENT KEY IN A PARENT ROW CANNOT BE UPDATED Error

8
BECAUSE IT HAS ONE OR MORE DEPENDENT ROWS IN
RELATIONSHIP

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

-526

7
THE REQUESTED OPERATION OR USAGE DOES NOT
APPLY TO TEMPORARY TABLE
Error
:1
-525 THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE Error
IT WAS IN ERROR AT BIND TIME FOR SECTION
D
= PACKAGE = CONSISTENCY TOKEN = X''
eI

-519 THE PREPARE STATEMENT IDENTIFIES THE SELECT Error

STATEMENT OF THE OPENED CURSOR
at

-518 THE EXECUTE STATEMENT DOES NOT IDENTIFY A Error

VALID PREPARED STATEMENT
ci

-517 CURSOR CANNOT BE USED BECAUSE ITS STATEMENT Error

NAME DOES NOT IDENTIFY A PREPARED SELECT
o

STATEMENT
-516 THE DESCRIBE FOR STATIC STATEMENT DOES NOT Error
ss

IDENTIFY A PREPARED STATEMENT

-514 THE CURSOR IS NOT IN A PREPARED STATE Error

A

-513 THE ALIAS MUST NOT BE DEFINED ON ANOTHER Error

LOCAL OR REMOTE ALIAS

-512 STATEMENT REFERENCE TO REMOTE OBJECT IS Error

INVALID

-511 THE FOR UPDATE CLAUSE CANNOT BE SPECIFIED Error

BECAUSE THE TABLE DESIGNATED BY THE CURSOR
CANNOT BE MODIFIED

-510 THE TABLE DESIGNATED BY THE CURSOR OF THE Error

UPDATE OR DELETE STATEMENT CANNOT BE MODIFIED

Page 15 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-509 THE TABLE IDENTIFIED IN THE UPDATE OR DELETE Error
STATEMENT IS NOT THE SAME TABLE
DESIGNATED BY THE CURSOR

-508 THE CURSOR IDENTIFIED IN THE UPDATE OR DELETE Error

STATEMENT IS NOT POSITIONED ON A ROW

-507 THE CURSOR IDENTIFIED IN THE UPDATE OR DELETE Error

STATEMENT IS NOT OPEN

8
-504 CURSOR NAME IS NOT DEFINED Error

8
78
-503 A COLUMN CANNOT BE UPDATED BECAUSE IT IS NOT Error
IDENTIFIED IN THE UPDATE CLAUSE OF THE
SELECT STATEMENT OF THE CURSOR
-502

7
THE CURSOR IDENTIFIED IN AN OPEN STATEMENT IS
ALREADY OPEN
Error
:1
-501 THE CURSOR IDENTIFIED IN A FETCH OR CLOSE Error
STATEMENT IS NOT OPEN
D

-500 THE IDENTIFIED CURSOR WAS CLOSED WHEN THE Error

eI

CONNECTION WAS DESTROYED

at

-499 CURSOR HAS ALREADY BEEN ASSIGNED TO THIS OR Error

ANOTHER RESULT SET FROM PROCEDURE
ci

-497 THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS Error

BEEN EXCEEDED FOR DATABASE
o

-496 THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE Error

ss

IT REFERENCES A RESULT SET THAT WAS NOT

CREATED BY THE CURRENT SERVER
A

-495 ESTIMATED PROCESSOR COST OF PROCESSOR Error

SECONDS ( SERVICE UNITS) IN COST CATEGORY
EXCEEDS A RESOURCE LIMIT ERROR THRESHOLD OF
SERVICE UNITS

-492 THE CREATE FUNCTION FOR HAS A PROBLEM WITH Error

PARAMETER NUMBER . IT MAY INVOLVE A
MISMATCH WITH A SOURCE FUNCTION
-491 CREATE STATEMENT FOR USER-DEFINED FUNCTION Error
MUST HAVE A RETURNS CLAUSE, AND EITHER THE
EXTERNAL CLAUSE (WITH OTHER REQUIRED
KEYWORDS) OR THE SOURCE CLAUSE

Page 16 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-490 NUMBER DIRECTLY SPECIFIED IN AN SQL STATEMENT Error
IS OUTSIDE THE RANGE OF ALLOWABLE
VALUES IN THIS CONTEXT (, )

-487 ATTEMPTED TO EXECUTE AN SQL STATEMENT WHEN Error

THE DEFINITION OF THE FUNCTION OR
PROCEDURE DID NOT SPECIFY THIS ACTION
-483 IN CREATE FUNCTION FOR STATEMENT, THE NUMBER Error
OF PARAMETERS DOES NOT MATCH THE NUMBER

8
OF PARAMETERS OF THE SOURCE FUNCTION
-482 THE PROCEDURE RETURNED NO LOCATORS Error

8
-480 THE PROCEDURE HAS NOT YET BEEN CALLED Error

78
-478 DROP OR REVOKE ON OBJECT TYPE CANNOT BE Error
PROCESSED BECAUSE OBJECT OF TYPE IS

7
DEPENDENT ON IT
:1
-476 REFERENCE TO FUNCTION WAS NAMED WITHOUT A Error
SIGNATURE, BUT THE FUNCTION IS NOT UNIQUE
WITHIN ITS SCHEMA
D

-475 THE RESULT TYPE OF THE SOURCE FUNCTION CANNOT Error

eI

BE CAST TO THE RETURNS TYPE OF THE USER

DEFINED FUNCTION
at

-473 A USER DEFINED DATA TYPE CANNOT BE CALLED THE Error

SAME NAME AS A SYSTEM PREDEFINED TYPE
ci

(BUILT-IN TYPE)
o

-472 CURSOR WAS LEFT OPEN BY EXTERNAL FUNCTION Error

(SPECIFIC NAME )
ss

-471 INVOCATION OF FUNCTION OR PROCEDURE FAILED Error

DUE TO REASON
A

-470 SQL CALL STATEMENT SPECIFIED A NULL VALUE FOR Error

INPUT PARAMETER , BUT THE STORED
PROCEDURE DOES NOT SUPPORT NULL VALUES

-469 SQL CALL STATEMENT MUST SPECIFY AN OUTPUT HOST Error

VARIABLE FOR PARAMETER

-463 EXTERNAL FUNCTION (SPECIFIC NAME ) HAS Error

RETURNED AN INVALID SQLSTATE , WITH DIAGNOSTIC
TEXT

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

-458 IN A REFERENCE TO FUNCTION BY SIGNATURE, A Error

MATCHING FUNCTION COULD NOT BE FOUND

Page 17 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-457 A FUNCTION OR DISTINCT TYPE CANNOT BE CALLED Error
SINCE IT IS RESERVED FOR SYSTEM USE
-456 IN CREATE FUNCTION FOR , THE SPECIFIC NAME Error
ALREADY EXISTS IN THE SCHEMA

-455 IN CREATE FUNCTION FOR , THE SCHEMA NAME Error

PROVIDED FOR THE SPECIFIC NAME DOES NOT
MATCH THE SCHEMA NAME OF THE FUNCTION

8
-454 THE SIGNATURE PROVIDED IN THE CREATE FUNCTION Error
STATEMENT FOR MATCHES THE SIGNATURE OF

8
SOME OTHER FUNCTION ALREADY EXISTING IN THE

78
SCHEMA

-453 THERE IS A PROBLEM WITH THE RETURNS CLAUSE IN Error

7
THE CREATE FUNCTION STATEMENT FOR
:1
-451 THE DEFINITION, IN THE CREATE FUNCTION FOR Error
CONTAINS DATA TYPE WHICH IS NOT
APPROPRIATE FOR AN EXTERNAL FUNCTION WRITTEN
D
IN THE GIVEN LANGUAGE
eI

-450 USER-DEFINED FUNCTION OR STORED PROCEDURE , Error

PARAMETER NUMBER , OVERLAYED STORAGE
at

BEYOND ITS DECLARED LENGTH

-449 CREATE OR ALTER STATEMENT FOR FUNCTION OR Error

ci

PROCEDURE CONTAINS AN INVALID FORMAT OF THE

EXTERNAL NAME CLAUSE OR IS MISSING THE
o

EXTERNAL NAME CLAUSE

ss

-444 USER PROGRAM COULD NOT BE FOUND Error

-443 EXTERNAL FUNCTION (SPECIFIC NAME ) HAS Error

A

RETURNED AN ERROR SQLSTATE WITH DIAGNOSTIC

TEXT

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

FUNCTION

-440 NO BY THE NAME HAVING COMPATIBLE ARGUMENTS Error

WAS FOUND IN THE CURRENT PATH

-438 APPLICATION RAISED ERROR WITH DIAGNOSTIC TEXT: Error

-435 AN INVALID SQLSTATE IS SPECIFIED IN THE Error

FUNCTION RAISE_ERROR OR IN A SIGNAL SQLSTATE
STATEMENT
-433 VALUE IS TOO LONG Error

Page 18 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-430 (SPECIFIC NAME ) HAS ABNORMALLY TERMINATED Error

-427 DYNAMIC ROLLBACK NOT VALID AT AN APPLICATION Error

SERVER WHERE UPDATES ARE NOT ALLOWED

-426 DYNAMIC COMMIT NOT VALID AT AN APPLICATION Error

SERVER WHERE UPDATES ARE NOT ALLOWED

-423 INVALID VALUE FOR LOCATOR IN POSITION Error

8
-421 THE OPERANDS OF A UNION OR UNION ALL DO NOT Error

8
HAVE THE SAME NUMBER OF COLUMNS

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

-419

7
A DECIMAL DIVIDE OPERATION IS INVALID BECAUSE
THE RESULT WOULD HAVE A NEGATIVE SCALE
Error
:1
-418 A STATEMENT STRING TO BE PREPARED CONTAINS AN Error
D
INVALID USE OF PARAMETER MARKERS

-417 A STATEMENT STRING TO BE PREPARED INCLUDES Error

eI

PARAMETER MARKERS AS THE OPERANDS OF THE

SAME OPERATOR
at

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

COLUMN
ci

-415 THE CORRESPONDING COLUMNS, , OF THE OPERANDS Error

o

OF A UNION OR A UNION ALL DO NOT HAVE

COMPARABLE COLUMN DESCRIPTIONS
ss

-414 A LIKE PREDICATE IS INVALID BECAUSE THE FIRST Error

OPERAND IS NOT A STRING
A

-413 OVERFLOW OCCURRED DURING NUMERIC DATA TYPE Error

CONVERSION

-412 THE SELECT CLAUSE OF A SUBQUERY SPECIFIES Error

MULTIPLE COLUMNS

-411 CURRENT SQLID CANNOT BE USED IN A STATEMENT Error

THAT REFERENCES REMOTE OBJECTS

-410 THE FLOATING POINT LITERAL CONTAINS MORE THAN Error

30 CHARACTERS
-409 INVALID OPERAND OF A COUNT FUNCTION Error
-408 THE VALUE IS NOT COMPATIBLE WITH THE DATA TYPE Error
OF ITS TARGET

Page 19 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-407 AN UPDATE, INSERT, OR SET VALUE IS NULL, BUT THE Error
OBJECT COLUMN CANNOT CONTAIN NULL VALUES

-406 A CALCULATED OR DERIVED NUMERIC VALUE IS NOT Error

WITHIN THE RANGE OF ITS OBJECT COLUMN
-405 THE NUMERIC LITERAL CANNOT BE USED AS Error
SPECIFIED BECAUSE IT IS OUT OF RANGE
-404 : THE SQL STATEMENT SPECIFIES A STRING THAT IS Error
TOO LONG

8
-402 AN ARITHMETIC FUNCTION OR OPERATOR IS APPLIED Error

8
TO CHARACTER OR DATETIME DATA

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

-400
7
THE CATALOG HAS THE MAXIMUM NUMBER OF USER Error
:1
DEFINED INDEXES
D
-399 ATTEMPTED TO INSERT AN INVALID VALUE INTO A Error
ROWID COLUMN
eI

-398 A LOCATOR WAS REQUESTED FOR HOST VARIABLE Error

NUMBER BUT THE VARIABLE IS NOT A LOB
at

-397 THE OPTION GENERATED IS SPECIFIED WITH A Error

COLUMN THAT IS NOT A ROW ID OR DISTINCT TYPE
ci

BASED ON A ROW ID
-396 ATTEMPTED TO EXECUTE AN SQL STATEMENT DURING Error
o

FINAL CALL PROCESSING

ss

-392 SQLDA PROVIDED FOR CURSOR HAS BEEN CHANGED Error

FROM THE PREVIOUS FETCH
A

-390 THE FUNCTION NAME , SPECIFIC NAME , IS NOT VALID Error

IN THE CONTEXT IN WHICH IT OCCURS

-373 DEFAULT CANNOT BE SPECIFIED FOR IDENTITY Error

COLUMN

-372 ONLY ONE ROWID OR IDENTITY COLUMN IS ALLOWED Error

IN A TABLE

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

EXHAUSTED

-355 A LOB COLUMN IS TOO LARGE TO BE LOGGED Error

-352 AN UNSUPPORTED SQLTYPE WAS ENCOUNTERED IN Error

POSITION OF THE INPUT-LIST

Page 20 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

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

-350 INVALID SPECIFICATION OF A LARGE OBJECT COLUMN Error

-339 THE SQL STATEMENT CANNOT BE EXECUTED FROM AN Error

ASCII BASED DRDA APPLICATION REQUESTOR TO
A V2R2 DB2 SUBSYSTEM

8
-338 AN ON CLAUSE IS INVALID Error

8
-333 THE SUBTYPE OF A STRING VARIABLE IS NOT THE Error

78
SAME AS THE SUBTYPE KNOWN AT BIND TIME AND
THE DIFFERENCE CANNOT BE RESOLVED BY
TRANSLATION

-332
7
SYSSTRINGS DOES NOT DEFINE A TRANSLATION FROM Error
:1
CCSID TO

-331 A STRING CANNOT BE ASSIGNED TO A HOST VARIABLE Error

D
BECAUSE IT CANNOT BE TRANSLATED.
REASON , CHARACTER , POSITION
eI

-330 A STRING CANNOT BE USED BECAUSE IT CANNOT BE Error

at

TRANSLATED. REASON , CHARACTER , HOST VARIABLE

-327 THE ROW CANNOT BE INSERTED BECAUSE IT IS Error

ci

OUTSIDE THE BOUND OF THE PARTITION RANGE FOR

THE LAST PARTITION
o

-314 THE STATEMENT CONTAINS AN AMBIGUOUS HOST Error

ss

VARIABLE REFERENCE

-313 THE NUMBER OF HOST VARIABLES SPECIFIED IS NOT Error

A

EQUAL TO THE NUMBER OF PARAMETER MARKERS

-312 IS AN UNDEFINED OR UNUSABLE HOST VARIABLE OR Error

IS USED IN A DYNAMIC SQL STATEMENT OR A
TRIGGER DEFINITION

-311 THE LENGTH OF INPUT HOST VARIABLE NUMBER IS Error

NEGATIVE OR GREATER THAN THE MAXIMUM

-310 DECIMAL HOST VARIABLE OR PARAMETER CONTAINS Error

NON-DECIMAL DATA

-309 A PREDICATE IS INVALID BECAUSE A REFERENCED Error

HOST VARIABLE HAS THE NULL VALUE

Page 21 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-305 THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT Error
HOST VARIABLE NUMBER BECAUSE NO INDICATOR
VARIABLE IS SPECIFIED

-304 A VALUE WITH DATA TYPE CANNOT BE ASSIGNED TO A Error

HOST VARIABLE BECAUSE THE VALUE IS NOT
WITHIN THE RANGE OF THE HOST VARIABLE IN
POSITION WITH DATA TYPE

8
-303 : A VALUE CANNOT BE ASSIGNED TO OUTPUT HOST Error
VARIABLE NUMBER BECAUSE THE DATA TYPES ARE

8
NOT COMPARABLE

78
-302 THE VALUE OF INPUT VARIABLE OR PARAMETER Error
NUMBER IS INVALID OR TOO LARGE FOR THE

-301
7
TARGET COLUMN OR THE TARGET VALUE
THE VALUE OF INPUT HOST VARIABLE OR PARAMETER Error
:1
NUMBER CANNOT BE USED AS SPECIFIED
BECAUSE OF ITS DATA TYPE
D
-300 THE STRING CONTAINED IN HOST VARIABLE OR Error
PARAMETER IS NOT NUL-TERMINATED
eI

-251 TOKEN IS NOT VALID Error

at

-250 THE LOCAL LOCATION NAME IS NOT DEFINED WHEN Error

PROCESSING A THREE-PART OBJECT NAME
ci

-240 THE PART CLAUSE OF A LOCK TABLE STATEMENT IS Error

o

INVALID
ss

-229 THE LOCALE SPECIFIED IN A SET LOCALE OR OTHER Error

STATEMENT THAT IS LOCALE SENSITIVE WAS NOT
FOUND
A

-224 FETCH CANNOT MAKE AN INSENSITIVE CURSOR Error

SENSITIVE
-221 : "SET OF OPTIONAL COLUMNS" IN EXPLANATION Error
TABLE IS INCOMPLETE. OPTIONAL COLUMN IS
MISSING

-220 THE COLUMN IN EXPLANATION TABLE IS NOT Error

DEFINED PROPERLY

-219 THE REQUIRED EXPLANATION TABLE DOES NOT EXIST Error

Page 22 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-216 YOU NEED TO USE SAME NUMBER OF EXPRESSIONS ON Error
BOTH SIDES OF THE COMPARISON WHEN USING
MULTIPLE OPERANDS IN THE COMPARISON.
CORRECT EXAMPLE:
WHERE (E.SALARY, E.COMM) IN (SELECT S.PAY,
S.COMMISSION
INCORRECT EXAMPLE:
WHERE (E.SALARY, E.COMM, E.BONUS) IN (SELECT
S.PAY, S.COMMISSION

8
-214 AN EXPRESSION STARTING WITH IN THE CLAUSE IS Error

8
NOT VALID. REASON CODE =

78
-212 IS SPECIFIED MORE THAN ONCE IN THE REFERENCING Error
CLAUSE OF A TRIGGER DEFINITION

-208
7
THE ORDER BY CLAUSE IS INVALID BECAUSE COLUMN Error
:1
IS NOT PART OF THE RESULT TABLE

-206 IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED Error

D
TABLE, OR ANY TABLE IDENTIFIED IN A
FROM CLAUSE, OR IS NOT A COLUMN OF THE
eI

TRIGGERING TABLE OF A TRIGGER

at

-205 IS NOT A COLUMN OF TABLE Error

-204 IS AN UNDEFINED NAME Error

ci

-203 A REFERENCE TO COLUMN IS AMBIGUOUS Error

o

-199 ILLEGAL USE OF KEYWORD , TOKEN WAS EXPECTED Error

ss

-198 THE OPERAND OF THE PREPARE OR EXECUTE Error

IMMEDIATE STATEMENT IS BLANK OR EMPTY
A

-197 QUALIFIED COLUMN NAMES IN ORDER BY CLAUSE NOT Error

PERMITTED WHEN UNION OR UNION ALL
SPECIFIED

-191 A STRING CANNOT BE USED BECAUSE IT IS INVALID Error

MIXED DATA

-190 ATTRIBUTES OF COLUMN IN TABLE ARE NOT Error

COMPATIBLE WITH THE EXISTING COLUMN

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

OR SUBTYPE

-188 THE STRING REPRESENTATION OF A NAME IS INVALID Error

Page 23 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-187 A REFERENCE TO A CURRENT DATE/TIME SPECIAL Error
REGISTER IS INVALID BECAUSE THE MVS TOD
CLOCK IS BAD OR THE MVS PARMTZ IS OUT OF RANGE

-186 THE LOCAL DATE LENGTH OR LOCAL TIME LENGTH HAS Error
BEEN INCREASED AND EXECUTING PROGRAM
RELIES ON THE OLD LENGTH

-185 THE LOCAL FORMAT OPTION HAS BEEN USED WITH A Error

8
DATE OR TIME AND NO LOCAL EXIT HAS BEEN
INSTALLED

8
78
-184 AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE Error
CONTAINS A PARAMETER MARKER

-183

7
AN ARITHMETIC OPERATION ON A DATE OR TIMESTAMP
HAS A RESULT THAT IS NOT WITHIN THE
Error
:1
VALID RANGE OF DATES

-182 AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE Error

D
IS INVALID
eI

-181 THE STRING REPRESENTATION OF A DATETIME VALUE Error

IS NOT A VALID DATETIME VALUE
at

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

-173 UR IS SPECIFIED ON THE WITH CLAUSE BUT THE Error
ci

CURSOR IS NOT READ-ONLY

o

-171 THE DATA TYPE, LENGTH, OR VALUE OF ARGUMENT OF Error

IS INVALID
ss

-170 THE NUMBER OF ARGUMENTS SPECIFIED FOR IS Error

INVALID
A

-164 DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW Error

WITH QUALIFICATION

-161 THE INSERT OR UPDATE IS NOT ALLOWED BECAUSE A Error

RESULTING ROW DOES NOT SATISFY THE VIEW
DEFINITION

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

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

THAN A(N)

Page 24 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-158 THE NUMBER OF COLUMNS SPECIFIED FOR THE VIEW Error
IS NOT THE SAME AS THE NUMBER OF COLUMNS
SPECIFIED BY THE SELECT CLAUSE,
OR THE NUMBER OF COLUMNS SPECIFIED IN THE
CORRELATION CLAUSE IN A FROM CLAUSE IS NOT THE
SAME AS THE NUMBER OF COLUMNS IN THE
CORRESPONDING TABLE, VIEW, TABLE EXPRESSION,
OR TABLE FUNCTION

8
-157 ONLY A TABLE NAME CAN BE SPECIFIED IN A FOREIGN Error
KEY CLAUSE. IS NOT THE NAME OF A TABLE

8
78
-156 STATEMENT DOES NOT IDENTIFY A TABLE Error
-154 THE STATEMENT IS INVALID BECAUSE THE VIEW OR Error
TABLE DEFINITION IS NOT VALID

-153
7
THE STATEMENT IS INVALID BECAUSE THE VIEW OR Error
:1
TABLE DEFINITION DOES NOT INCLUDE A
UNIQUE NAME FOR EACH COLUMN
-152 THE DROP CLAUSE IN THE ALTER STATEMENT IS Error
D
INVALID BECAUSE IS A
eI

-151 THE UPDATE STATEMENT IS INVALID BECAUSE THE Error

CATALOG DESCRIPTION OF COLUMN INDICATES
at

THAT IT CANNOT BE UPDATED

-150 THE OBJECT OF THE INSERT, DELETE, OR UPDATE Error
STATEMENT IS A VIEW OR TRANSITION TABLE
ci

FOR WHICH THE REQUESTED OPERATION IS NOT

PERMITTED
o

-148 THE SOURCE TABLE CANNOT BE RENAMED OR Error

ss

ALTERED

-147 ALTER FUNCTION FAILED BECAUSE SOURCE Error

A

FUNCTIONS CANNOT BE ALTERED

-143 INVALID SECTION NUMBER Error

-142 SQL STATEMENT IS NOT SUPPORTED Error

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

-137 THE LENGTH OF THE RESULT OF A CONCATENATION Error

EXCEEDS 32,764 (IF CHARACTER OPERANDS) OR
16,382 (IF GRAPHIC OPERANDS).
-136 SORT CANNOT BE EXECUTED BECAUSE THE SORT KEY Error
LENGTH IS GREATER THAN 4000 BYTES

Page 25 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-134 IMPROPER USE OF LONG STRING COLUMN OR AN Error
EXPRESSION OF MAXIMUM LENGTH GREATER THAN 255

-133 A COLUMN FUNCTION IN A SUBQUERY OF A HAVING Error

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

8
-132 AN OPERAND OF X IS NOT VALID Error
-131 STATEMENT WITH LIKE PREDICATE HAS INCOMPATIBLE Error

8
DATA TYPES

78
-130 THE ESCAPE CLAUSE CONSISTS OF MORE THAN ONE Error
CHARACTER, OR THE STRING PATTERN CONTAINS

7
AN INVALID OCCURRENCE OF THE ESCAPE CHARACTER
:1
-129 THE STATEMENT CONTAINS TOO MANY TABLE NAMES Error

-128 INVALID USE OF NULL IN A PREDICATE Error

D

-127 DISTINCT IS SPECIFIED MORE THAN ONCE IN A Error

eI

SUBSELECT
at

-126 THE SELECT STATEMENT CONTAINS BOTH AN UPDATE Error

CLAUSE AND AN ORDER BY CLAUSE
-125 AN INTEGER IN THE ORDER BY CLAUSE DOES NOT Error
ci

IDENTIFY A COLUMN OF THE RESULT

-123 THE PARAMETER IN POSITION IN THE FUNCTION Error
o

MUST BE A CONSTANT OR KEYWORD

ss

-122 A SELECT STATEMENT WITH NO GROUP BY CLAUSE Error

CONTAINS A COLUMN NAME AND A COLUMN
FUNCTION IN THE SELECT CLAUSE OR A COLUMN NAME
A

IS CONTAINED IN THE SELECT CLAUSE BUT NOT IN

THE GROUP BY CLAUSE

-121 THE COLUMN IS IDENTIFIED MORE THAN ONCE IN THE Error

INSERT OR UPDATE OR SET TRANSITION
VARIABLE STATEMENT

-120 A WHERE CLAUSE, SET CLAUSE, VALUES CLAUSE, OR A Error

SET ASSIGNMENT STATEMENT INCLUDES A
COLUMN FUNCTION

-119 A COLUMN IDENTIFIED IN A HAVING CLAUSE IS NOT Error

INCLUDED IN THE GROUP BY CLAUSE

Page 26 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-118 THE OBJECT TABLE OR VIEW OF THE DELETE OR Error
UPDATE STATEMENT IS ALSO IDENTIFIED IN A FROM
CLAUSE

-117 THE NUMBER OF ASSIGNED VALUES IS NOT THE SAME Error

AS THE NUMBER OF SPECIFIED OR IMPLIED
COLUMNS

-115 A PREDICATE IS INVALID BECAUSE THE COMPARISON Error

8
OPERATOR IS FOLLOWED BY A PARENTHESIZED
LIST OR BY ANY OR ALL WITHOUT A SUBQUERY

8
-114 THE LOCATION NAME DOES NOT MATCH THE CURRENT Error

78
SERVER

-113 INVALID CHARACTER FOUND IN: . REASON CODE Error

-112
7
THE OPERAND OF A COLUMN FUNCTION IS ANOTHER Error
:1
COLUMN FUNCTION

-111 A COLUMN FUNCTION DOES NOT INCLUDE A COLUMN Error

D
NAME
eI

-110 INVALID HEXADECIMAL LITERAL BEGINNING Error

-109 CLAUSE IS NOT PERMITTED Error
at

-108 THE NAME IS QUALIFIED INCORRECTLY Error

ci

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

IS
o

-105 INVALID STRING Error

ss

-104 ILLEGAL SYMBOL "". SOME SYMBOLS THAT MIGHT BE Error

LEGAL ARE:
A

-103 IS AN INVALID NUMERIC LITERAL Error

-102 LITERAL STRING IS TOO LONG. STRING BEGINS Error

-101 THE STATEMENT IS TOO LONG OR TOO COMPLEX Error

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

-084 UNACCEPTABLE SQL STATEMENT Error

-079 QUALIFIER FOR DECLARED GLOBAL TEMPORARY TABLE Error

OR INDEX MUST BE SESSION, NOT
-069 INVALID SPECIFICATION : Error

Page 27 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
-029 INTO CLAUSE REQUIRED Error

-010 THE STRING CONSTANT BEGINNING IS NOT Error

TERMINATED

-007 STATEMENT CONTAINS THE ILLEGAL CHARACTER Error

000 SUCCESSFUL EXECUTION Success

+012 THE UNQUALIFIED COLUMN NAME WAS INTERPRETED Warning

8
AS A CORRELATED REFERENCE

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

78
+100 NOT FOUND:ROW NOT FOUND FOR FETCH, UPDATE, OR Warning
DELETE, OR THE RESULT OF A QUERY IS AN EMPTY
TABLE

+110
7
SQL UPDATE TO A DATA CAPTURE TABLE NOT Warning
:1
SIGNALED TO ORIGINATING SUBSYSTEM
D
+111 THE SUBPAGES OPTION IS NOT SUPPORTED FOR TYPE Warning
2 INDEXES
eI

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

THE NUMBER OF OBJECT COLUMNS
at

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

ci

+203 THE QUALIFIED COLUMN NAME WAS RESOLVED USING Warning

A NON-UNIQUE OR UNEXPOSED NAME
o

+204 IS AN UNDEFINED NAME Warning

ss

+206 IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED Warning

TABLE, OR ANY TABLE IDENTIFIED IN A FROM CLAUSE
A

+218 THE SQL STATEMENT REFERENCING A REMOTE OBJECT Warning

CANNOT BE EXPLAINED

+219 THE REQUIRED EXPLANATION TABLE DOES NOT EXIST Warning

+220 THE COLUMN IN EXPLANATION TABLE IS NOT Warning

DEFINED PROPERLY

+222 TRYING TO FETCH A ROW THAT FELT THROUGH A Warning

DELETE HOLE
+223 TRYING TO FETCH A ROW THAT FELT THROUGH A Warning
UPDATE HOLE
+231 FETCH BUT YOU DID A BEFORE OR AFTER AND YOU Warning
ARE NOT ON VALID ROW.

Page 28 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

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

+237 SQLDA INCLUDES SQLVAR ENTRIES, BUT ARE Warning

REQUIRED BECAUSE AT LEAST ONE OF THE COLUMNS
BEING DESCRIBED IS A DISTINCT TYPE

+238 SQLDA INCLUDES SQLVAR ENTRIES, BUT SQLVAR Warning

ENTRIES ARE NEEDED FOR COLUMNS BECAUSE

8
AT LEAST ONE OF THE COLUMNS BEING DESCRIBED IS
A LOB

8
78
+239 SQLDA INCLUDES SQLVAR ENTRIES, BUT ARE Warning
REQUIRED FOR COLUMNS BECAUSE AT LEAST ONE
OF THE COLUMNS BEING DESCRIBED IS A DISTINCT
TYPE

7
:1
+304 A VALUE WITH DATA TYPE CANNOT BE ASSIGNED TO A Warning
HOST VARIABLE BECAUSE THE VALUE IS
NOT WITHIN THE RANGE OF THE HOST VARIABLE IN
D
POSITION WITH DATA TYPE
eI

+331 THE NULL VALUE HAS BEEN ASSIGNED TO A HOST Warning

VARIABLE BECAUSE THE STRING CANNOT BE
at

TRANSLATED. REASON , CHARACTER , HOST VARIABLE

ci

+339 THE SQL STATEMENT HAS BEEN SUCCESSFULLY Warning

EXECUTED BUT THERE MAY BE SOME CHARACTER
o

CONVERSION INCONSISTENCIES
ss

+394 USER SPECIFIED OPTIMIZATION HINTS USED DURING Warning

ACCESS PATH SELECTION
A

+395 USER SPECIFIED OPTIMIZATION HINTS ARE INVALID Warning

(REASON CODE = ''). THE OPTIMIZATION HINTS ARE
IGNORED

+402 : LOCATION IS UNKNOWN Warning

+403 THE LOCAL OBJECT REFERENCED BY THE CREATE ALIAS Warning

STATEMENT DOES NOT EXIST

+434 OPTION IS A DEPRECATED FEATURE Warning

+445 VALUE HAS BEEN TRUNCATED Warning

+462 EXTERNAL FUNCTION OR PROCEDURE (SPECIFIC Warning
NAME) HAS RETURNED A WARNING SQLSTATE, WITH
DIAGNOSTIC TEXT

Page 29 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

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

+466 PROCEDURE RETURNED QUERY RESULT SETS Warning

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

+495 ESTIMATED PROCESSOR COST OF PROCESSOR Warning

SECONDS ( SERVICE UNITS) IN COST CATEGORY

8
EXCEEDS A RESOURCE LIMIT WARNING THRESHOLD OF
SERVICE UNITS

8
78
+535 THE RESULT OF THE POSITIONED UPDATE OR DELETE Warning
MAY DEPEND ON THE ORDER OF THE ROWS

+541

7
THE REFERENTIAL OR UNIQUE CONSTRAINT HAS BEEN
IGNORED BECAUSE IT IS A DUPLICATE
Warning
:1
+551 DOES NOT HAVE THE PRIVILEGE TO PERFORM Warning
OPERATION ON OBJECT
D

+552 DOES NOT HAVE THE PRIVILEGE TO PERFORM Warning

eI

OPERATION
at

+558 THE WITH GRANT OPTION IS IGNORED Warning

+561 THE ALTER, INDEX, REFERENCES, AND TRIGGER Warning

ci

PRIVILEGES CANNOT BE GRANTED TO PUBLIC AT ALL

LOCATIONS
o

+562 A GRANT OF A PRIVILEGE WAS IGNORED BECAUSE THE Warning

ss

GRANTEE ALREADY HAS THE PRIVILEGE FROM THE

GRANTOR
+585 THE SCHEMA NAME APPEARS MORE THAN ONCE IN Warning
A

THE CURRENT PATH

+599 COMPARISON FUNCTIONS ARE NOT CREATED FOR A Warning

DISTINCT TYPE BASED ON A LONG STRING DATA TYPE

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

PENDING

+625 THE DEFINITION OF TABLE HAS BEEN CHANGED TO Warning

INCOMPLETE

+626 DROPPING THE INDEX TERMINATES ENFORCEMENT OF Warning

THE UNIQUENESS OF A KEY THAT WAS DEFINED
WHEN THE TABLE WAS CREATED

Page 30 of 31
 SQL Codes

SQL DESCRIPTION CATEGORY

CODE
+645 WHERE NOT NULL IS IGNORED BECAUSE THE INDEX Warning
KEY CANNOT CONTAIN NULL VALUES

+650 THE TABLE BEING CREATED OR ALTERED CAN NOT Warning

BECOME A DEPENDENT TABLE

+653 TABLE IN PARTITIONED TABLE SPACE IS NOT Warning

AVAILABLE BECAUSE ITS PARTITIONED INDEX HAS
NOT BEEN CREATED

8
+655 STOGROUP HAS BOTH SPECIFIC AND NON-SPECIFIC Warning

8
VOLUME IDS. IT WILL NOT BE ALLOWED IN

78
FUTURE RELEASES.

+658 THE SUBPAGES VALUE IS IGNORED FOR THE CATALOG Warning

INDEX

7
:1
+664 THE INTERNAL LENGTH OF THE LIMIT-KEY FIELDS FOR Warning
THE PARTITIONED INDEX EXCEEDS THE
LENGTH IMPOSED BY THE INDEX MANAGER
D

+738 DEFINITION CHANGE OF MAY REQUIRE SIMILAR Warning

eI

CHANGE ON READ-ONLY SYSTEMS

+799 A SET STATEMENT REFERENCES A SPECIAL REGISTER Warning
at

THAT DOES NOT EXIST AT THE SERVER SITE

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

+806 BIND ISOLATION LEVEL RR CONFLICTS WITH Warning

o

TABLESPACE LOCKSIZE PAGE OR LOCKSIZE ROW AND

LOCKMAX 0
ss

+807 THE RESULT OF DECIMAL MULTIPLICATION MAY CAUSE Warning

OVERFLOW
A

+863 THE CONNECTION WAS SUCCESSFUL BUT ONLY SBCS Warning

WILL BE SUPPORTED

+883 ROLLBACK TO SAVEPOINT OCCURRED WHEN THERE Warning

WERE OPERATIONS THAT CANNOT BE UNDONE OR AN
OPERATION THAT CANNOT BE UNDONE OCCURRED
WHEN THERE WAS A SAVEPOINT OUTSTANDING

Page 31 of 31