what are the different types of vsam files available? Explain them
1. Entry sequential data set(ESDS) works like sequential file which contains only cluster and data components.
We must mention NONINDEXED while defining ESDS cluster.
It supports only sequential access in batch program.
2. Key sequential data set(KSDS) has three components(CLUSTER, DATA and INDEX).
We must code INDEXED while defining the KSDS cluster.
Data component consists of sorted records which are based on key values.
Index component consists of key values and the pointer to the data records.
3. Relative Record Data Set(RRDS) records are identified using Relative Record Number (RRN). Records are stored in numbered.
4. The linear dataset(LDS) is a byte-stream dataset which is commonly used in DB2 system. This dataset is rarely used in application programs.
Mainframe important concepts and programs are explained in the IIWOWIIS channel in youtube. Please support us and share your comments.
| Is This Answer Correct ? | 0 Yes | 0 No |
How does control intervals and control areas related to each other?
How do you load a VSAM data set with records ?
Tell me how many alternate indexes you can have on a dataset?
What is the main function of key-sequenced data set?
If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?
What is the utility program closely associated with VSAM?
what is the use of reuse in vsam?
What is the meaning of each of the values in SHAREOPTS(2 ?
how to see the last records in vsam dataset??
what will happen when you try to open an empty vsam file in a cobol program for input?
Can we copy a sequential file to a VSAM file ? If yes, What will happen of the size of the sequential file is bigger than that of the VSAM file?
what is reuse parameter ?