Tags

, , , , ,

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

Important SQL CODES and ABEND CODES
SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
REXX – INITIAL SETUP
HOW TO SUBMIT A BATCH JOB FROM THE CICS PROGRAM
CICS – EXEC interface block – EIBRESP Values
CICS – EXEC interface block Fields
Flow of control between COBOL programs, run units, and CICS
CICS INTERVIEW QUESTIONS
CICS TIPS
COBOL – COPY and INCLUDE statements
COBOL – PERFORMANCE IMPROVEMENT
COBOL – SIGN STORED IN COMP, COMP-3 AND DISPLAY FORMATS
SHORTEST COBOL PROGRAM
RESTART LOGIC IN COBOL DB2 Program
GOBACK – EXIT PROGRAM – STOP RUN
Continuation lines in COBOL
Computational items – COMP, COMP 1 , COMP 2, COMP 3
COBOL program format
cobol indicator area column-7 and area a and area b
COBOL INTERVIEW QUESTIONS
COBOL TIPS
COBOL COMPILER OPTIONS
The IDENTIFICATION DIVISION
Advertisements