21. If you wish to use the REWRITE command haw must the VSAM file be opened? |
It must be opened as I/O. |
22. Explain the meaning and syntax for the START command. |
The START command is used read other than the next VSAM record. A value must be moved into the RECORD KEY. The KEY clause is optional, but it can be used to specify a relational (equal, less than, etc.) operator. |
23. What is the meaning of dynamic processing? |
It's rarely used. It means one program uses both sequential and random processing for a VSAM KSDS file. |
24. Name some common VSAM error conditions and codes. |
They are end of file (10), duplicate key (22), record not found (23), VSAM logic error (90), open problem (92) and space problem (93). |
25. What is the VSAM-code field? |
It is a COBOL II enhancement to VSAM batch processing expanding the FILE STATUS field. It is defined in WORKING-STORAGE as a six byte group item with three two byte elements, the normal return code, the function code and the feedback code. |
26. What is a VSAM slot? |
A relative record dataset (RRDS) consists of a specified number of areas called slots. Each slot is identified by a relative record number (RRN) which indicates its relative position in the file. |
27. What is the utility program closely associated with VSAM? |
IDCAMS, the access method services utility. |
28. There are at least seven IDCAMS commands; name and explain each of them. |
ALTER modifies information for a catalog, alternate index, cluster or path. BLDINDEX builds the alternate index, ofcourse. DEFINE is used for ALTERNATEINDEX, CLUSTER or PATH. DELETE removes the catalog entry for a catalog, cluster, alternate index or path. LISTCAT lists information about the dataset. PRINT prints the dataset contents. REPRO copies records from one file to another. |
29. What are the three levels of definition for the VSAM DEFINE? |
They are DEFINE CLUSTER, DATA and INDEX. |
30. What is the significance of the SHAREOPTIONS parameter? |
It specifies how the file may be shared between jobs and between batch and CICS environments. |
Copyright 2020 by ibmmainframer. All Rights Reserved.