Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 8165
Location: East Dubuque, Illinois, USA

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: 8165
Location: East Dubuque, Illinois, USA

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: 8165
Location: East Dubuque, Illinois, USA

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: 8165
Location: East Dubuque, Illinois, USA

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: 8165
Location: East Dubuque, Illinois, USA

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 Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm
No new posts Testing rerad cursor for status with ... John F Dutcher DB2 8 Fri May 19, 2017 9:35 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us