Recently Updated Cobol And DB2 Interview Questions Part – 4
Do Primary Key Values And Alternate Key Values Have To Be Unique?
Primary key values must be unique and alternate key values need not be unique.
What Is The Organization For A Ksds In Cobol Select Statement?
The ORGANIZATION for KSDS is INDEXED.
What Are Access Modes Available For Ksds Dataset?
ACCESS can be SEQUENTIAL, RANDOM or DYNAMIC.
What Is The Purpose Of The File Status Clause In The Select Statement?
File Status provide information about each I/O operation for the file.
What Is The Utility Program Closely Associated With Vsam?
IDCAMS the access method services utility is associated with VSAM.
What Are The Three Levels Of Definition For The Vsam Define?
They are DEFINE CLUSTER, DATA and INDEX.
During Processing Of A Vsam File, Some System Error Occurs And It Is Subsequently Unusable . What Do You Do?
Run VERIFY.
What Does ’02’ File Status Code Indicate?
’02’ indicates Non-Unique Alternate Index duplicate key found.
What Are Unique Cluster?
Unique Clusters consists of a separate data space which is utilized completely by the cluster created within it. Unique clusters are created out of unallocated space on direct access storage.
What Are Sub-allocated Clusters?
A sub-allocated VSAM file shares the VSAM space with other sub-allocated files. It specifies that file should be sub-allocated within existing VSAM space. Sub-allocation is used for easier management and control of VSAM spaces.
What Is Upgrade And Noupgrade Option In Alternate Index?
UPGRADE specifies that the alternate index should be modified if the base cluster is modified and NOUPGRADE specifies that the alternate indexes should be left alone if the base cluster is modified.
Explain Different Steps To Create Alternate Index?
First step is Define Alternate Index. Second is Define Path and third step is Building Index.
What Is The Use Of Alter Command In Vsam?
ALTER command is used to change most of the VSAM dataset attributes that were specified while defining VSAM cluster.