Mainframe Interview Questions

Q:

File contains 5 records say D,E,F,C,A-I want to copy D and A records only by using file-aid?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 1860
Q:

What guidelines should be followed to write a structured COBOL program ?

Answer

Following guidelines to be following while writing Cobol program:


- Use ? EVALUATE ? statement for constructing cases.


- Use scope terminators for nesting.


- Use in-line Perform statement for writing ?do? constructions.


- Use Test Before and Test After in the Perform statement while writing Do-While statements.

Report Error

View answer Workspace Report Error Discuss

0 1816
Q:

What is COPY PENDING status?

Answer

- A status occurs when image copy on a table needs to be taken


- The table is available only for queries and can not be updated


- COPY PENDING status can be removed by taking away the image copy or by using REPAIR utility

Report Error

View answer Workspace Report Error Discuss

0 1788
Q:

What is meant by index cardinality?

Answer

The number of distinct values for a column is called index cardinality. DB2's RUNSTATS utility analyzes column value redundancy to determine whether to use a tablespace or index scan to search for data.

Report Error

View answer Workspace Report Error Discuss

0 1759
Q:

What is the self-referencing constraint?

Answer

A31. The self-referencing constraint limits in a single table the changes to a primary key that the related foreign key defines. The foreign key in a self referencing table must specify the DELETE CASCADE rule.

Report Error

View answer Workspace Report Error Discuss

0 1756
Q:

What is the need to code COMMITS in batch programs?

Answer

COMMIT statements are used to release locks which are required for that unit of work, and then permit a new unit of work. In other words, if COMMITS are not coded in the program and the program has been sent for execution, then while processing, in place of just going back to a few inserts since the nearest commit, the program has to go back to the inserts which were made during the entire run of the program. This extra process takes around twice or thrice the time taken normally.

Report Error

View answer Workspace Report Error Discuss

0 1743
Q:

What is the difference between the enter key, the PF keys and the PA keys?

Answer

The enter and PF keys transmit data from the screen; the PA keys tell CICS that a terminal action took place, but data is not transmitted.

Report Error

View answer Workspace Report Error Discuss

0 1742
Q:

What is the CICS LOAD command ?

Answer

The LOAD command retrieves an object program from disk and loads it into main storage - it's primarily used for a constant table that will be available system-wide.


 

Report Error

View answer Workspace Report Error Discuss

0 1732