I want ALL ERROR codes in VSAM
Answers were Sorted based on User's Feedback
Answer / shinoy sansilavose
Error codes in VSAM are the VSAM file status codes.
Following are some VSAM file status codes I know,
File Status Cause
00 Operation completed successfully
02 Duplicate Key was found
04 Invalid fixed length record
05 The file was created when opened -
Successful Completion
07 CLOSE with REEL or NO REWIND executed for
non tape dataset.
10 End of File encountered
14 Attempted to READ a relative record
outside file boundary
21 Invalid Key - Sequence error
22 Invalid Key - Duplicate Key found
23 Invalid key - No record found
24 Invalid Key - key outside boundary of file.
30 Permanent I/O Error
34 Permanent I/O Error - Record outside file
boundary
35 OPEN, but file not found
37 OPEN with wrong mode
38 Tried to OPEN a LOCKed file
39 OPEN failed, conflicting file attributes
41 Tried to OPEN a file that is already open
42 Tried to CLOSE a file that is not OPEN
43 Tried to REWRITE without READing a record
first
44 Tried to REWRITE a record of a different
length
46 Tried to READ beyond End-of-file
47 Tried to READ from a file that was not
opened I-O or INPUT
48 Tried to WRITE to a file that was not
opened I-O or OUTPUT
49 Tried to DELETE or REWRITE to a file that
was not opened I-O
91 Password or authorization failed
92 Logic Error
93 Resource was not available (may be
allocated to CICS or another user)
94 Sequential record unavailable or
concurrent OPEN error
95 File Information invalid or incomplete
96 No DD statement for the file
97 OPEN successful and file integrity verified
98 File is Locked - OPEN failed
99 Record Locked - record access failed.
| Is This Answer Correct ? | 21 Yes | 4 No |
Answer / shailendra
02 is for alternate duplicate key found
22 is for primary duplicate key found
| Is This Answer Correct ? | 17 Yes | 1 No |
What is diff betn PS and ESDS file? What is the diffrent compiler options in cobol and there discription? What is retrive nth maximum salary from salary DB2 table. Can we redefine COM-3 variable with varchar variable?
In my table having 3000 Records. How can I delete the 500th row? (we don't know what is data inside the table)
How to find whether a Flat file is empty or not without Reading a file in COBOL Program. (not using JCL)
I have two questions here. 1. How to read a flat file in reverse order? 2. How to read a VSAM KSDS file in reverse order? In both the cases we donot know the total number of records.
What is cobol?
What is the difference between external and global variables in COBOL?
there is a file whose ORGANISATION is INDEXED.you want to read the records from the file in RANDOM fashion as well as sequentially.then which of the access mode would you specify? a.SEQUENTIAL b.RANDOM c.DYNAMIC D.ACCESS MODE has nothing to do with it
I have a Main Program which is calling Sub-Program which is a DB2 pgm. What will happen if I am not closing the cursor used in the Sub-program? Please advise..
wht happens if we dnt give scope terminator ?
What are the different types of condition in cobol and write their forms.
Suppose i have a variable with s9(18)v99 comp3 . what is the size of variable . If s9(18) comp3 is 10 bytes . There should be some difference between two allocations ? Thanks krishna chaitanya
Explain about level numbers?