| IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
murugan_mf
Joined: 31 Jan 2008
Posts: 38
Location: Chennai, India
|
| Posted: Thu Jul 03, 2008 4:19 pm Post subject: ALternate Index giving fle status 35 |
|
|
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 |
|
Robert Sample
Joined: 06 Jun 2008
Posts: 943
Location: Atlanta, GA
|
| Posted: Thu Jul 03, 2008 4:40 pm Post subject: |
|
|
| Generally, if the DD name for the base cluster is DDNAME, the alternate index will be DDNAME1. |
|
| Back to top |
|
murugan_mf
Joined: 31 Jan 2008
Posts: 38
Location: Chennai, India
|
| Posted: Thu Jul 03, 2008 7:00 pm Post subject: |
|
|
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 |
|
Robert Sample
Joined: 06 Jun 2008
Posts: 943
Location: Atlanta, GA
|
| Posted: Thu Jul 03, 2008 7:10 pm Post subject: |
|
|
| What's the JCL and the COBOL SELECT clause look like? |
|
| Back to top |
|
murugan_mf
Joined: 31 Jan 2008
Posts: 38
Location: Chennai, India
|
| Posted: Thu Jul 03, 2008 7:38 pm Post subject: |
|
|
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 |
|
Robert Sample
Joined: 06 Jun 2008
Posts: 943
Location: Atlanta, GA
|
| Posted: Thu Jul 03, 2008 7:48 pm Post subject: |
|
|
| What's the //INFIL and //INFIL1 JCL DD statements look like? |
|
| Back to top |
|
murugan_mf
Joined: 31 Jan 2008
Posts: 38
Location: Chennai, India
|
| Posted: Thu Jul 03, 2008 8:29 pm Post subject: |
|
|
INFIL--> I have given VSAM (Input)
INFIL1-->PATH ENTRY |
|
| Back to top |
|
Robert Sample
Joined: 06 Jun 2008
Posts: 943
Location: Atlanta, GA
|
| Posted: Thu Jul 03, 2008 9:02 pm Post subject: |
|
|
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 |
|
justinibm
Joined: 23 Jun 2007
Posts: 1
Location: pune
|
| Posted: Fri Jul 04, 2008 8:26 pm Post subject: |
|
|
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 |
|
Robert Sample
Joined: 06 Jun 2008
Posts: 943
Location: Atlanta, GA
|
| Posted: Fri Jul 04, 2008 9:01 pm Post subject: |
|
|
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 |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|
