How to declare the EMP Name, EMP No., DOB in VSAM KSDS
file? Please explain.....
Answer Posted / prachi
//STEP010 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DEFINE CLUSTER (NAME (EMPLOYEE.INFO.FILE) -
VLOUMES(TSOP01) -
CYLINDERS(10,2) -
CONTROLINTERVALSIZE(4096) -
FREESPACE(10,20) -
KEYS(5,21) -
RECORDLENGHT(31,31) -
DATA -
(NAME(EMPLOYEE.INFO.FILE.DATA)) -
INDEX -
(NAME(EMPLOYEE.INFO.FILE.INDEX) -
CONTROLINTERVALSIZE(1024))
/*
//
ASSUMING FOLLOWING THINGS
EMP-NO AS KEY
EMP-NO PIC 9(5)
EMP-NAME PIC X(20)
DOB PIC X(6)
RECORD IS FIXED LENGHT
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the main function of key sequenced data set in vsam?
what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?
Define gdg?
What makes vrrds different from vsam?
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.
What is the purpose of idcams?
What is the purpose of control intervals in vsam?
Differentiate between ci split and ca split?
what are the codes returned by the ams (access method services) command during the execution in vsam?
Would you specify freespace ce for an esds?
what do you mean by define model parameter?
what are the idcams commands that can be used for vsam and explain each of them.
why ci and ca splits are not possible in esds and rrds?
what is the meaning of each of the values in shareopts(2 3)?
Tell me how many alternate indexes you can have on a dataset?