what is alternate index?
Answer / bhakti
It is used whenever data needs to be retrieved on the basis
of the other fields i.e. other than primary fields.
Supported by KSDS and ESDS only but not by RRDS and LDS
because they do not have any index component.
Not more than 253 AIX (Alternate Index) can be specified.
AIX is composed of Primary key record along with the field
identified as secondary key.
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain the function of the dd dcb keyword?
What is the purpose of dd dummy statement?
a dd statement has 2 types of parameters. Name them?
a set statement is used to define commonly used symbolic across job steps or procedures. It initializes the previous values in the symbolic names. It has to be defined before the first use of the symbolic names in the jcl. State whether true or false?
How can you execute a COBOL program via SYSIN in JCL?
wht do u mean by inrec and outrec ?
how to allocate a dynamic dataset in jcl ?
What is the difference between primary and secondary allocations for a dataset?
What is the difference between the JOBLIB and the STEPLIB statements?
shall we concordinate two different length dataset in to a new date set.
What is GDG?
Please go thru the below points and let me know how to code this. 1. Sort the input dataset for the condition : Starting position is 37,length of the field is 13 based on character and in the ascending order , starting from position 25 length of 12 ,character and in the ascending order. Use a temporary dataset to hold the sorted file. 2. Use the temporary file created in the above step as the input for the next step. The next step is to execute a program and produce an output file. Use the temporary file created in the above as work file 1 and the output of the file to be created in this step work file 2.Also, pass a parameter to the program that is to be executed in this step. The parameter should have the current date in YYYYMMDD format. For the sake of convenience, you can use the below Job Name : Sample1 Input DSN : PCABDT11.CABD.TEST.INPUT Temporary DSN : Sort1 Output DSN : PCABDT11.CABD.TEST.OUTPUT Program Name : SAMPLE Thanks in Advance for your response.