CICS ABEND Codes

                                       About Us              Services               Courses              Case Studies               Mainframe Forum              Mainframe Jobs               Contact Us          Mainframe Connectivity


Frequently faced mainframes Errors / Abdends and Complete List follows

(JCL | DB2 | VSAM | CICS)

 

JCL Abend Codes

 

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

 

DB2 Return Codes

 

 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

 

VSAM File Status Codes

 

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:
 
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 
JCL ABEND CODES 
 
 
 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
 
 
 
 
 
 
 
 
 
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     


























RevisionX
RevisionX
RevisionX





 Successful   
completion

























RevisionX
RevisionX
RevisionX





 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     



RevisionX
RevisionX
RevisionX
 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
RevisionX the open mode is I-O or EXTEND. This does
RevisionX not apply to OS/390 and VM VSAM sequential
RevisionX 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     








































RevisionX
RevisionX
RevisionX
 Permanent    
error
condition






































RevisionX
RevisionX
RevisionX
 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     











RevisionX
RevisionX
RevisionX
 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.

RevisionX Under AIX and Windows, file status 39 is
RevisionX not supported for line-sequential files or
RevisionX 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.
Revision  9     























Revision














Revision


 Implementor- 
defined
condition























Revision














Revision


Revision  0     
Revision

Revision
Revision
Revision
Revision
Revision  Under AIX and Windows: No further          
Revision information.

Revision For VSAM only under OS/390 and VM: See the
Revision information on VSAM return codes in the
Revision IBM COBOL for OS/390 & VM Programming
Revision 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.
Revision 6     
Revision


Revision For VSAM file under OS/390 and VM:  An     
Revision OPEN statement with the OUTPUT phrase was
Revision attempted, or an OPEN statement with the
Revision I-O or EXTEND phrase was attempted for an
Revision optional file, but no DD statement was
Revision 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
Revision optional file, but no DD statement was
Revision specified for the file and the CBLQDA(OFF)
Revision 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.

Revision Under OS/390: Open failed due to either
Revision the invalid contents of an environment
Revision variable specified in a SELECT ... ASSIGN
Revision clause, or failed dynamic allocation. For
Revision more information about the conditions
Revision under which this status can occur
 9     
 Under AIX and Windows:  Record access      
failed due to locked record.
                                                                                                                                                                 http://www.mainframesguru.com
 
 
 
                        

Comments