IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

File Status "35" while opening VSAM


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
naveen_kj

New User


Joined: 18 Aug 2003
Posts: 2

PostPosted: Tue Aug 19, 2003 8:38 pm
Reply with quote

Hi,

I have a new VSAM file created. In the program the VSAM file is opening in the input mode. When the program is executed, it is giving file-status "35" for opening of VSAM file.

I created a temporary record in the VSAM file using a simple program (open in output and close). But still it gave file-status 35 for open.

I inserted a blank record and executed the program, it executed successfully.

I want know, how to initialize the vsam file in the program to avoid this file-status 35 for open in input mode?

The initialization of VSAM file can be done through a JCL, before the execution of the program?

Thanks in advance,

Naveen
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1210
Location: India

PostPosted: Wed Aug 20, 2003 8:21 am
Reply with quote

You may get file status 35 when you try to open a NON-OPTIONAL or UNAVAILABLE file in INPUT/EXTEND Mode.
Back to top
View user's profile Send private message
naveen_kj

New User


Joined: 18 Aug 2003
Posts: 2

PostPosted: Wed Aug 20, 2003 9:01 pm
Reply with quote

Millan,

Thanks for your reply.

In my program, the VSAM file has to be opened in input mode.
Is there any solution for this other than inserting a blank record before the execution of the program.

Naveen
Back to top
View user's profile Send private message
mcmillan

Site Admin


Joined: 18 May 2003
Posts: 1210
Location: India

PostPosted: Thu Aug 21, 2003 8:26 am
Reply with quote

Yes, you can use OPTIONAL phrase on Select clause.

Better to check the file status before opening the file itself to avoid status errors.

Code:
OPEN INOUT <filename>.
IF <filestatus>  = "35" OPEN OUTPUT <filename>
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 4
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
Search our Forums:

Back to Top