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 |
can we create vsam files on multiple volumes ?
What is the purpose of the FILE STATUS clause in the SELECT statement?
Explain the index set?
what are the different types of vsam files available? Explain them
What are the information stored in ci?
explain in brief why do vsam take more disk space than other utilities?
What is the difference between shroptions(2 3) and shroptions (4 3) in the Def CLUSTER ??
Is CA(Control Area) is part of CI(Control Interval)
is there any lock for vsam file so that no one can update the vsam file ?
Explain the catalog?
What is the main function of key-sequenced data set?
State the differences between vsam and non-vsam files?