Mainframe Interview Questions

You must code EXEC CICS ASSIGN with the OPENID option.

If any one want to restrict Trans-ID to single user, enter trans-id with ENQ. It won't allow any one else to use the same trans-id.

GROUP BY partitions the selected rows on the distinct values of the column on which you group by. HAVING selects GROUPs which match the criteria specified

The INTO option moves the information in the TIOA into the reserved specified area, while the SET option simply returns the address of the TIOA to the specified BLL cell or address of a linkage-section.

It can be done by setting the record length’s size to more than half of the page’s size.

 -1 indicates the field is null

 0 indicates the field is not null

 -2 indicates the field is truncated

Because SALARY is not declared to have NULLs and the employees for whom the salary is not known are also counted.

While allocating KSDS Datasets, free space is declared at regular intervals at the time of initial loading. This is done because this free space is utilized for keeping the data arranged in sequence physically, even though inserted randomly.