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
explain in brief what are the 3 types of vsam files?
we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.
Differentiate between ci split and ca split?
Define dynamic processing?
Explain the catalog?
Tell me how many alternate indexes you can have on a dataset?
Explain the index set?
Define base cluster?
What is the use of lds (linear data set)?
what do you mean by a vsam slot?
in a cobol select statement, can you tell what is the organization for a ksds?
What does the keyranges parameter in define cluster commends do?
what is the meaning of each of the values in shareopts(2 3)?
Describe the uses of ams?
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.