VSAM file failed with status code 90

Prabha · New User Joined: 05 Dec 2005 Posts: 79

Hi,

In my cobol module, our VSAM file empty. In order to handle empty VSAM file, we used OPTIONAL in SELECT statement. Since it has Alternate index file is present for this VSAM, program is still abending. Getting VSAm status code as 90. Could you please help out this.

expat · Posted: Wed Feb 16, 2011 1:49 pm

Did you initialise the file before trying to use it.

Have you searched the forum or google for the same problem.

Prabha · New User Joined: 05 Dec 2005 Posts: 79

While opening the file itself, am getting this error. I didnt initialize anything. I tried to search, but it didnt get any solution.

Error is

************** ABEND INFO **************
OPEN ERROR : CMEXT-SBRT-FILE
FILE STATUS WAS : 90
DDNAME : CMXTSBRT
*******************************************

expat · Posted: Wed Feb 16, 2011 4:01 pm

I found 48k + articles on google using "VSAM staus 90" and quite a few linked back to this very forum.

I suggest that you use google and select some that link back to this forum and see what others have done to resolve the problem.

Robert Sample · Posted: Wed Feb 16, 2011 4:07 pm

What is(are) the DD name(s) in your JCL for the alternate index(es)?

Prabha · New User Joined: 05 Dec 2005 Posts: 79

We r not using alternate index in this module. It is used in other job. In that job it is getting created.. Here using we are VSAM fie alone.

Bill O'Boyle · Posted: Wed Feb 16, 2011 9:50 pm

As Expat has said, click on this link and all will be forgiven....

ibmmainframes.com/post-68601.html

Bill

Robert Sample · Posted: Thu Feb 17, 2011 4:19 am

Use the extended file status to get the VSAM feedback, return, and reason codes -- then look them up in the manual to find out more precisely what your problem is. If you cannot figure out the problem, please post all 3 values.