Mainframe Interview Questions

They are DEFINE CLUSTER, DATA and INDEX.

The following commands are available for the Program Control services:

LINK: To pass control to another program at the lower level, expecting to be returned. XCTL: To pass control to another program at the same level, not expecting to be returned.

RETURN:  To return to the next higher-level program or CICS. 

LOAD: To load a program. 

RELEASE: To release a program.

DB2 precompiler (if embedded sql used), CICS translator (if CICS program), COBOL compiler, Link editor. If DB2 program, create plan by binding the DBRMs.

READNEXT reads the next record from a browse operation for any of the three VSAM files.

DeCLarations GENerator : used to create the host language copy books for the table    definitions. Also creates the DECLARE table.

Primary key : a relational database constraint. Primary key consists of one or more columns that uniquely identify a row in the table. For a normalized relation, there is one designated primary key.

Unique index: a physical object that stores only unique values. There can be one or more unique indexes on a table.

Go to file-aid copy option.Enter the from dataset to be copied and to dataset to which you want to copy.go to options. Enter 0 at Initial records to skip field.Then enter 3 at the no of records to skip field and 1 to no of records to select.press enter and PF3.

EXEC CICS READ

DATASET('FILENAME')

INTO(data-area)

RIDFLD(data-area)

KEYLENGTH(1)

GENERIC

LENGTH(WK-LEN)

END-EXEC.