Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

VSAM file failed with status code 90

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
Prabha
Warnings : 2

New User


Joined: 05 Dec 2005
Posts: 79

PostPosted: Wed Feb 16, 2011 1:35 pm    Post subject: VSAM file failed with status code 90
Reply with quote

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.
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Feb 16, 2011 1:49 pm    Post subject:
Reply with quote

Did you initialise the file before trying to use it.

Have you searched the forum or google for the same problem.
Back to top
View user's profile Send private message
Prabha
Warnings : 2

New User


Joined: 05 Dec 2005
Posts: 79

PostPosted: Wed Feb 16, 2011 3:52 pm    Post subject: Reply to: Reading Empty vsam file failed with status code 9
Reply with quote

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
*******************************************
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Wed Feb 16, 2011 4:01 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7931
Location: Bellevue, IA

PostPosted: Wed Feb 16, 2011 4:07 pm    Post subject:
Reply with quote

What is(are) the DD name(s) in your JCL for the alternate index(es)?
Back to top
View user's profile Send private message
Prabha
Warnings : 2

New User


Joined: 05 Dec 2005
Posts: 79

PostPosted: Wed Feb 16, 2011 4:19 pm    Post subject: Reply to: Reading Empty vsam file failed with status code 9
Reply with quote

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.
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Wed Feb 16, 2011 9:50 pm    Post subject: Reply to: Reading Empty vsam file failed with status code 9
Reply with quote

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

http://ibmmainframes.com/post-68601.html

Bill
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7931
Location: Bellevue, IA

PostPosted: Thu Feb 17, 2011 4:19 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 0 Thu Jan 12, 2017 12:02 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
This topic is locked: you cannot edit posts or make replies. Calling REXX code from ISPF panel sanchita dey TSO/ISPF 4 Mon Jan 02, 2017 5:13 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us