Create syntax for a VSAM file ?
Answers were Sorted based on User's Feedback
Answer / prasad
DEFINE CLUSTER -
(NAME (XX17.TEST.VSAM) -
INDEXED -
KEYS (8 0) -
RECSZ (300 300) -
FREESPACE (10 5) -
MGMTCLAS (MCNEVER) -
CYL (80 20) -
SHR (1 3) -
SPEED -
REUSE) -
DATA (NAME (XX17.TEST.VSAM.DATA) -
CISZ (4096)) -
INDEX (NAME (XX17.TEST.VSAM.INDEX) -
CISZ (2048))
| Is This Answer Correct ? | 52 Yes | 6 No |
Answer / dhiraj
FOR ESDS:-
DEFINE CLUSTER (NAME(USERID.VSAM.ESDS) -
VOLUME(xxxxxx) -
TRACKS(5 2) -
RECORDSIZE(80 80) -
CISZ(4096) -
NONINDEX) -
DATA (NAME(USERID.VSAM.ESDS.DATA))
| Is This Answer Correct ? | 30 Yes | 11 No |
What is the meaning of the DEFINE MODEL parameter?
What are the common vsam error conditions and codes?
Define gdg?
is it necessary that all versions of the gdg have to be of the same record length?
name a few common vsam status codes?
How is record management performed 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 is a ci split?
What is an alternate index and path ?
Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
explain in brief how you can create a vsam file?
explain in brief how are different versions of gdg named?