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
 

 

ALternate Index giving fle status 35

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

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Thu Jul 03, 2008 4:19 pm    Post subject: ALternate Index giving fle status 35
Reply with quote

Hi All,
I am trying to use alternate index but while executing the program
it is giving fle status 35..
Can any one suggest me with what DD name I have to give the path file?
Back to top
View user's profile Send private message

Robert Sample

Global Moderator


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

PostPosted: Thu Jul 03, 2008 4:40 pm    Post subject:
Reply with quote

Generally, if the DD name for the base cluster is DDNAME, the alternate index will be DDNAME1.
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Thu Jul 03, 2008 7:00 pm    Post subject:
Reply with quote

Robert,
I have given the same that what you have mention but it is not working..
Still I am getting File Status 35..
Can you give me any suggestion..
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Thu Jul 03, 2008 7:10 pm    Post subject:
Reply with quote

What's the JCL and the COBOL SELECT clause look like?
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Thu Jul 03, 2008 7:38 pm    Post subject:
Reply with quote

This is the select clause that I have given:

SELECT INFILE1 ASSIGN TO INFIL
FILE STATUS IS IND-FILE-STATUS
ORGANIZATION IS INDEXED
RECORD KEY IS CUST-ID
ALTERNATE KEY IS CUST-NAME WITH DUPLICATES
ACCESS MODE IS RANDOM.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Thu Jul 03, 2008 7:48 pm    Post subject:
Reply with quote

What's the //INFIL and //INFIL1 JCL DD statements look like?
Back to top
View user's profile Send private message
murugan_mf

Active User


Joined: 31 Jan 2008
Posts: 148
Location: Chennai, India

PostPosted: Thu Jul 03, 2008 8:29 pm    Post subject:
Reply with quote

INFIL--> I have given VSAM (Input)
INFIL1-->PATH ENTRY
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Thu Jul 03, 2008 9:02 pm    Post subject:
Reply with quote

As long as INFIL points to the VSAM cluster name and INFIL1 points to the PATH name, and the alternate index was built correctly, I don't see why you'd get a 35 file status. Can you post anything more such as any messages coming out in the system log? FS 35's statement from the manual is
Quote:
An OPEN statement with the INPUT, I-O,
or EXTEND phrase was attempted on a
non-optional file that was not present.
which implies either INFIL or INFIL1 DD statements are not part of the JCL being executed, as long as the 35 refers to this file.
Back to top
View user's profile Send private message
justinibm

New User


Joined: 23 Jun 2007
Posts: 1
Location: pune

PostPosted: Fri Jul 04, 2008 8:26 pm    Post subject:
Reply with quote

murugan_mf wrote:
Robert,
I have given the same that what you have mention but it is not working..
Still I am getting File Status 35..
Can you give me any suggestion..


1.Make sure your cluster is not empty
2.Cluster is passed via jcl to the cobol program
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


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

PostPosted: Fri Jul 04, 2008 9:01 pm    Post subject:
Reply with quote

Justin: I'm assuming murugan is correct in stating the alternate index path has been built. If so, the cluster cannot be empty since building the AIX requires a record in the VSAM file.

Murugan: post as code the exact JCL being used for INFIL and INFIL1 as well as the exact error message coming out, if any. Also the JES message log message(s) for the program.
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 Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
This topic is locked: you cannot edit posts or make replies. session stuck in TPX with status ACL amitc23 CA Products 1 Tue Dec 13, 2016 12:53 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm


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