|
|
| Author |
Message |
murugan_mf
New User
Joined: 31 Jan 2008
Posts: 38
Location: Chennai, India
|
|
|
|
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 |
|
 |
References
|
|
 |
Robert Sample
Senior Member
Joined: 06 Jun 2008
Posts: 936
Location: Atlanta, GA
|
|
|
|
| Generally, if the DD name for the base cluster is DDNAME, the alternate index will be DDNAME1. |
|
| Back to top |
|
|
murugan_mf
New User
Joined: 31 Jan 2008
Posts: 38
Location: Chennai, India
|
|
|
|
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
Senior Member
Joined: 06 Jun 2008
Posts: 936
Location: Atlanta, GA
|
|
|
|
| What's the JCL and the COBOL SELECT clause look like? |
|
| Back to top |
|
|
murugan_mf
New User
Joined: 31 Jan 2008
Posts: 38
Location: Chennai, India
|
|
|
|
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
Senior Member
Joined: 06 Jun 2008
Posts: 936
Location: Atlanta, GA
|
|
|
|
| What's the //INFIL and //INFIL1 JCL DD statements look like? |
|
| Back to top |
|
|
murugan_mf
New User
Joined: 31 Jan 2008
Posts: 38
Location: Chennai, India
|
|
|
|
INFIL--> I have given VSAM (Input)
INFIL1-->PATH ENTRY |
|
| Back to top |
|
|
Robert Sample
Senior Member
Joined: 06 Jun 2008
Posts: 936
Location: Atlanta, GA
|
|
|
|
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
New User
Joined: 23 Jun 2007
Posts: 1
Location: pune
|
|
|
|
| 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
Senior Member
Joined: 06 Jun 2008
Posts: 936
Location: Atlanta, GA
|
|
|
|
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 |
|
|
|
|
