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 |
to use the rewrite command, how should the vsam file be opened?
what is the concept of IMPORT in vsam??
Syntax of AMS modal commands ?
How do I declare the KSDS vsam so that I can store a reocrd with variable length?.
What is the meaning of dynamic processing?
explain how do you define a gdg in vsam?
write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...
what do you mean by a shareoptions parameter (shr) in define cluster command?
How Vsam was evolved? What was the equivalent file for ESDS,KSDS and RRDS prior to evolution? What were their disadvantages of those file which leads to evolution of ESDS,KSDS and RRDS files ?
How do you define an ALTINDX ? How do you use ALTINDXs in batch, CICS pgm?s ?
What does the keyranges parameter in define cluster commends do?
What is the Difference between LDS & ESDS ?