Using Alternate Indexes in Batch program:

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Using Alternate Indexes in Batch program:

In the JCL, you must have DD statements for the cluster and for the path9s). In the COBOL program, SELECT ... ASSIGN TO ddname for base cluster RECORD KEY IS... ALTERNATE RECORD KEY IS ...

(Continued on next question...)

Other Job Interview Questions

• What is RECOVERY and SPEED parameters in DEFINE CLUSTER command ?
• Under IDCAMS, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system ?
• Do primary key values have to be unique? Do alternate key values have to be unique?
• How do you load a VSAM data set with records ?
• What is Control Interval, Control Area ?
• Syntax of AMS modal commands ?
• How many buffers are allotted to VSAM KSDS and ESDS ?
• What happens when you open an empty VSAM file in a COBOL program for input ?
• What is an alternate index and path ?
• What is the difference between sequential files and ESDS files ?
• More...