************************ SQL CODES********************************
SQLCODE -180 Bad data in Date/Time/Timestamp – String representation of DATE, TIME, TIMESTAMP is invalid
SQLCODE -181 Bad data in Date/Time/Timestamp Value for DATE, TIME, TIMESTAMP is invalid
SQLCODE -199 Illegal use of the specified keyword.
SQLCODE -305 Null indicator needed
SQLCODE -311 Varchar, insert or update.
You didn’t set the -LEN field with the right data length
SQLCODE -501 Cursor not open on FETCH
SQLCODE -502 Opening cursor that is already open
SQLCODE -551 Not authorized to access DB2
SQLCODE -803 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 Unavailable resource. Someone is locking the data you need
you may choose to terminate the program
SQLCODE -911 Deadlock or timeout. Rollback has been done.
SQLCODE -913 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
************************ COBOL ABENDS ********************************
S0C1 – May be due to
1.Missing or misspelled DD name
2.Read/Write to unopened DataSet
3.Read to DataSet opened output
4.Write to DataSet opened input
5.Called subprogram not found
S0C4 – Mmay be due to
1.Missing Select statement (during compile)
2.Bad Subscript/index
3.Protection Exception
4.Missing parameters on called subprogram
5.Read/Write to unopened file
6.Move data from/to unopened file
S0C5 – May be due to
1.Bad Subscript/index
2.Close an unopenunopened DataSet
3.Bad exit from a perform
4.Access to I/O area (FD) before read
S0C7 – Mmay be due to
1.Numeric operation
on non-numeric data
2.Un-initialize working-storage
3.Coding past the maximum allowed sub script
S0CB – May be due to
1.Division by Zero
************************ JCL ABENDS ********************************
S222 Abend
The job was cancelled because it violated some restriction.
No dump was requested.
S322 Abend
The job used more CPU time than it should have.
Either the estimate is wrong or the program is in an uncontrollable loop.
S422 Abend
Too many job steps.
S522 Abend
Job was waiting too long.
S806 Abend
Program not on the library. May need a JOBLIB or STEPLIB
SD37 is related to primary space provided for your data set,
ie if the dataset is out of primary extended volume space provided by
you as per your jcl, it shows SD37 abend
SB37 when the dataset is out of secondary extended space, or even the the 15 secondary extended volume provided to you for each primary extended space is used up.
SE37 is related to directory block, if there is no space for an extra member in the PDS. THE PDS NEED TO BE COMPRESSED.
************************ CICS ABENDS ********************************
ASRA – Any data exception error S0C7
AICA – Run away task
AEY9 – Invalid CICS command has been issued
AEYD – CICS abend code indicating a storage violation
AICA – Runaway task interval has expired
************************ VSAM ABENDS ********************************
00 – successful completion
02 – Duplicate Key
04 – Read, Wrong length record
10 – end of file
22 – duplikate key
23 – record not found or file not found
35 – Open, File not present
92 – logic error (opening an open file, reading output file, write input file, del/rew but no prior read)
96 – Missing DD statement in JCL
97 – open ok, file integrity verified
If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog
You may also like to look at:
F1 for Mainframe 
Pingback: SORT – PARSE – READ EXCEL (CSV) FILE IN MAINFRAMES | F1 for Mainframe