Frequently faced
mainframes Errors / Abdends and Complete List follows
(JCL | DB2 | VSAM | CICS)
S0CB - Attempting to
divide by 0 and not using ON SIZE ERROR
S002 - Very large record
length/ wrong record length
Sx22 - Job has been
cancelled. The value of x will vary depending on the way the job was cancelled.
S222 - Means job was
cancelled by a user or operator without a dump. If a TSO session times out you
will probably get an S522 abend code.
S222 - The job was
cancelled (by subsystem or operator) because it violated some restriction
S322 - Indicates a Time
Out abend. Program has taken more CPU time than the default limit for the JOB
Class could indicate an infinite loop
S522 - JOB or TSO session
exceeded maximum job wait time OR operator did not mount the
require tape within allowed time limit
S806 - Load module not
found
S837 - Space problem,
Allotted space is not enough for data set
S913 - You are trying to
access a dataset, which you are not authorized to use.
S0C1 - Operation
Exception. Check for subscript errors, missing DD card, file not opened.
(Missing / Misspelled DD name, Read / Write to un-opened dataset, Read to
dataset that opened in OUTPUT mode, Write to
dataset that opened in INPUT mode. Called sub-program not found)
SOC4 - 1. Index exceeds
the size of table
2. Trying to use
File Section variables without opening the file
(Missing Select statement (during
compile), Bad Subscript / index, Protection Exception,
Missing parameters on
called sub-program, Read / Write to un-opened file,
Move data from / to
un-opened file)
SOC5 - 1. Bad Subscript /
Index
2. Close an un-opened dataset
3. Bad exit from a perform statement
SOC7 - 1. Moving
non-numeric value to numeric field
2. Not initializing
the numeric variables before first use
SB37 - Insufficient disk
space (End of volume and no further volume specified)
SD37 - Insufficient disk
space. (No secondary allocation was specified)
SE37 - Insufficient disk
space. (Max. of 16 extents already allocated)
U1026 - COBOL sort
failed.
U1056 - Program didn't
close a file before ending
00 - Successful
+100
- End of cursor /
Successful Row not found
-104 - SQL Syntax Error
-180 to -189 String
representation of DATE, TIIME, TIMESTAMP is invalid / format error
-204 - Object not defined
to DB2 / Table or Column not found
-205 - Column name not in
specified DB2 table
-206 - Column does not
exist in any table in the SELECT
-302 to -309 Type mismatch error
-501 - Fetch without opening
the Cursor
-530 to
–542 Referential Integrity
Error
-551 - Not authorized to
access DB2
-803 - Unique index
violation. Try to insert duplicate record (Duplicate Error)
-805 - Invalid Plan. DBRM
or PACKAGE not found in PLAN
-811 - Cursor should be
used, when more than one row returned as a result of a singleton
SELECT query
-818 - Timestamp mismatch
between plan and load module
-904 - Resources not found
-911 - Deadlock with
rollback
-913 - Deadlock without
rollback
-923 - DB2 Down
-925 - SQL commit used in
CICS program
00 - SUCCESSFUL
COMPLETION
02 - DUPLICATE KEY,
NON-UNIQUE ALT INDEX
04 - READ, WRONG LENGTH
RECORD
05 - OPEN, FILE NOT
PRESENT
10 - END OF FILE
20 - INVALID KEY VSAM
KSDS OR RRDS
21 - SEQUENCE ERROR, ON
WRITE OR CHANGING KEY ON REWRITE
22 - DUPLICATE KEY
23 - RECORD NOT FOUND -
(when we are trying to access a record with key)
or FILE NOT
FOUND
35 - OPEN, FILE NOT
PRESENT
When we
will use this code in our program?
There are
situations where file should be read if exist,
write if it
does not when you don’t know whether file exists are not,
first you
will open file in I-O mode and check status code.
if it is 35
then open that file for output file.
Other wise
you will continue with your logic
39 - LOGIC ERROR
41 - OPENING A FILE THAT
IS ALREADY OPENED
42 - CLOSEING A FILE
WITHOUT OPEN.
43 - DELETE OR REWRITE
& NO GOOD READ FIRST
46 - SEQUENTIAL READ
WITHOUT POSITIONING
47 - READING FILE NOT
OPEN AS INPUT/IO/EXTEND
48 - WRITE WITHOUT OPEN
IN IO MODE
49 - DELETE OR REWRITE
WITHOUT OPEN IN IO MODE
92 - LOGIC ERROR /
OPENING A OPEN FILE / READING OUTPUT
FILE /
WRITING INTO
A INPUT
FILE /
DEL or REW BUT NO PRIOR READ
94 - SEQUENTIAL READ
AFTER END OF FILE / NO CURRENT REC
POINTER FOR SEQ
96 - MISSING DD
STATEMENT IN JCL
97 - OPEN OK, FILE
INTEGRITY VERIFIED
When
we will use this in our programs?
We use this
code whenever we open the file,
if status
code is 00 or 97 we will proceed with our logic,
other wise,
call error routine. Usually, it may come when file was not closed.
for
example,
IF
WS-FILE-STATUS NOT = '00' AND '97'
PERFORM
ERROR-ROUTINE
END-IF.
CICS Abend / Error Codes
Code
|
Condition
|
Code
|
Condition
|
Code
|
Condition
|
Code
|
Condition
|
|||
AEIA
|
ERROR
|
AEIR
|
NOSPACE
|
AEYA
|
INVERRTERM
|
AEYU
|
IGREQCD
|
|||
AEID
|
EOF
|
AEIS
|
NOTOPEN
|
AEYB
|
INVMPSZ
|
AEYV
|
SESSIONERR
|
|||
AEIE
|
EODS
|
AEIT
|
ENDFILE
|
AEYC
|
IGREQID
|
AEYY
|
NOTALLOC
|
|||
AEIH
|
INBFMG
|
AEIU
|
LENGERR
|
AEYG
|
JIDERR
|
AEYZ
|
CBIDERR
|
|||
AEII
|
NONVAL
|
AEIW
|
QZERO
|
AEYH
|
QIDERR
|
AEY1
|
INVPARTNSET
|
|||
AEIJ
|
NOSTART
|
AEIZ
|
ITEMERR
|
AEYJ
|
DSSTAT
|
AEY2
|
INVPARTN
|
|||
AEIK
|
TERMIDERR
|
AEIO
|
PGMIDERR
|
AEYK
|
SELNERR
|
AEY3
|
PARTNFAIL
|
|||
AEIL
|
DSIDERR
|
AEI1
|
TRANSIDERR
|
AEYL
|
FUNCERR
|
|||||
AEIM
|
NOTFND
|
AEI2
|
ENDDATA
|
AEYM
|
UNEXPIN
|
|||||
AEIN
|
DUPREC
|
AEI3
|
INVTSREQ
|
AEYN
|
NOPASSBKRD
|
|||||
AEIO
|
DUPKEY
|
AEI8
|
TSIOERR
|
AEYO
|
NOPASSBKWR
|
|||||
AEIP
|
INVREQ
|
AEI9
|
MAPFAIL
|
AEYR
|
ISCINVREQ
|
|||||
AEIQ
|
IOERR
|
AEXL
|
DISABLED
|
AEYT
|
ENVDEFERR
|
ABEND CODES :
ABMG : Requested BMS service not included at system generation
ABMP : PA/PF key not defined for page retrieval
AEY7 : Resource security check failed
AEY9 : Unsupported command issued
AICA : Transaction abended as a runaway task
AKCS : Deadlock time-out encountered
ASRA : ABEND due to
program interruption
ASRB : ABEND due to OS ABEND intercepted by CICS
JCL ABEND Codes Complete List:
SB37
SD37
SE37
|
Space
Abends
SB37
- Insufficient disk space
SD37
- Insufficient disk space
SE37
- Insufficient disk space.
The maximum number of extents would be exceeded. For instance, when exceeding 16 extents of a PDS. An E37 on tape datasets is most often caused when the number of requested volumes is exceeded. The default is 5, therefore a request for the sixth volume will fail with a E37 |
S80A
S804
S822
|
S80A,
S804 Region too small for the program to run
S822
- When the requested region is not available
|
S122
|
The
job was canceled because it violated some restriction. A dump was requested
|
S222
|
The
job was cancelled because it violated some restriction. No dump was
requested.
|
S322
|
The
job used more CPU time than it should have. Either the estimate is wrong or
the program is in an uncontrolled loop.
|
S522
|
Job
was waiting too long.
|
S722
|
Too
many lines of print.
|
S706
|
The
program on the library was not executable.
See linkage editor report that put the program on library |
S806
|
Program
not on the library. May need a JOBLIB or STEPLIB.
|
S0C1
|
Executing
a program with an unresolved external reference.
Calling a program and the program was not included during link edit. An uncontrolled loop moved data on top of instructions. Reading a file that is not open Your SORTIN DCB was not correct Mixing compile options RES and NORES in different modules |
S0C4
|
An
uncontrolled loop moved data on top of instructions.
referencing a field in a record of a closed file referencing an item in Linkage-Section when there was no PARM= in the JCL. Calling/called programs have different length for items passed in Linkage Section with COBOL Sort, doing a STOP RUN or GOBACK while an input or output procedure is still running |
S0C5
|
See
reasons as for 0C4.
Falling through into an ENTRY statement Transferring control into the middle of a SORT procedure. |
S0C7
|
Program
attempting to do math on illegal data.
Data is not numeric, but should be. Moving ZEROS to group item whose subordinate items are packed-decimal Uninitialized packed-decimal fields. Record description is wrong. Field starts or ends in the wrong place in the record. Find record description of creating program. |
S0C8
|
|
S0C9
|
|
S0CA
|
Decimal
point overflow error
|
S0CB
|
Attempting
to divide by 0 and not using ON SIZE ERROR
|
S0CC
|
Floating
Pointing
|
S0CD
|
Exponent
overflow and Underflow execptions
|
S013
|
|
S878
|
|
S913
|
|
SB14
|
|
S001-4
|
Input
file record length is not equal to the length stated in the DD or the FD
Wrong
length record.
IO
error, damaged tape, device malfunction.
With
disk, reading a dataset that was allocated but never written to.
Writing to input file Concatenation of files with different record lengths or record formats. |
SOC1-5
|
Reading
after the end of the file by non-COBOL program.
COBOL
intercepts this and displays "QSAM error, status 92".
Out
of space on output disk file.
|
S002
|
|
CICS Abend Codes
CODE CODITION
AEIA ERROR
AEID EOF
AEIE EODS
AEIH INBFMG
AEII NONVAL
AEIJ NOSTART
AEIK TERMIDERR
AEIL DSIDERR
AEIM NOTFND
AEIN DUPREC
AEIO DUPKEY
AEIP INVREQ
AEIQ IOERR
AEIR NOSPACE
AEIS NOTOPEN
AEIT ENDFILE
AEIU LENGERR
AEIW QZERO
AEIZ ITEMERR
AEIO PGMIDERR
AEI1 TRANSIDERR
AEI2 ENDDATA
AEI3 INVTSREQ
AEI8 TSIOERR
AEI9 MAPFAIL
AEXL DISABLED
AEYA INVERRTERM
AEYB INVMPSZ
AEYC IGREQID
AEYG JIDERR
AEYH QIDERR
AEYJ DSSTAT
AEYK SELNERR
AEYL FUNCERR
AEYM UNEXPIN
AEYN NOPASSBKRD
AEYO NOPASSBKWR
AEYR ISCINVREQ
AEYT ENVDEFERR
AEYU IGREQCD
AEYV SESSIONERR
AEYY NOTALLOC
AEYZ CBIDERR
AEY1 INVPARTNSET
AEY2 INVPARTN
AEY3 PARTNFAIL
ABEND CODES :
ABMG : Requested BMS service not included at system generation
ABMP : PA/PF key not defined for page retrieval
AEY7 : Resource security check failed
AEY9 : Unsupported command issued
AICA : Transaction abended as a runaway task
AKCS : Deadlock time-out encountered
ASRA : ABEND due to program interruption
ASRB : ABEND due to OS ABEND intercepted by CICS
DB2 Return Codes
SQLCODE +100 SQLSTATE
02000
Row not found or end of cursor
SQLCODE -102 String
constant is too long
SQLCODE -117 The number
of values you are trying to INSERT
does not
match the number of columns
SQLCODE -180 SQLSTATE
22007
Bad data in
Date/Time/Timestamp
String
representation of DATE, TIME, TIMESTAMP is invalid
SQLCODE -181 SQLSTATE
22007
Bad data in
Date/Time/Timestamp
Value for DATE,
TIME, TIMESTAMP is invalid
SQLCODE -199 Illegal use
of the specified keyword.
SQLCODE -204 Object not
defined to DB2
SQLCODE -205 Column name
not in specified table
SQLCODE -206 Column does
not exist in any table in the SELECT
SQLCODE -216
You need to use the same number of
expressions on both sides of the comparison.
when using multiple operands in a
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
SQLCODE +222 Trying to
fetch a row that fell through a DELETE hole
SQLCODE +223 Trying to
fetch a row that fell through an UPDATE hole
SQLCODE -224 FETCH
cannot make an INSENSITIVE cursor SENSITIVE
SQLCODE -229 The locale
specified in a SET LOCALE statement was not found.
SQLCODE +231 FETCH
but you did a BEFORE or AFTER and
you are not on a valid row
SQLCODE +304 Value
cannot be assigned to this host variable because it is out of range
SQLCODE -305 Null
indicator needed
SQLCODE -311 Varchar,
insert or update.
You
didn’t set the -LEN field with the right data length
SQLCODE -482 he
procedure returned no locators
SQLCODE -501 Cursor not
open on FETCH
SQLCODE -502 Opening
cursor that is already open
SQLCODE -503 Updating
column which needs to be specified in FOR UPDATE OF
SQLCODE -530 SQLSTATE
23503
Referential
integrity prevents the INSERT/UPDATE
SQLCODE -532 SQLSTATE
23504
Referential
integrity (DELETE RESTRICT rule) prevents the DELETE
SQLCODE -536 SQLSTATE
42914
Referential
integrity (DELETE RESTRICT rule) prevents the DELETE
SQLCODE -545 SQLSTATE
23513
Check
constraint prevents the INSERT/UPDATE
SQLCODE -747 The table
specified is not available
because tables and/or indexes need to be created.
SQLCODE +802 The null
indicator was set to -2
because an arithmetic statement didn't work.
SQLCODE -803 SQLSTATE
23505
Duplicate
key on insert or update
SQLCODE -805
DBRM or
package not found in plan
Is plan name
correct?
SQLCODE -811 More than
one row retrieved in SELECT INTO
SQLCODE -818 Plan and
program: timestamp mismatch
SQLCODE -904 SQLSTATE
57011
Unavailable
resource. Someone is locking the data you need
you may
choose to terminate the program
SQLCODE -911 SQLSTATE
40000
Deadlock or
timeout. Rollback has been done.
SQLCODE -913 SQLSTATE
40502
Your program
was the victim of a deadlock or timeout.
NO rollback
has been done.
You
should do a ROLLBACK.
SQLCODE -922
Authorization needed
SQLCODE -927 The
language interface was called but no connection had been
SQLCODE
reference: All the sqlcodes from -991 to +883 in DB2 Version 7.
Top of Page
SQLCODE -991,
Error: CALL ATTACH WAS UNABLE TO ESTABLISH AN IMPLICIT CONNECT OR OPEN TO
DB2.
RC1= RC2=
SQLCODE -981,
Error: THE SQL STATEMENT FAILED BECAUSE THE RRSAF CONNECTION IS NOT IN
A STATE THAT ALLOWS SQL OPERATIONS, REASON
SQLCODE -950,
Error: THE LOCATION NAME SPECIFIED IN THE CONNECT STATEMENT IS INVALID OR NOT
LISTED IN THE COMMUNICATIONS DATABASE
SQLCODE -948,
Error: DISTRIBUTED OPERATION IS INVALID
SQLCODE -947,
Error: THE SQL STATEMENT FAILED BECAUSE IT WILL CHANGE A TABLE DEFINED WITH
DATA CAPTURE
CHANGES, BUT THE DATA CANNOT BE PROPAGATED
SQLCODE -939,
Error: ROLLBACK REQUIRED DUE TO UNREQUESTED ROLLBACK OF A REMOTE SERVER
SQLCODE -929,
Error: FAILURE IN A CHANGED DATA CAPTURE EXIT:
SQLCODE -927,
Error: THE LANGUAGE INTERFACE (LI) WAS CALLED WHEN THE CONNECTING ENVIRONMENT
WAS NOT
ESTABLISHED. THE PROGRAM SHOULD BE INVOKED
UNDER THE DSN COMMAND
SQLCODE -926,
Error: ROLLBACK NOT VALID IN IMS OR CICS ENVIRONMENT
SQLCODE -925,
Error: COMMIT NOT VALID IN IMS OR CICS ENVIRONMENT
SQLCODE -924,
Error: DB2 CONNECTION INTERNAL ERROR, , ,
SQLCODE -923,
Error: CONNECTION NOT ESTABLISHED: DB2 , REASON , TYPE , NAME
SQLCODE -922,
Error: AUTHORIZATION FAILURE: ERROR. REASON
SQLCODE -919,
Error: A ROLLBACK OPERATION IS REQUIRED
SQLCODE -918,
Error: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE A CONNECTION HAS BEEN LOST
SQLCODE -917,
Error: BIND PACKAGE FAILED
SQLCODE -913,
Error: UNSUCCESSFUL EXECUTION CAUSED BY DEADLOCK OR TIMEOUT. REASON CODE ,
TYPE OF RESOURCE , AND RESOURCE NAME
SQLCODE -911,
Error: THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO DEADLOCK OR
TIMEOUT.
REASON ,TYPE OF RESOURCE , AND RESOURCE NAME
SQLCODE -910,
Error: THE SQL STATEMENT CANNOT ACCESS AN OBJECT ON WHICH A DROP OR ALTER IS
PENDING
SQLCODE -909,
Error: THE OBJECT HAS BEEN DELETED OR ALTERED
SQLCODE -908,
Error: ERROR USING AUTHORITY. BIND, REBIND, OR AUTO-REBIND
OPERATION IS NOT ALLOWED
SQLCODE -906,
Error: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE THIS FUNCTION IS
DISABLED DUE
TO A PRIOR ERROR
SQLCODE -905,
Error: UNSUCCESSFUL EXECUTION DUE TO RESOURCE LIMIT BEING EXCEEDED,
RESOURCE NAME = LIMIT = CPU SECONDS ( SERVICE UNITS) DERIVED FROM
SQLCODE -904,
Error: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON ,
TYPE OF RESOURCE , AND RESOURCE NAME
SQLCODE -902,
Error: POINTER TO ESSENTIAL CONTROL BLOCK(RDA/CT) HAS VALUE 0, REBIND REQUIRED
SQLCODE -901,
Error: UNSUCCESSFUL EXECUTION CAUSED BY A SYSTEM ERROR THAT DOES NOT
PRECLUDE THE SUCCESSFUL EXECUTION OF SUBSEQUENT SQL STATEMENTS
SQLCODE -900,
Error: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE THE APPLICATION
PROCESS IS NOT CONNECTED TO AN APPLICATION SERVER
SQLCODE -882,
Error: SAVEPOINT DOES NOT EXIST
SQLCODE -881,
Error: A SAVEPOINT WITH NAME ALREADY EXISTS, BUT THIS SAVEPOINT NAME
CANNOT BE REUSED
SQLCODE -880,
Error: SAVEPOINT DOES NOT EXIST OR IS INVALID IN THIS CONTEXT
SQLCODE -879,
Error: CREATE OR ALTER STATEMENT FOR CANNOT DEFINE A COLUMN, DISTINCT
TYPE, FUNCTION OR
STORED PROCEDURE PARAMETER AS MIXED OR GRAPHIC WITH ENCODING SCHEME
SQLCODE -878,
Error: THE PLAN_TABLE USED FOR EXPLAIN CANNOT BE ASCII
SQLCODE -877,
Error: CCSID ASCII IS NOT ALLOWED FOR THIS DATABASE OR TABLE SPACE
SQLCODE -876,
Error: CANNOT BE CREATED, REASON
SQLCODE -875,
Error: CANNOT BE USED WITH THE ASCII DATA REFERENCED
SQLCODE -874,
Error: THE ENCODING SCHEME SPECIFIED FOR THE MUST BE THE SAME AS THE
CONTAINING TABLE SPACE OR OTHER PARAMETERS
SQLCODE -873,
Error: DATA ENCODED WITH DIFFERENT CCSIDS CANNOT BE REFERENCED IN THE SAME SQL
STATEMENT
SQLCODE -872,
Error: A VALID CCSID HAS NOT YET BEEN SPECIFIED FOR THIS SUBSYSTEM
SQLCODE -870, Error: THE NUMBER OF HOST VARIABLES IN
THE STATEMENT IS NOT EQUAL
TO THE NUMBER OF DESCRIPTORS
SQLCODE -867,
Error: INVALID SPECIFICATION OF A ROWID COLUMN
SQLCODE -846,
Error: INVALID SPECIFICATION OF AN IDENTITY COLUMN
SQLCODE -843,
Error: THE SET CONNECTION OR RELEASE STATEMENT MUST SPECIFY AN EXISTING
CONNECTION
SQLCODE -842,
Error: A CONNECTION TO x ALREADY EXISTS
SQLCODE -840,
Error: TOO MANY ITEMS RETURNED IN A SELECT OR INSERT LIST
SQLCODE -822,
Error: THE SQLDA CONTAINS AN INVALID DATA ADDRESS OR INDICATOR VARIABLE ADDRESS
SQLCODE -820,
Error: THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE CONTAINS A VALUE
THAT
IS NOT VALID
IN THIS RELEASE
SQLCODE -819, Error: THE VIEW CANNOT BE PROCESSED
BECAUSE THE LENGTH OF ITS PARSE TREE
IN
THE CATALOG IS ZERO
SQLCODE -818,
Error: THE PRECOMPILER-GENERATED TIMESTAMP IN THE LOAD MODULE IS
DIFFERENT
FROM THE BIND TIMESTAMP BUILT FROM THE DBRM
SQLCODE -817,
Error: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE THE STATEMENT WILL RESULT
IN A PROHIBITED UPDATE OPERATION
SQLCODE -815,
Error: A GROUP BY OR HAVING CLAUSE IS IMPLICITLY OR EXPLICITLY SPECIFIED
IN A SUBSELECT OF A BASIC PREDICATE OR A SET CLAUSE OF AN UPDATE
STATEMENT
SQLCODE -812,
Error: THE SQL STATEMENT CANNOT BE PROCESSED BECAUSE A BLANK COLLECTION-ID
WAS FOUND IN THE CURRENTPACKAGESET SPECIAL REGISTER WHILE TRYING TO FORM
A QUALIFIED PACKAGE
NAME FOR PROGRAM USING PLAN
SQLCODE -811,
Error: THE RESULT OF AN EMBEDDED SELECT STATEMENT OR 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
SQLCODE -808,
Error: THE CONNECT STATEMENT IS NOT CONSISTENT WITH THE FIRST CONNECT STATEMENT
SQLCODE -807,
Error: ACCESS DENIED: PACKAGE IS NOT ENABLED FOR ACCESS FROM
SQLCODE -805,
Error: DBRM OR PACKAGE NAME NOT FOUND IN PLAN . REASON
SQLCODE -804, Error: AN ERROR WAS FOUND IN THE
APPLICATION PROGRAM INPUT PARAMETERS
FOR THE SQL STATEMENT, REASON
SQLCODE -803,
Error: AN INSERTED OR UPDATED VALUE IS INVALID 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''
SQLCODE -802,
Error: EXCEPTION ERROR HAS OCCURRED DURING OPERATION ON DATA,
POSITION
SQLCODE -798,
Error: YOU CANNOT INSERT A VALUE INTO A COLUMN THAT IS DEFINED WITH THE OPTION
GENERATED ALWAYS. COLUMN NAME
SQLCODE -797,
Error: ATTEMPT TO CREATE TRIGGER WITH AN UNSUPPORTED TRIGGERED SQL
STATEMENT
SQLCODE -771,
Error: INVALID SPECIFICATION OF A ROWID COLUMN
SQLCODE -770,
Error: TABLE CANNOT HAVE A LOB COLUMN UNLESS IT ALSO HAS A ROWID COLUMN
SQLCODE -769, Error: SPECIFICATION OF CREATE AUX
TABLE DOES NOT MATCH THE CHARACTERISTICS
OF
THE BASE TABLE
SQLCODE -768,
Error: AN AUXILIARY TABLE ALREADY EXISTS FOR THE SPECIFIED COLUMN OR PARTITION
SQLCODE -767,
Error: MISSING OR INVALID COLUMN SPECIFICATION FOR INDEX
SQLCODE -766,
Error: THE OBJECT OF A STATEMENT IS AN AUXILIARY TABLE FOR WHICH THE REQUESTED
OPERATION IS NOT
PERMITTED
SQLCODE -765,
Error: TABLE IS NOT COMPATIBLE WITH DATABASE
SQLCODE -764,
Error: A LOB TABLE SPACE AND ITS ASSOCIATED BASE TABLE SPACE MUST BE IN THE
SAME DATABASE
SQLCODE -763,
Error: INVALID TABLE SPACE NAME
SQLCODE -752,
Error: THE CONNECT STATEMENT IS INVALID BECAUSE THE PROCESS IS NOT IN THE
CONNECTABLE STATE
SQLCODE -751,
Error: (SPECIFIC NAME ) ATTEMPTED TO EXECUTE AN SQL STATEMENT THAT IS NOT
ALLOWED
SQLCODE -750,
Error: THE SOURCE TABLE CANNOT BE RENAMED BECAUSE IT IS REFERENCED
IN EXISTING VIEW DEFINITIONS OR TRIGGER DEFINITIONS
SQLCODE -748,
Error: AN INDEX ALREADY EXISTS ON AUXILIARY TABLE
SQLCODE -747,
Error: TABLE IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES
FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED
SQLCODE -746,
Error: THE SQL STATEMENT IN AN EXTERNAL FUNCTION, TRIGGER,
OR IN STORED PROCEDURE VIOLATES THE NESTING SQL RESTRICTION
SQLCODE -742,
Error: DSNDB07 IS THE IMPLICIT WORK FILE DATABASE
SQLCODE -741,
Error: A DATABASE IS ALREADY DEFINED FOR MEMBER
SQLCODE -740,
Error: FUNCTION IS DEFINED WITH THE OPTION MODIFIES SQL DATA
WHICH IS NOT VALID IN THE CONTEXT IN WHICH IT WAS INVOKED
SQLCODE -739,
Error: ALTER FUNCTION FAILED BECAUSE FUNCTIONS CANNOT MODIFY DATA WHEN
THEY ARE
PROCESSED IN PARALLEL
SQLCODE -737,
Error: IMPLICIT TABLE SPACE NOT ALLOWED
SQLCODE -736,
Error: INVALID OBID SPECIFIED
SQLCODE -735,
Error: DATABASE CANNOT BE ACCESSED BECAUSE IT IS NO LONGER A SHARED
DATABASE
SQLCODE -734,
Error: THE ROSHARE ATTRIBUTE OF A DATABASE CANNOT BE ALTERED FROM ROSHARE READ
SQLCODE -733,
Error: THE DESCRIPTION OF A TABLE SPACE, INDEX SPACE, OR TABLE IN A ROSHARE
READ DATABASE
MUST BE CONSISTENT WITH ITS DESCRIPTION IN THE OWNER SYSTEM
SQLCODE -732,
Error: THE DATABASE IS DEFINED ON THIS SUBSYSTEM WITH THE ROSHARE READ
ATTRIBUTE BUT THE
TABLE SPACE OR INDEX SPACE HAS NOT BEEN DEFINED ON THE OWNING SUBSYSTEM
SQLCODE -731,
Error: USER-DEFINED DATASET MUST BE DEFINED WITH SHAREOPTIONS (1,3)
SQLCODE -730, Error: THE PARENT OF A TABLE IN A
READ-ONLY SHARED DATABASE MUST ALSO
BE A TABLE IN A READ-ONLY SHARED DATABASE
SQLCODE -729, Error: A STORED PROCEDURE SPECIFYING
COMMIT ON RETURN CANNOT BE THE
TARGET OF A NESTED CALL STATEMENT
SQLCODE -728,
Error: DATA TYPE IS NOT ALLOWED IN DB2 PRIVATE PROTOCOL PROCESSING
SQLCODE -726,
Error: BIND ERROR ATTEMPTING TO REPLACE PACKAGE = . THERE ARE
ENABLE OR DISABLE ENTRIES
CURRENTLY ASSOCIATED WITH THE PACKAGE
SQLCODE -725,
Error: THE SPECIAL REGISTER AT LOCATION WAS SUPPLIED AN INVALID
VALUE
SQLCODE -724, Error: THE ACTIVATION OF THE
OBJECT WOULD EXCEED THE MAXIMUM LEVEL
OF INDIRECT SQL CASCADING
SQLCODE -723,
Error: AN ERROR OCCURRED IN A TRIGGERED SQL STATEMENT IN TRIGGER , SECTION
NUMBER .
INFORMATION RETURNED: SQLCODE , SQLSTATE , AND MESSAGE TOKENS
SQLCODE -722,
Error: ERROR USING AUTHORITY PACKAGE DOES NOT EXIST
SQLCODE -721,
Error: BIND ERROR FOR PACKAGE = CONTOKEN = ''X IS NOT UNIQUE SO IT CANNOT
BE CREATED
SQLCODE -720, Error: BIND ERROR, ATTEMPTING TO
REPLACE PACKAGE = WITH VERSION =
BUT THIS VERSION
ALREADY EXISTS
SQLCODE -719,
Error: BIND ADD ERROR USING AUTHORITY PACKAGE ALREADY EXISTS
SQLCODE -718,
Error: REBIND OF PACKAGE FAILED BECAUSE IBMREQD OF IS INVALID
SQLCODE -717,
Error: FOR WITH MARK FAILED BECAUSE DEPENDS ON FUNCTIONS OF
THE RELEASE FROM WHICH
FALLBACK HAS OCCURRED
SQLCODE -716,
Error: PROGRAM PRECOMPILED WITH INCORRECT LEVEL FOR THIS RELEASE
SQLCODE -715,
Error: PROGRAM WITH MARK FAILED BECAUSE IT DEPENDS ON FUNCTIONS OF
THE RELEASE FROM
WHICH FALLBACK HAS OCCURRED
SQLCODE -713,
Error: THE REPLACEMENT VALUE FOR IS INVALID
SQLCODE -697,
Error: OLD OR NEW CORRELATION NAMES ARE NOT ALLOWED 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
SQLCODE -696,
Error: THE DEFINITION OF TRIGGER INCLUDES AN INVALID USE OF CORRELATION
NAME OR TRANSITION TABLE NAME . REASON CODE=
SQLCODE -694, Error: THE DDL STATEMENT CANNOT BE
EXECUTED BECAUSE A DROP
IS PENDING ON THE DDL REGISTRATION TABLE
SQLCODE -693,
Error: THE COLUMN IN DDL REGISTRATION TABLE OR INDEX IS NOT DEFINED
PROPERLY
SQLCODE -692,
Error: THE REQUIRED UNIQUE INDEX FOR DDL REGISTRATION TABLE DOES
NOT EXIST
SQLCODE -691,
Error: THE REQUIRED REGISTRATION TABLE DOES NOT EXIST
SQLCODE -690,
Error: THE STATEMENT IS REJECTED BY DATA DEFINITION CONTROL SUPPORT.
REASON
SQLCODE -689,
Error: TOO MANY COLUMNS DEFINED FOR A DEPENDENT TABLE
SQLCODE -688,
Error: INCORRECT DATA RETURNED FROM FIELD PROCEDURE, ,
SQLCODE -687,
Error: FIELD TYPES INCOMPARABLE
SQLCODE -686,
Error: COLUMN DEFINED WITH A FIELD PROCEDURE CAN NOT COMPARE WITH ANOTHER
COLUMN WITH
DIFFERENT FIELD PROCEDURE
SQLCODE -685,
Error: INVALID FIELD TYPE,
SQLCODE -684,
Error: THE LENGTH OF LITERAL LIST BEGINNING IS TOO LONG
SQLCODE -683,
Error: THE SPECIFICATION FOR COLUMN, DISTINCT TYPE, FUNCTION, OR
PROCEDURE CONTAINS
INCOMPATIBLE CLAUSES
SQLCODE -682,
Error: FIELD PROCEDURE COULD NOT BE LOADED
SQLCODE -681,
Error: COLUMN IN VIOLATION OF INSTALLATION DEFINED FIELD PROCEDURE
RT: , RS: , MSG:
SQLCODE -680,
Error: TOO MANY COLUMNS SPECIFIED FOR A TABLE, VIEW, OR TABLE FUNCTION
SQLCODE -679,
Error: THE OBJECT CANNOT BE CREATED BECAUSE A DROP IS PENDING ON THE
OBJECT
SQLCODE -678,
Error: THE LITERAL SPECIFIED FOR THE INDEX LIMIT KEY MUST CONFORM
TO THE DATA TYPE OF THE CORRESPONDING COLUMN
SQLCODE -677,
Error: INSUFFICIENT VIRTUAL STORAGE FOR BUFFERPOOL EXPANSION
SQLCODE -676,
Error: ONLY A 4K PAGE BUFFERPOOL CAN BE USED FOR AN INDEX
SQLCODE -672,
Error: OPERATION DROP NOT ALLOWED ON TABLE
SQLCODE -671,
Error: THE BUFFERPOOL ATTRIBUTE OF THE TABLE SPACE CANNOT BE ALTERED AS
SPECIFIED BECAUSE IT
WOULD CHANGE THE PAGE SIZE OF THE TABLE SPACE
SQLCODE -670,
Error: THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT
SQLCODE -669,
Error: A TABLE IN A PARTITIONED TABLE SPACE CANNOT BE EXPLICITLY DROPPED
SQLCODE -668,
Error: THE COLUMN CANNOT BE ADDED TO THE TABLE BECAUSE THE TABLE HAS AN EDIT
PROCEDURE
SQLCODE -667,
Error: THE CLUSTERING INDEX FOR A PARTITIONED TABLE SPACE CANNOT BE EXPLICITLY
DROPPED
SQLCODE -666,
Error: CANNOT BE EXECUTED BECAUSE IS IN PROGRESS
SQLCODE -665,
Error: THE PART CLAUSE OF AN ALTER STATEMENT IS OMITTED OR INVALID
SQLCODE -663,
Error: THE NUMBER OF KEY LIMIT VALUES IS EITHER ZERO, OR GREATER THAN
THE NUMBER OF COLUMNS IN THE KEY OF INDEX
SQLCODE -662,
Error: A PARTITIONED INDEX CANNOT BE CREATED ON A NON-PARTITIONED TABLE SPACE
SQLCODE -661,
Error: INDEX CANNOT BE CREATED ON PARTITIONED TABLE SPACE BECAUSE
THE NUMBER OF PART
SPECIFICATIONS IS NOT EQUAL TO THE NUMBER OF PARTITIONS OF THE TABLE
SPACE
SQLCODE -660, Error: INDEX CANNOT BE CREATED ON
PARTITIONED TABLE SPACE x
BECAUSE KEY
LIMITS ARE NOT SPECIFIED
SQLCODE -658,
Error: A CANNOT BE DROPPED USING THE STATEMENT
SQLCODE -655,
Error: THE CREATE OR ALTER STOGROUP IS INVALID BECAUSE THE STORAGE GROUP WOULD
HAVE BOTH
SPECIFIC AND NON-SPECIFIC VOLUME IDS
SQLCODE -653,
Error: TABLE IN PARTITIONED TABLE SPACE IS NOT AVAILABLE BECAUSE
ITS PARTITIONED INDEX HAS NOT BEEN CREATED
SQLCODE -652,
Error: VIOLATION OF INSTALLATION DEFINED EDIT OR VALIDATION PROCEDURE
SQLCODE -651,
Error: TABLE DESCRIPTION EXCEEDS MAXIMUM SIZE OF OBJECT DESCRIPTOR
SQLCODE -650,
Error: THE ALTER INDEX CANNOT BE EXECUTED, REASON
SQLCODE -647,
Error: BUFFERPOOL CANNOT BE SPECIFIED BECAUSE IT HAS NOT BEEN ACTIVATED
SQLCODE -646,
Error: TABLE CANNOT BE CREATED IN SPECIFIED TABLE SPACE BECAUSE IT
ALREADY CONTAINS A TABLE
SQLCODE -644,
Error: INVALID VALUE SPECIFIED FOR KEYWORD IN STATEMENT
SQLCODE -643,
Error: CHECK CONSTRAINT EXCEEDS MAXIMUM ALLOWABLE LENGTH
SQLCODE -642,
Error: TOO MANY COLUMNS IN UNIQUE CONSTRAINTS
SQLCODE -640,
Error: LOCKSIZE ROW CANNOT BE SPECIFIED BECAUSE TABLE IN THIS TABLESPACE HAS
TYPE 1 INDEX
SQLCODE -639,
Error: A NULLABLE COLUMN OF A FOREIGN KEY WITH A DELETE RULE OF SET NULL CANNOT
BE A COLUMN
OF THE KEY OF A PARTITIONED INDEX
SQLCODE -638,
Error: TABLE CANNOT BE CREATED BECAUSE COLUMN DEFINITION IS MISSING
SQLCODE -637,
Error: DUPLICATE KEYWORD
SQLCODE -636, Error: THE PARTITIONING KEYS FOR
PARTITION ARE NOT SPECIFIED
IN
ASCENDING OR DESCENDING ORDER
SQLCODE -635,
Error: THE DELETE RULES CANNOT BE DIFFERENT OR CANNOT BE SET NULL
SQLCODE -634,
Error: THE DELETE RULE MUST NOT BE CASCADE
SQLCODE -633,
Error: THE DELETE RULE MUST BE
SQLCODE -632,
Error: THE TABLE CANNOT BE DEFINED AS A DEPENDENT OF BECAUSE OF DELETE
RULE RESTRICTIONS
SQLCODE -631,
Error: FOREIGN KEY IS TOO LONG OR HAS TOO MANY COLUMNS
SQLCODE -630,
Error: THE WHERE NOT NULL SPECIFICATION IS INVALID FOR TYPE 1 INDEXES
SQLCODE -629,
Error: SET NULL CANNOT BE SPECIFIED BECAUSE FOREIGN KEY CANNOT CONTAIN
NULL VALUES
SQLCODE -628,
Error: THE CLAUSES ARE MUTUALLY EXCLUSIVE
SQLCODE -627,
Error: THE ALTER STATEMENT IS INVALID BECAUSE THE PAGESET HAS USER-MANAGED DATA
SETS
SQLCODE -626,
Error: THE ALTER STATEMENT IS NOT EXECUTABLE BECAUSE THE PAGE SET IS NOT
STOPPED
SQLCODE -625,
Error: TABLE DOES NOT HAVE AN INDEX TO ENFORCE THE UNIQUENESS OF THE
PARENT KEY
SQLCODE -624,
Error: TABLE ALREADY HAS A PRIMARY KEY
SQLCODE -623,
Error: A CLUSTERING INDEX ALREADY EXISTS ON TABLE
SQLCODE -622,
Error: FOR MIXED DATA IS INVALID BECAUSE THE MIXED DATA INSTALL OPTION IS NO
SQLCODE -621,
Error: DUPLICATE DBID WAS DETECTED AND PREVIOUSLY ASSIGNED TO
SQLCODE -620,
Error: KEYWORD IN STATEMENT IS NOT PERMITTED FOR A SPACE IN
THE DATABASE
SQLCODE -619,
Error: OPERATION DISALLOWED BECAUSE THE WORK FILE DATABASE IS NOT STOPPED
SQLCODE -618,
Error: OPERATION IS NOT ALLOWED ON SYSTEM DATABASES
SQLCODE -617,
Error: A TYPE 1 INDEX IS NOT VALID FOR TABLE
SQLCODE -616,
Error: CANNOT BE DROPPED BECAUSE IT IS REFERENCED BY
SQLCODE -615,
Error: IS NOT ALLOWED ON A PACKAGE IN USE
SQLCODE -614,
Error: THE INDEX CANNOT BE CREATED OR THE LENGTH OF THE COLUMN CANNOT BE
CHANGED BECAUSE THE
SUM OF THE INTERNAL LENGTHS OF THE IDENTIFIED COLUMNS IS GREATER THAN
THE ALLOWABLE MAXIMUM
SQLCODE -613,
Error: THE PRIMARY KEY OR A UNIQUE CONSTRAINT IS TOO LONG OR HAS TOO MANY
COLUMNS
SQLCODE -612,
Error: IS A DUPLICATE COLUMN NAME
SQLCODE -611, Error: ONLY LOCKMAX 0 CAN BE SPECIFIED
WHEN THE LOCK SIZE OF THE
TABLESPACE
IS TABLESPACE OR TABLE
SQLCODE -607,
Error: OPERATION OR OPTION IS NOT DEFINED FOR THIS OBJECT
SQLCODE -604,
Error: A DATA TYPE DEFINITION SPECIFIES AN INVALID LENGTH, PRECISION, OR SCALE
ATTRIBUTE
SQLCODE -603,
Error: A UNIQUE INDEX CANNOT BE CREATED BECAUSE THE TABLE CONTAINS ROWS WHICH
ARE DUPLICATES
WITH RESPECT TO THE VALUES OF THE IDENTIFIED COLUMNS
SQLCODE -602, Error:
TOO MANY COLUMNS SPECIFIED IN A CREATE INDEX
SQLCODE -601,
Error: THE NAME OF THE OBJECT TO BE CREATED OR THE TARGET OF A RENAME STATEMENT
IS IDENTICAL
TO THE EXISTING NAME OF THE OBJECT TYPE
SQLCODE -594,
Error: ATTEMPT TO CREATE A NULLABLE ROWID OR DISTINCT TYPE COLUMN
SQLCODE -593,
Error: NOT NULL MUST BE SPECIFIED FOR ROWID OR DISTINCT TYPE COLUMN
SQLCODE -592,
Error: NOT AUTHORIZED TO CREATE FUNCTIONS OR PROCEDURES IN WLM ENVIRONMENT
SQLCODE -590,
Error: PARAMETER NAME IS NOT UNIQUE IN THE CREATE FOR ROUTINE
SQLCODE -586,
Error: THE TOTAL LENGTH OF THE CURRENT PATH SPECIAL REGISTER CANNOT EXCEED 254
CHARACTERS
SQLCODE -585,
Error: THE SCHEMA NAME CANNOT APPEAR MORE THAN ONCE IN THE CURRENT PATH
SQLCODE -582,
Error: THE SEARCH-CONDITION IN A SEARCHED-WHEN-CLAUSE CANNOT BE A QUANTIFIED
PREDICATE, IN
PREDICATE, OR AN EXISTS PREDICATE
SQLCODE -581,
Error: THE DATA TYPES OF THE RESULT-EXPRESSIONS OF A CASE EXPRESSION ARE NOT
COMPATIBLE
SQLCODE -580,
Error: THE RESULT-EXPRESSIONS OF A CASE EXPRESSION CANNOT ALL BE NULL
SQLCODE -579,
Error: ATTEMPTED TO READ DATA WHEN THE DEFINITION OF THE FUNCTION
OR
PROCEDURE DID NOT SPECIFY THIS ACTION
SQLCODE -577,
Error: ATTEMPTED TO MODIFY DATA WHEN THE DEFINITION OF THE FUNCTION
OR
PROCEDURE DID NOT SPECIFY THIS ACTION
SQLCODE -574,
Error: THE SPECIFIED DEFAULT VALUE OR IDENTITY ATTRIBUTE VALUE CONFLICTS WITH
THE DEFINITION OF COLUMN
SQLCODE -573,
Error: TABLE DOES NOT HAVE A UNIQUE KEY WITH THE SPECIFIED COLUMN NAMES
SQLCODE -571,
Error: THE STATEMENT WOULD RESULT IN A MULTIPLE SITE UPDATE
SQLCODE -567,
Error: AUTHORIZATION ERROR USING AUTHORITY PACKAGE =
PRIVILEGE =
SQLCODE -559,
Error: ALL AUTHORIZATION FUNCTIONS HAVE BEEN DISABLED
SQLCODE -558,
Error: INVALID CLAUSE OR COMBINATION OF CLAUSES ON A GRANT OR REVOKE
SQLCODE -557,
Error: INCONSISTENT GRANT/REVOKE KEYWORD . PERMITTED KEYWORDS ARE
SQLCODE -556,
Error: CANNOT HAVE THE PRIVILEGE REVOKED BY BECAUSE THE
REVOKEE DOES NOT POSSESS THE
PRIVILEGE OR THE REVOKER DID NOT MAKE THE GRANT
SQLCODE -555,
Error: AN AUTHORIZATION ID CANNOT REVOKE A PRIVILEGE FROM ITSELF
SQLCODE -554,
Error: AN AUTHORIZATION ID CANNOT GRANT A PRIVILEGE TO ITSELF
SQLCODE -553,
Error: SPECIFIED IS NOT ONE OF THE VALID AUTHORIZATION IDS
SQLCODE -552,
Error: DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION
SQLCODE -551,
Error: DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION ON OBJECT
SQLCODE -549,
Error: THE STATEMENT IS NOT ALLOWED FOR BECAUSE THE BIND
OPTION DYNAMICRULES(RUN)
IS NOT IN EFFECT FOR
SQLCODE -548,
Error: A CHECK CONSTRAINT THAT IS DEFINED WITH IS INVALID
SQLCODE -546,
Error: THE CHECK CONSTRAINT IS INVALID
SQLCODE -545, Error: THE REQUESTED OPERATION IS NOT
ALLOWED BECAUSE A ROW DOES
NOT
SATISFY THE CHECK CONSTRAINT
SQLCODE -544,
Error: THE CHECK CONSTRAINT SPECIFIED IN THE ALTER TABLE STATEMENT CANNOT BE
ADDED BECAUSE AN
EXISTING ROW VIOLATES THE CHECK CONSTRAINT
SQLCODE -543, Error:
A ROW IN A PARENT TABLE CANNOT BE DELETED BECAUSE THE CHECK CONSTRAINT
RESTRICTS THE DELETION
SQLCODE -542, Error: CANNOT BE A COLUMN OF A
PRIMARY KEY, A UNIQUE CONSTRAINT,
OR A PARENT KEY BECAUSE IT CAN CONTAIN NULL VALUES
SQLCODE -540, Error: THE DEFINITION OF TABLE IS
INCOMPLETE BECAUSE IT LACKS
A PRIMARY INDEX OR A REQUIRED UNIQUE INDEX
SQLCODE -539,
Error: TABLE DOES NOT HAVE A PRIMARY KEY
SQLCODE -538,
Error: FOREIGN KEY DOES NOT CONFORM TO THE DESCRIPTION OF A PARENT KEY OF
TABLE
SQLCODE -537,
Error: THE PRIMARY KEY CLAUSE, A FOREIGN KEY CLAUSE, OR A UNIQUE CLAUSE
IDENTIFIES
COLUMN MORE THAN ONCE
SQLCODE -536,
Error: THE DELETE STATEMENT IS INVALID BECAUSE TABLE CAN BE AFFECTED BY
THE OPERATION
SQLCODE -534,
Error: THE PRIMARY KEY CANNOT BE UPDATED BECAUSE OF MULTIPLE-ROW UPDATE
SQLCODE -533,
Error: INVALID MULTIPLE-ROW INSERT
SQLCODE -532,
Error: THE RELATIONSHIP RESTRICTS THE DELETION OF ROW WITH RID X''
SQLCODE -531,
Error: PARENT KEY IN A PARENT ROW CANNOT BE UPDATED BECAUSE IT HAS ONE OR
MORE DEPENDENT ROWS IN RELATIONSHIP
SQLCODE -530,
Error: THE INSERT OR UPDATE VALUE OF FOREIGN KEY IS INVALID
SQLCODE -526,
Error: THE REQUESTED OPERATION OR USAGE DOES NOT APPLY TO TEMPORARY TABLE
SQLCODE -525,
Error: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT WAS IN ERROR AT
BIND TIME FOR SECTION = PACKAGE = CONSISTENCY TOKEN = X''
SQLCODE -519,
Error: THE PREPARE STATEMENT IDENTIFIES THE SELECT STATEMENT OF THE OPENED
CURSOR
SQLCODE -518,
Error: THE EXECUTE STATEMENT DOES NOT IDENTIFY A VALID PREPARED STATEMENT
SQLCODE -517,
Error: CURSOR CANNOT BE USED BECAUSE ITS STATEMENT NAME DOES NOT IDENTIFY
A
PREPARED SELECT STATEMENT
SQLCODE -516,
Error: THE DESCRIBE FOR STATIC STATEMENT DOES NOT IDENTIFY A PREPARED STATEMENT
SQLCODE -514,
Error: THE CURSOR IS NOT IN A PREPARED STATE
SQLCODE -513,
Error: THE ALIAS MUST NOT BE DEFINED ON ANOTHER LOCAL OR REMOTE ALIAS
SQLCODE -512,
Error: STATEMENT REFERENCE TO REMOTE OBJECT IS INVALID
SQLCODE -511,
Error: THE FOR UPDATE CLAUSE CANNOT BE SPECIFIED BECAUSE THE TABLE DESIGNATED
BY THE CURSOR CANNOT BE MODIFIED
SQLCODE -510,
Error: THE TABLE DESIGNATED BY THE CURSOR OF THE UPDATE OR DELETE STATEMENT
CANNOT BE MODIFIED
SQLCODE -509,
Error: THE TABLE IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT THE SAME
TABLE
DESIGNATED BY THE CURSOR
SQLCODE -508,
Error: THE CURSOR IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT POSITIONED
ON A ROW
SQLCODE -507,
Error: THE CURSOR IDENTIFIED IN THE UPDATE OR DELETE STATEMENT IS NOT OPEN
SQLCODE -504,
Error: THE CURSOR NAME IS NOT DEFINED
SQLCODE -503,
Error: A COLUMN CANNOT BE UPDATED BECAUSE IT IS NOT IDENTIFIED IN THE UPDATE
CLAUSE OF THE
SELECT STATEMENT OF THE CURSOR
SQLCODE -502,
Error: THE CURSOR IDENTIFIED IN AN OPEN STATEMENT IS ALREADY OPEN
SQLCODE -501,
Error: THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN
SQLCODE -500,
Error: THE IDENTIFIED CURSOR WAS CLOSED WHEN THE CONNECTION WAS DESTROYED
SQLCODE -499,
Error: CURSOR HAS ALREADY BEEN ASSIGNED TO THIS OR ANOTHER RESULT SET
FROM PROCEDURE
SQLCODE -497,
Error: THE MAXIMUM LIMIT OF INTERNAL IDENTIFIERS HAS BEEN EXCEEDED FOR DATABASE
SQLCODE -496,
Error: THE SQL STATEMENT CANNOT BE EXECUTED BECAUSE IT REFERENCES A RESULT SET
THAT WAS NOT
CREATED BY THE CURRENT SERVER
SQLCODE -495,
Error: ESTIMATED PROCESSOR COST OF PROCESSOR SECONDS ( SERVICE UNITS) IN
COST CATEGORY
EXCEEDS A RESOURCE LIMIT ERROR THRESHOLD OF SERVICE UNITS
SQLCODE -492,
Error: THE CREATE FUNCTION FOR HAS A PROBLEM WITH PARAMETER NUMBER
. IT MAY INVOLVE A
MISMATCH WITH A SOURCE FUNCTION
SQLCODE -491,
Error: CREATE STATEMENT FOR USER-DEFINED FUNCTION MUST HAVE A RETURNS
CLAUSE, AND EITHER THE
EXTERNAL CLAUSE (WITH OTHER REQUIRED KEYWORDS) OR THE SOURCE CLAUSE
SQLCODE -490,
Error: NUMBER DIRECTLY SPECIFIED IN AN SQL STATEMENT IS OUTSIDE THE RANGE
OF ALLOWABLE
VALUES IN THIS CONTEXT (, )
SQLCODE -487,
Error: ATTEMPTED TO EXECUTE AN SQL STATEMENT WHEN THE DEFINITION OF
THE FUNCTION OR
PROCEDURE DID NOT SPECIFY THIS ACTION
SQLCODE -483,
Error: IN CREATE FUNCTION FOR STATEMENT, THE NUMBER OF PARAMETERS DOES
NOT MATCH THE NUMBER
OF PARAMETERS OF THE SOURCE FUNCTION
SQLCODE -482,
Error: THE PROCEDURE RETURNED NO LOCATORS
SQLCODE -480,
Error: THE PROCEDURE HAS NOT YET BEEN CALLED
SQLCODE -478,
Error: DROP OR REVOKE ON OBJECT TYPE CANNOT BE PROCESSED BECAUSE
OBJECT OF TYPE IS
DEPENDENT ON IT
SQLCODE -476,
Error: REFERENCE TO FUNCTION WAS NAMED WITHOUT A SIGNATURE, BUT THE
FUNCTION IS NOT UNIQUE
WITHIN ITS SCHEMA
SQLCODE -475,
Error: THE RESULT TYPE OF THE SOURCE FUNCTION CANNOT BE CAST TO THE
RETURNS TYPE OF THE
USER-DEFINED FUNCTION
SQLCODE -473,
Error: A USER DEFINED DATA TYPE CANNOT BE CALLED THE SAME NAME AS A SYSTEM
PREDEFINED TYPE
(BUILT-IN TYPE)
SQLCODE -472,
Error: CURSOR WAS LEFT OPEN BY EXTERNAL FUNCTION (SPECIFIC NAME )
SQLCODE -471,
Error: INVOCATION OF FUNCTION OR PROCEDURE FAILED DUE TO REASON
SQLCODE -470,
Error: SQL CALL STATEMENT SPECIFIED A NULL VALUE FOR INPUT PARAMETER , BUT THE
STORED
PROCEDURE DOES NOT SUPPORT NULL VALUES
SQLCODE -469,
Error: SQL CALL STATEMENT MUST SPECIFY AN OUTPUT HOST VARIABLE FOR PARAMETER
SQLCODE -463, Error: EXTERNAL FUNCTION
(SPECIFIC NAME ) HAS RETURNED AN INVALID SQLSTATE ,
WITH DIAGNOSTIC TEXT
SQLCODE -461,
Error: A VALUE WITH DATA TYPE CANNOT BE CAST TO TYPE
SQLCODE -458,
Error: IN A REFERENCE TO FUNCTION BY SIGNATURE, A MATCHING FUNCTION COULD
NOT BE FOUND
SQLCODE -457,
Error: A FUNCTION OR DISTINCT TYPE CANNOT BE CALLED SINCE IT IS RESERVED
FOR SYSTEM USE
SQLCODE -456,
Error: IN CREATE FUNCTION FOR , THE SPECIFIC NAME ALREADY EXISTS IN THE
SCHEMA
SQLCODE -455,
Error: IN CREATE FUNCTION FOR , THE SCHEMA NAME PROVIDED FOR THE SPECIFIC
NAME DOES NOT
MATCH THE SCHEMA NAME OF THE FUNCTION
SQLCODE -454,
Error: THE SIGNATURE PROVIDED IN THE CREATE FUNCTION STATEMENT FOR
MATCHES THE SIGNATURE OF
SOME OTHER FUNCTION ALREADY EXISTING IN THE SCHEMA
SQLCODE -453,
Error: THERE IS A PROBLEM WITH THE RETURNS CLAUSE IN THE CREATE FUNCTION
STATEMENT FOR
SQLCODE -451,
Error: THE DEFINITION, IN THE CREATE FUNCTION FOR CONTAINS DATA
TYPE WHICH IS NOT
APPROPRIATE FOR AN EXTERNAL FUNCTION WRITTEN IN THE GIVEN LANGUAGE
SQLCODE -450,
Error: USER-DEFINED FUNCTION OR STORED PROCEDURE , PARAMETER NUMBER , OVERLAYED
STORAGE
BEYOND ITS DECLARED LENGTH
SQLCODE -449,
Error: CREATE OR ALTER STATEMENT FOR FUNCTION OR PROCEDURE CONTAINS AN
INVALID FORMAT OF THE
EXTERNAL NAME CLAUSE OR IS MISSING THE EXTERNAL NAME CLAUSE
SQLCODE -444,
Error: USER PROGRAM COULD NOT BE FOUND
SQLCODE -443, Error: EXTERNAL FUNCTION
(SPECIFIC NAME ) HAS RETURNED AN ERROR
SQLSTATE WITH DIAGNOSTIC TEXT
SQLCODE -441,
Error: INVALID USE OF 'DISTINCT' OR 'ALL' WITH SCALAR FUNCTION
SQLCODE -440,
Error: NO BY THE NAME HAVING COMPATIBLE ARGUMENTS WAS FOUND IN THE
CURRENT PATH
SQLCODE -438,
Error: APPLICATION RAISED ERROR WITH DIAGNOSTIC TEXT:
SQLCODE -435,
Error: AN INVALID SQLSTATE IS SPECIFIED IN THE FUNCTION RAISE_ERROR OR IN
A SIGNAL
SQLSTATE STATEMENT
SQLCODE -433,
Error: VALUE IS TOO LONG
SQLCODE -430,
ERROR: (SPECIFIC NAME ) HAS
ABNORMALLY TERMINATED
SQLCODE -427,
Error: DYNAMIC ROLLBACK NOT VALID AT AN APPLICATION SERVER WHERE UPDATES ARE
NOT ALLOWED
SQLCODE -426,
Error: DYNAMIC COMMIT NOT VALID AT AN APPLICATION SERVER WHERE UPDATES ARE NOT
ALLOWED
SQLCODE -423,
Error: INVALID VALUE FOR LOCATOR IN POSITION
SQLCODE -421,
Error: THE OPERANDS OF A UNION OR UNION ALL DO NOT HAVE THE SAME NUMBER OF
COLUMNS
SQLCODE -420,
Error: THE VALUE OF A CHARACTER STRING ARGUMENT WAS NOT ACCEPTABLE TO THE
FUNCTION
SQLCODE -419,
Error: A DECIMAL DIVIDE OPERATION IS INVALID BECAUSE THE RESULT WOULD HAVE A
NEGATIVE SCALE
SQLCODE -418,
Error: A STATEMENT STRING TO BE PREPARED CONTAINS AN INVALID USE OF PARAMETER
MARKERS
SQLCODE -417,
Error: A STATEMENT STRING TO BE PREPARED INCLUDES PARAMETER MARKERS AS THE
OPERANDS
OF THE SAME OPERATOR
SQLCODE -416,
Error: AN OPERAND OF A UNION CONTAINS A LONG STRING COLUMN
SQLCODE -415,
Error: THE CORRESPONDING COLUMNS, , OF THE OPERANDS OF A UNION OR A UNION ALL
DO NOT HAVE
COMPARABLE COLUMN DESCRIPTIONS
SQLCODE -414,
Error: A LIKE PREDICATE IS INVALID BECAUSE THE FIRST OPERAND IS NOT A STRING
SQLCODE -413,
Error: OVERFLOW OCCURRED DURING NUMERIC DATA TYPE CONVERSION
SQLCODE -412,
Error: THE SELECT CLAUSE OF A SUBQUERY SPECIFIES MULTIPLE COLUMNS
SQLCODE -411,
Error: CURRENT SQLID CANNOT BE USED IN A STATEMENT THAT REFERENCES REMOTE
OBJECTS
SQLCODE -410,
Error: THE FLOATING POINT LITERAL CONTAINS MORE THAN 30 CHARACTERS
SQLCODE -409,
Error: INVALID OPERAND OF A COUNT FUNCTION
SQLCODE -408,
Error: THE VALUE IS NOT COMPATIBLE WITH THE DATA TYPE OF ITS TARGET
SQLCODE -407, Error: AN UPDATE, INSERT, OR SET VALUE
IS NULL, BUT THE OBJECT
COLUMN CANNOT CONTAIN NULL VALUES
SQLCODE -406,
Error: A CALCULATED OR DERIVED NUMERIC VALUE IS NOT WITHIN THE RANGE OF ITS
OBJECT COLUMN
SQLCODE -405,
Error: THE NUMERIC LITERAL CANNOT BE USED AS SPECIFIED BECAUSE IT IS OUT
OF RANGE
SQLCODE -404,
Error: THE SQL STATEMENT SPECIFIES A STRING THAT IS TOO LONG
SQLCODE -402,
Error: AN ARITHMETIC FUNCTION OR OPERATOR IS APPLIED TO CHARACTER OR
DATETIME DATA
SQLCODE -401,
Error: THE OPERANDS OF AN ARITHMETIC OR COMPARISON OPERATION ARE NOT COMPARABLE
SQLCODE -400,
Error: THE CATALOG HAS THE MAXIMUM NUMBER OF USER DEFINED INDEXES
SQLCODE -399,
Error: ATTEMPTED TO INSERT AN INVALID VALUE INTO A ROWID COLUMN
SQLCODE -398,
Error: A LOCATOR WAS REQUESTED FOR HOST VARIABLE NUMBER BUT THE VARIABLE
IS NOT A LOB
SQLCODE -397,
Error: THE OPTION GENERATED IS SPECIFIED WITH A COLUMN THAT IS NOT A ROW ID OR
DISTINCT
TYPE BASED ON A ROW ID
SQLCODE -396,
Error: ATTEMPTED TO EXECUTE AN SQL STATEMENT DURING FINAL CALL PROCESSING
SQLCODE -392,
Error: SQLDA PROVIDED FOR CURSOR HAS BEEN CHANGED FROM THE PREVIOUS FETCH
SQLCODE -390,
Error: THE FUNCTION NAME , SPECIFIC NAME , IS NOT VALID IN THE CONTEXT IN WHICH
IT OCCURS
SQLCODE -373,
Error: DEFAULT CANNOT BE SPECIFIED FOR IDENTITY COLUMN
SQLCODE -372,
Error: ONLY ONE ROWID OR IDENTITY COLUMN IS ALLOWED IN A TABLE
SQLCODE -359,
Error: THE RANGE OF VALUES FOR THE IDENTITY COLUMN IS EXHAUSTED
SQLCODE -355,
Error: A LOB COLUMN IS TOO LARGE TO BE LOGGED
SQLCODE -352,
Error: AN UNSUPPORTED SQLTYPE WAS ENCOUNTERED IN POSITION OF THE
INPUT-LIST
SQLCODE -351,
Error: AN UNSUPPORTED SQLTYPE WAS ENCOUNTERED IN POSITION OF THE
SELECT-LIST
SQLCODE -350,
Error: INVALID SPECIFICATION OF A LARGE OBJECT COLUMN
SQLCODE -339,
Error: THE SQL STATEMENT CANNOT BE EXECUTED FROM AN ASCII BASED DRDA
APPLICATION REQUESTOR TO
A V2R2 DB2 SUBSYSTEM
SQLCODE -338,
Error: AN ON CLAUSE IS INVALID
SQLCODE -333,
Error: THE SUBTYPE OF A STRING VARIABLE IS NOT THE SAME AS THE SUBTYPE KNOWN AT
BIND TIME AND
THE DIFFERENCE CANNOT BE RESOLVED BY TRANSLATION
SQLCODE -332,
Error: SYSSTRINGS DOES NOT DEFINE A TRANSLATION FROM CCSID TO
SQLCODE -331,
Error: A STRING CANNOT BE ASSIGNED TO A HOST VARIABLE BECAUSE IT CANNOT BE
TRANSLATED.
REASON , CHARACTER , POSITION
SQLCODE -330, Error: A STRING CANNOT BE USED BECAUSE
IT CANNOT BE TRANSLATED.
REASON , CHARACTER , HOST VARIABLE
SQLCODE -327,
Error: THE ROW CANNOT BE INSERTED BECAUSE IT IS OUTSIDE THE BOUND OF THE
PARTITION RANGE FOR
THE LAST PARTITION
SQLCODE -314,
Error: THE STATEMENT CONTAINS AN AMBIGUOUS HOST VARIABLE REFERENCE
SQLCODE -313,
Error: THE NUMBER OF HOST VARIABLES SPECIFIED IS NOT EQUAL TO THE NUMBER OF
PARAMETER MARKERS
SQLCODE -312,
Error: IS AN UNDEFINED OR UNUSABLE HOST VARIABLE OR IS USED IN A DYNAMIC
SQL STATEMENT OR A
TRIGGER DEFINITION
SQLCODE -311,
Error: THE LENGTH OF INPUT HOST VARIABLE NUMBER IS NEGATIVE OR GREATER
THAN THE MAXIMUM
SQLCODE -310,
Error: DECIMAL HOST VARIABLE OR PARAMETER CONTAINS NON-DECIMAL DATA
SQLCODE -309,
Error: A PREDICATE IS INVALID BECAUSE A REFERENCED HOST VARIABLE HAS THE NULL
VALUE
SQLCODE -305,
Error: THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER
BECAUSE NO INDICATOR
VARIABLE IS SPECIFIED
SQLCODE -304,
Error: A VALUE WITH DATA TYPE CANNOT BE ASSIGNED TO A HOST VARIABLE
BECAUSE THE VALUE IS NOT
WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION WITH DATA TYPE
SQLCODE -303,
Error: A VALUE CANNOT BE ASSIGNED TO OUTPUT HOST VARIABLE NUMBER BECAUSE
THE DATA TYPES ARE
NOT COMPARABLE
SQLCODE -302,
Error: THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER IS INVALID OR TOO
LARGE FOR THE
TARGET COLUMN OR THE TARGET VALUE
SQLCODE -301,
Error: THE VALUE OF INPUT HOST VARIABLE OR PARAMETER NUMBER CANNOT BE
USED AS SPECIFIED
BECAUSE OF ITS DATA TYPE
SQLCODE -300,
Error: THE STRING CONTAINED IN HOST VARIABLE OR PARAMETER IS NOT
NUL-TERMINATED
SQLCODE -251,
Error: TOKEN IS NOT VALID
SQLCODE -250,
Error: THE LOCAL LOCATION NAME IS NOT DEFINED WHEN PROCESSING A THREE-PART
OBJECT NAME
SQLCODE -240,
Error: THE PART CLAUSE OF A LOCK TABLE STATEMENT IS INVALID
SQLCODE -229, Error: THE LOCALE SPECIFIED IN A
SET LOCALE OR OTHER STATEMENT
THAT IS LOCALE SENSITIVE WAS NOT FOUND
SQLCODE -221, Error: "SET OF OPTIONAL
COLUMNS" IN EXPLANATION TABLE IS INCOMPLETE.
OPTIONAL COLUMN IS MISSING
SQLCODE -220,
Error: THE COLUMN IN EXPLANATION TABLE IS NOT DEFINED PROPERLY
SQLCODE -219, Error:
THE REQUIRED EXPLANATION TABLE DOES NOT EXIST
SQLCODE -214,
Error: AN EXPRESSION STARTING WITH IN THE CLAUSE IS NOT
VALID. REASON CODE =
SQLCODE -212,
Error: IS SPECIFIED MORE THAN ONCE IN THE REFERENCING CLAUSE OF A TRIGGER
DEFINITION
SQLCODE -208,
Error: THE ORDER BY CLAUSE IS INVALID BECAUSE COLUMN IS NOT PART OF THE
RESULT TABLE
SQLCODE -206,
Error: IS NOT A COLUMN OF AN INSERTED TABLE, UPDATED TABLE, OR ANY TABLE
IDENTIFIED IN A
FROM CLAUSE, OR IS NOT A COLUMN OF THE TRIGGERING TABLE OF A TRIGGER
SQLCODE -205,
Error: IS NOT A COLUMN OF TABLE
SQLCODE -204,
Error: IS AN UNDEFINED NAME
SQLCODE -203,
Error: A REFERENCE TO COLUMN IS AMBIGUOUS
SQLCODE -199,
Error: ILLEGAL USE OF KEYWORD , TOKEN WAS EXPECTED
SQLCODE -198,
Error: THE OPERAND OF THE PREPARE OR EXECUTE IMMEDIATE STATEMENT IS BLANK OR
EMPTY
SQLCODE -197,
Error: QUALIFIED COLUMN NAMES IN ORDER BY CLAUSE NOT PERMITTED WHEN UNION OR
UNION ALL
SPECIFIED
SQLCODE -191,
Error: A STRING CANNOT BE USED BECAUSE IT IS INVALID MIXED DATA
SQLCODE -190,
Error: ATTRIBUTES OF COLUMN IN TABLE ARE NOT COMPATIBLE WITH THE
EXISTING COLUMN
SQLCODE -189,
Error: CCSID IS UNKNOWN OR INVALID FOR THE DATA TYPE OR SUBTYPE
SQLCODE -188,
Error: THE STRING REPRESENTATION OF A NAME IS INVALID
SQLCODE -187,
Error: A REFERENCE TO A CURRENT DATE/TIME SPECIAL REGISTER IS INVALID BECAUSE
THE MVS TOD
CLOCK IS BAD OR THE MVS PARMTZ IS OUT OF RANGE
SQLCODE -186,
Error: THE LOCAL DATE LENGTH OR LOCAL TIME LENGTH HAS BEEN INCREASED AND
EXECUTING PROGRAM
RELIES ON THE OLD LENGTH
SQLCODE -185, Error: THE LOCAL FORMAT OPTION HAS BEEN
USED WITH A DATE OR TIME
AND NO LOCAL EXIT HAS BEEN INSTALLED
SQLCODE -184,
Error: AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE CONTAINS A PARAMETER
MARKER
SQLCODE -183,
Error: AN ARITHMETIC OPERATION ON A DATE OR TIMESTAMP HAS A RESULT THAT IS NOT
WITHIN THE
VALID RANGE OF DATES
SQLCODE -182,
Error: AN ARITHMETIC EXPRESSION WITH A DATETIME VALUE IS INVALID
SQLCODE -181,
Error: THE STRING REPRESENTATION OF A DATETIME VALUE IS NOT A VALID DATETIME
VALUE
SQLCODE -180,
Error: THE DATE, TIME, OR TIMESTAMP VALUE IS INVALID
SQLCODE -173,
Error: UR IS SPECIFIED ON THE WITH CLAUSE BUT THE CURSOR IS NOT READ-ONLY
SQLCODE -171,
Error: THE DATA TYPE, LENGTH, OR VALUE OF ARGUMENT OF IS INVALID
SQLCODE -170,
Error: THE NUMBER OF ARGUMENTS SPECIFIED FOR IS INVALID
SQLCODE -164,
Error: DOES NOT HAVE THE PRIVILEGE TO CREATE A VIEW WITH QUALIFICATION
SQLCODE -161, Error: THE INSERT OR UPDATE IS NOT
ALLOWED BECAUSE A RESULTING
ROW
DOES NOT SATISFY THE VIEW DEFINITION
SQLCODE -160,
Error: THE WITH CHECK OPTION CANNOT BE USED FOR THE SPECIFIED VIEW
SQLCODE -159,
Error: DROP OR COMMENT ON IDENTIFIES A(N) RATHER THAN A(N)
SQLCODE -158, Error: THE NUMBER OF COLUMNS SPECIFIED
FOR THE VIEW 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
SQLCODE -157, Error: ONLY A TABLE NAME CAN BE
SPECIFIED IN A FOREIGN KEY CLAUSE.
IS NOT THE NAME OF A TABLE
SQLCODE -156,
Error: THE STATEMENT DOES NOT IDENTIFY A TABLE
SQLCODE -154,
Error: THE STATEMENT IS INVALID BECAUSE THE VIEW OR TABLE DEFINITION IS NOT
VALID
SQLCODE -153,
Error: THE STATEMENT IS INVALID BECAUSE THE VIEW OR TABLE DEFINITION DOES NOT
INCLUDE A
UNIQUE NAME FOR EACH COLUMN
SQLCODE -152,
Error: THE DROP CLAUSE IN THE ALTER STATEMENT IS INVALID BECAUSE IS
A
SQLCODE -151,
Error: THE UPDATE STATEMENT IS INVALID BECAUSE THE CATALOG DESCRIPTION OF
COLUMN INDICATES
THAT IT CANNOT BE UPDATED
SQLCODE -150,
Error: THE OBJECT OF THE INSERT, DELETE, OR UPDATE STATEMENT IS A VIEW OR
TRANSITION TABLE
FOR WHICH THE REQUESTED OPERATION IS NOT PERMITTED
SQLCODE -148,
Error: THE SOURCE TABLE CANNOT BE RENAMED OR ALTERED
SQLCODE -147,
Error: ALTER FUNCTION FAILED BECAUSE SOURCE FUNCTIONS CANNOT BE ALTERED
SQLCODE -144,
Error: INVALID SECTION NUMBER
SQLCODE -142,
Error: THE SQL STATEMENT IS NOT SUPPORTED
SQLCODE -138,
Error: THE SECOND OR THIRD ARGUMENT OF THE SUBSTR FUNCTION IS OUT OF RANGE
SQLCODE -137,
Error: THE LENGTH RESULTING FROM IS GREATER THAN
SQLCODE -136,
Error: SORT CANNOT BE EXECUTED BECAUSE THE SORT KEY LENGTH IS GREATER THAN 4000
BYTES
SQLCODE -134, Error: IMPROPER USE OF LONG STRING
COLUMN OR AN EXPRESSION OF
MAXIMUM LENGTH GREATER THAN 255
SQLCODE -133,
Error: A COLUMN FUNCTION IN A SUBQUERY OF 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
SQLCODE -132,
Error: AN OPERAND OF x IS NOT VALID
SQLCODE -131,
Error: STATEMENT WITH LIKE PREDICATE HAS INCOMPATIBLE DATA TYPES
SQLCODE -130,
Error: THE ESCAPE CLAUSE CONSISTS OF MORE THAN ONE CHARACTER, OR THE STRING
PATTERN CONTAINS
AN INVALID OCCURRENCE OF THE ESCAPE CHARACTER
SQLCODE -129,
Error: THE STATEMENT CONTAINS TOO MANY TABLE NAMES
SQLCODE -128,
Error: INVALID USE OF NULL IN A PREDICATE
SQLCODE -127,
Error: DISTINCT IS SPECIFIED MORE THAN ONCE IN A SUBSELECT
SQLCODE -126,
Error: THE SELECT STATEMENT CONTAINS BOTH AN UPDATE CLAUSE AND AN ORDER BY
CLAUSE
SQLCODE -125,
Error: AN INTEGER IN THE ORDER BY CLAUSE DOES NOT IDENTIFY A COLUMN OF THE
RESULT
SQLCODE -123,
Error: THE PARAMETER IN POSITION IN THE FUNCTION MUST BE A CONSTANT
OR KEYWORD
SQLCODE -122, Error: A SELECT STATEMENT WITH NO GROUP
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
SQLCODE -121,
Error: THE COLUMN IS IDENTIFIED MORE THAN ONCE IN THE INSERT OR UPDATE OR
SET TRANSITION
VARIABLE STATEMENT
SQLCODE -120,
Error: A WHERE CLAUSE, SET CLAUSE, VALUES CLAUSE, OR A SET ASSIGNMENT STATEMENT
INCLUDES A
COLUMN FUNCTION
SQLCODE -119,
Error: A COLUMN IDENTIFIED IN A HAVING CLAUSE IS NOT INCLUDED IN THE GROUP BY
CLAUSE
SQLCODE -118, Error: THE OBJECT TABLE OR VIEW OF THE
DELETE OR UPDATE STATEMENT
IS ALSO IDENTIFIED IN A FROM CLAUSE
SQLCODE -117,
Error: THE NUMBER OF ASSIGNED VALUES IS NOT THE SAME AS THE NUMBER OF SPECIFIED
OR IMPLIED
COLUMNS
SQLCODE -115,
Error: A PREDICATE IS INVALID BECAUSE THE COMPARISON OPERATOR IS FOLLOWED
BY A PARENTHESIZED
LIST OR BY ANY OR ALL WITHOUT A SUBQUERY
SQLCODE -114,
Error: THE LOCATION NAME DOES NOT MATCH THE CURRENT SERVER
SQLCODE -113,
Error: INVALID CHARACTER FOUND IN: . REASON CODE
SQLCODE -112,
Error: THE OPERAND OF A COLUMN FUNCTION IS ANOTHER COLUMN FUNCTION
SQLCODE -111,
Error: A COLUMN FUNCTION DOES NOT INCLUDE A COLUMN NAME
SQLCODE -110,
Error: INVALID HEXADECIMAL LITERAL BEGINNING
SQLCODE -109,
Error: CLAUSE IS NOT PERMITTED
SQLCODE -108,
Error: THE NAME IS QUALIFIED INCORRECTLY
SQLCODE -107,
Error: THE NAME IS TOO LONG. MAXIMUM ALLOWABLE SIZE IS
SQLCODE -105,
Error: INVALID STRING
SQLCODE -104,
Error: ILLEGAL SYMBOL "". SOME SYMBOLS THAT MIGHT BE LEGAL ARE:
SQLCODE -103,
Error: IS AN INVALID NUMERIC LITERAL
SQLCODE -102,
Error: LITERAL STRING IS TOO LONG. STRING BEGINS
SQLCODE -101,
Error: THE STATEMENT IS TOO LONG OR TOO COMPLEX
SQLCODE -097,
Error: THE USE OF LONG VARCHAR OR LONG VARGRAPHIC IS NOT ALLOWED IN THIS
CONTEXT
SQLCODE -084,
Error: UNACCEPTABLE SQL STATEMENT
SQLCODE -079,
Error: QUALIFIER FOR DECLARED GLOBAL TEMPORARY TABLE OR INDEX MUST
BE SESSION, NOT
SQLCODE -060,
Error: INVALID SPECIFICATION :
SQLCODE -029,
Error: INTO CLAUSE REQUIRED
SQLCODE -010,
Error: THE STRING CONSTANT BEGINNING IS NOT TERMINATED
SQLCODE -007,
Error: STATEMENT CONTAINS THE ILLEGAL CHARACTER
SQLCODE
000,SUCCESSFUL EXECUTION
SQLCODE 012,
Warning: THE UNQUALIFIED COLUMN NAME WAS INTERPRETED AS A CORRELATED
REFERENCE
SQLCODE 098,
Warning: A DYNAMIC SQL STATEMENT ENDS WITH A SEMICOLON
SQLCODE 100, NOT FOUND:ROW NOT FOUND FOR FETCH,
UPDATE, OR DELETE, OR THE RESULT
OF A
QUERY IS AN EMPTY TABLE
SQLCODE 110,
Warning: SQL UPDATE TO A DATA CAPTURE TABLE NOT SIGNALED TO ORIGINATING SUBSYSTEM
SQLCODE 111,
Warning: THE SUBPAGES OPTION IS NOT SUPPORTED FOR TYPE 2 INDEXES
SQLCODE 117,
Warning: THE NUMBER OF INSERT VALUES IS NOT THE SAME AS THE NUMBER OF OBJECT
COLUMNS
SQLCODE 162,
Warning: TABLE SPACE . HAS BEEN PLACED IN CHECK PENDING
SQLCODE 203,
Warning: THE QUALIFIED COLUMN NAME WAS RESOLVED USING A NON-UNIQUE OR
UNEXPOSED NAME
SQLCODE 204,
Warning: IS AN UNDEFINED NAME
SQLCODE 206, Warning: IS NOT A COLUMN OF AN
INSERTED TABLE, UPDATED TABLE,
OR ANY TABLE IDENTIFIED IN A FROM CLAUSE
SQLCODE 218,
Warning: THE SQL STATEMENT REFERENCING A REMOTE OBJECT CANNOT BE EXPLAINED
SQLCODE 219,
Warning: THE REQUIRED EXPLANATION TABLE DOES NOT EXIST
SQLCODE 220,
Warning: THE COLUMN IN EXPLANATION TABLE IS NOT DEFINED PROPERLY
SQLCODE 236,
Warning: SQLDA INCLUDES SQLVAR ENTRIES, BUT ARE REQUIRED FOR
COLUMNS
SQLCODE 237,
Warning: SQLDA INCLUDES SQLVAR ENTRIES, BUT ARE REQUIRED BECAUSE AT
LEAST ONE OF THE COLUMNS
BEING DESCRIBED IS A DISTINCT TYPE
SQLCODE 238,
Warning: SQLDA INCLUDES SQLVAR ENTRIES, BUT SQLVAR ENTRIES ARE
NEEDED FOR COLUMNS BECAUSE
AT LEAST ONE OF THE COLUMNS BEING DESCRIBED IS A LOB
SQLCODE 239,
Warning: SQLDA INCLUDES SQLVAR ENTRIES, BUT ARE REQUIRED FOR
COLUMNS BECAUSE AT LEAST ONE
OF THE COLUMNS BEING DESCRIBED IS A DISTINCT TYPE
SQLCODE 304,
Warning: A VALUE WITH DATA TYPE CANNOT BE ASSIGNED TO A HOST VARIABLE
BECAUSE THE VALUE IS
NOT WITHIN THE RANGE OF THE HOST VARIABLE IN POSITION WITH DATA
TYPE
SQLCODE 331,
Warning: THE NULL VALUE HAS BEEN ASSIGNED TO A HOST VARIABLE BECAUSE THE STRING
CANNOT BE
TRANSLATED. REASON , CHARACTER , HOST VARIABLE
SQLCODE 339,
Warning: THE SQL STATEMENT HAS BEEN SUCCESSFULLY EXECUTED BUT THERE MAY BE SOME
CHARACTER
CONVERSION INCONSISTENCIES
SQLCODE 394,
Warning: USER SPECIFIED OPTIMIZATION HINTS USED DURING ACCESS PATH SELECTION
SQLCODE 395,
Warning: USER SPECIFIED OPTIMIZATION HINTS ARE INVALID (REASON CODE =
'').
THE OPTIMIZATION HINTS ARE IGNORED
SQLCODE 402,
Warning: LOCATION IS UNKNOWN
SQLCODE 403,
Warning: THE LOCAL OBJECT REFERENCED BY THE CREATE ALIAS STATEMENT DOES NOT
EXIST
SQLCODE 434,
Warning: OPTION IS A DEPRECATED FEATURE
SQLCODE 445,
Warning: VALUE HAS BEEN TRUNCATED
SQLCODE 462,
Warning: EXTERNAL FUNCTION OR PROCEDURE (SPECIFIC NAME ) HAS RETURNED A
WARNING SQLSTATE,
WITH DIAGNOSTIC TEXT
SQLCODE 464,
Warning: PROCEDURE RETURNED QUERY RESULT SETS, WHICH EXCEEDS THE
DEFINED LIMIT
SQLCODE 466,
Warning: PROCEDURE RETURNED QUERY RESULT SETS
SQLCODE 494,
Warning: NUMBER OF RESULT SETS IS GREATER THAN NUMBER OF LOCATORS
SQLCODE 495,
Warning: ESTIMATED PROCESSOR COST OF PROCESSOR SECONDS ( SERVICE UNITS)
IN COST CATEGORY
EXCEEDS A RESOURCE LIMIT WARNING THRESHOLD OF SERVICE UNITS
SQLCODE 535,
Warning: THE RESULT OF THE POSITIONED UPDATE OR DELETE MAY DEPEND ON THE ORDER
OF THE ROWS
SQLCODE 541,
Warning: THE REFERENTIAL OR UNIQUE CONSTRAINT HAS BEEN IGNORED BECAUSE IT
IS A DUPLICATE
SQLCODE 551,
Warning: DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION ON OBJECT
SQLCODE 552,
Warning: DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION
SQLCODE 558,
Warning: THE WITH GRANT OPTION IS IGNORED
SQLCODE 561,
Warning: THE ALTER, INDEX, REFERENCES, AND TRIGGER PRIVILEGES CANNOT BE GRANTED
TO
PUBLIC AT ALL LOCATIONS
SQLCODE 562,
Warning: A GRANT OF A PRIVILEGE WAS IGNORED BECAUSE THE GRANTEE ALREADY
HAS THE PRIVILEGE FROM THE GRANTOR
SQLCODE 585,
Warning: THE SCHEMA NAME APPEARS MORE THAN ONCE IN THE CURRENT PATH
SQLCODE 599, Warning: COMPARISON FUNCTIONS ARE NOT
CREATED FOR A DISTINCT TYPE BASED
ON A LONG STRING DATA
TYPE
SQLCODE 610,
Warning: A CREATE/ALTER ON OBJECT HAS PLACED OBJECT IN PENDING
SQLCODE 625, Warning:
THE DEFINITION OF TABLE HAS BEEN CHANGED TO INCOMPLETE
SQLCODE 626,
Warning: DROPPING THE INDEX TERMINATES ENFORCEMENT OF THE UNIQUENESS OF A KEY
THAT WAS DEFINED
WHEN THE TABLE WAS CREATED
SQLCODE 645,
Warning: WHERE NOT NULL IS IGNORED BECAUSE THE INDEX KEY CANNOT CONTAIN NULL
VALUES
SQLCODE 650,
Warning: THE TABLE BEING CREATED OR ALTERED CAN NOT BECOME A DEPENDENT TABLE
SQLCODE 653,
Warning: TABLE IN PARTITIONED TABLE SPACE IS NOT AVAILABLE BECAUSE
ITS PARTITIONED INDEX HAS
NOT BEEN CREATED
SQLCODE 655,
Warning: STOGROUP HAS BOTH SPECIFIC AND NON-SPECIFIC VOLUME IDS. IT
WILL NOT BE ALLOWED IN
FUTURE RELEASES.
SQLCODE 658,
Warning: THE SUBPAGES VALUE IS IGNORED FOR THE CATALOG INDEX
SQLCODE 664,
Warning: THE INTERNAL LENGTH OF THE LIMIT-KEY FIELDS FOR THE PARTITIONED
INDEX EXCEEDS THE
LENGTH IMPOSED BY THE INDEX MANAGER
SQLCODE 738,
Warning: DEFINITION CHANGE OF MAY REQUIRE SIMILAR CHANGE ON
READ-ONLY SYSTEMS
SQLCODE 799,
Warning: A SET STATEMENT REFERENCES A SPECIAL REGISTER THAT DOES NOT EXIST AT
THE SERVER SITE
SQLCODE 802,
Warning: EXCEPTION ERROR HAS OCCURRED DURING OPERATION ON
DATA, POSITION
SQLCODE 806, Warning: BIND ISOLATION LEVEL RR
CONFLICTS WITH TABLESPACE LOCKSIZE
PAGE OR LOCKSIZE ROW
AND LOCKMAX 0
SQLCODE 807,
Warning: THE RESULT OF DECIMAL MULTIPLICATION MAY CAUSE OVERFLOW
SQLCODE 863,
Warning: THE CONNECTION WAS SUCCESSFUL BUT ONLY SBCS WILL BE SUPPORTED
SQLCODE 883,
Warning: ROLLBACK TO SAVEPOINT OCCURRED WHEN THERE WERE OPERATIONS THAT CANNOT
BE UNDONE OR AN
OPERATION THAT CANNOT BE UNDONE OCCURRED WHEN THERE WAS A SAVEPOINT
OUTSTANDING
File Status Codes:
If the FILE STATUS clause is specified in the FILE-CONTROL entry,
a value is placed in the specified status key (the 2-character data item named
in the FILE STATUS clause) during execution of any request on that file; the
value indicates the status of that request.
The value is placed in the status key before execution of any
EXCEPTION/ERROR declarative or INVALID KEY/AT END phrase associated with the
request.
There are two status key data-names. One is described by
data-name-1 in the FILE STATUS clause of the FILE-CONTROL entry.
This is a two character data item with the first character known
as status key 1 and the second character known as status key 2.
Status key values and
meanings
|
|||
High-
order digit |
Meaning
|
Low-
order digit |
Meaning
|
0
 X X X |
Successful
completion X X X |
0
|
No further information
|
2
|
This file status value only applies to
indexed files with alternate keys that allow duplicates. The input-output statement was successfully executed, but a duplicate key was detected. For a READ statement the key value for the current key of reference was equal to the value of the same key in the next record within the current key of reference. For a REWRITE or WRITE statement, the record just written created a duplicate key value for at least one alternate record key for which duplicates are allowed. |
||
4
|
A READ statement was successfully
executed, but the length of the record being processed did not conform to the fixed file attributes for that file. |
||
5
X X X |
An OPEN statement is successfully executed
but the referenced optional file is not present at the time the OPEN statement is executed. The file has been created if X the open mode is I-O or EXTEND. This does X not apply to OS/390 and VM VSAM sequential X files. |
||
7
|
For a CLOSE statement with the NO
REWIND,
REEL/UNIT, or FOR REMOVAL phrase or for an OPEN statement with the NO REWIND phrase, the referenced file was on a non-reel/unit medium. |
||
1
|
At end
condition |
0
|
A sequential READ statement was
attempted
and no next logical record existed in the file because the end of the file had been reached, or the first READ was attempted on an optional input file that was not present. |
4
|
A sequential READ statement was
attempted
for a relative file and the number of significant digits in the relative record number was larger than the size of the relative key data item described for the file. |
||
2
|
Invalid key
condition |
1
|
A sequence error exists for a sequentially
accessed indexed file. The prime record key value has been changed by the program between the successful execution of a READ statement and the execution of the next REWRITE statement for that file, or the ascending requirements for successive record key values were violated. |
2
|
An attempt was made to write a record that
would create a duplicate key in a relative file; or an attempt was made to write or rewrite a record that would create a duplicate prime record key or a duplicate alternate record key without the DUPLICATES phrase in an indexed file. |
||
3
|
An attempt was made to randomly access
a
record that does not exist in the file, or a START or random READ statement was attempted on an optional input file that was not present. |
||
4
|
An attempt was made to write beyond the
externally defined boundaries of a relative or indexed file. Or, a sequential WRITE statement was attempted for a relative file and the number of significant digits in the relative record number was larger than the size of the relative key data item described for the file. |
||
3
X X X |
Permanent
error condition X X X |
0
|
No further information
|
4
|
A permanent error exists because of a
boundary violation; an attempt was made to write beyond the externally-defined boundaries of a sequential file. |
||
5
|
An OPEN statement with the INPUT, I-O,
or
EXTEND phrase was attempted on a non-optional file that was not present. |
||
7
|
An OPEN statement was attempted on a
file
that would not support the open mode specified in the OPEN statement. Possible violations are: 1. The EXTEND or OUTPUT phrase was specified but the file would not support write operations. 2. The I-O phrase was specified but the file would not support the input and output operations permitted. 3. The INPUT phrase was specified but the file would not support read operations. |
||
8
|
An OPEN statement was attempted on a
file
previously closed with lock. |
||
9
X X X |
The OPEN statement was unsuccessful
because a conflict was detected between the fixed file attributes and the attributes specified for that file in the program. These attributes include the organization of the file (sequential, relative, or indexed), the prime record key, the alternate record keys, the code set, the maximum record size, the record type (fixed or variable), and the blocking factor. X Under AIX and Windows, file status 39
is X not supported for line-sequential files or X Btrieve files. |
||
4
|
Logic error
condition |
1
|
An OPEN statement was attempted for a file
in the open mode. |
2
|
A CLOSE statement was attempted for a file
not in the open mode. |
||
3
|
For a mass storage file in the
sequential
access mode, the last input-output statement executed for the associated file prior to the execution of a REWRITE statement was not a successfully executed READ statement. For relative and indexed files in the sequential access mode, the last input-output statement executed for the file prior to the execution of a DELETE or REWRITE statement was not a successfully executed READ statement. |
||
4
|
A boundary violation exists because an
attempt was made to rewrite a record to a file and the record was not the same size as the record being replaced, or an attempt was made to write or rewrite a record that was larger than the largest or smaller than the smallest record allowed by the RECORD IS VARYING clause of the associated file-name. |
||
6
|
A sequential READ statement was
attempted
on a file open in the input or I-O mode and no valid next record had been established because: 1. The preceding READ statement was unsuccessful but did not cause an at end condition 2. The preceding READ statement caused an at end condition. |
||
7
|
The execution of a READ statement was
attempted on a file not open in the input or I-O mode. |
||
8
|
The execution of a WRITE statement was
attempted on a file not open in the I-O, output, or extend mode. |
||
9
|
The execution of a DELETE or REWRITE
statement was attempted on a file not open in the I-O mode. |
||
| 9
|
Implementor-
defined condition |
0
|
Under AIX and Windows: No further information. For VSAM only under OS/390 and VM: See the information on VSAM return codes in the IBM COBOL for OS/390
& VM Programming
Guide. |
1
|
For VSAM only under OS/390 and VM:
Password failure. Under AIX and Windows: Authorization failure. |
||
2
|
Logic error.
|
||
3
|
For all files, except QSAM: Resource
not
available. |
||
4
|
For VSAM under OS/390 and VM with CMPR2
compiler-option only: No file position indicator for sequential request. Under AIX and Windows: Concurrent open error. |
||
5
|
For all files, except QSAM: Invalid or
incomplete file information. |
||
| 6 |
For VSAM file under OS/390 and VM: An
OPEN statement with the OUTPUT phrase
was attempted, or an OPEN statement with
the I-O or EXTEND phrase was attempted for
an optional file, but no DD statement was specified for the file. For QSAM file under OS/390 and VM: An OPEN statement with the OUTPUT phrase was attempted, or an OPEN statement with the I-O or EXTEND phrase was attempted for an optional file, but no DD statement was specified for the file and the CBLQDA(OFF) run-time option was specified. Under AIX and Windows: File system not available. |
||
7
|
For VSAM only under OS/390 and VM: OPEN
statement execution successful: File integrity verified. Under AIX and Windows: Errors related to remote file access. |
||
8
|
Under AIX and Windows: Open failed due to
locked file. Under OS/390: Open failed due to either the invalid contents of an environment variable specified in a SELECT ...
ASSIGN clause, or failed dynamic allocation. For more information about the conditions under which this status can occur |
||
9
|
Under AIX and Windows: Record access
failed due to locked record. |
||
No comments :
Post a Comment