How to declare the EMP Name, EMP No., DOB in VSAM KSDS
file? Please explain.....
Answers were Sorted based on User's Feedback
Answer / gomathi
//PSTY0010 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DEFINE CLUSTER (NAME (SAMPLE.DATA) -
TRACKS(45 15) -
RECORDSIZE(80 80) -
FREESPACE(10 15) -
KEYS(6 0) -
INDEXED) -
DATA (NAME(SAMPLE.DATA.DAT) -
CISZ(8192)) -
INDEX (NAME(SAMPLE.DATA.IDX))
/*
//*
In Key (6,0) mention the start position and length of the
key
| Is This Answer Correct ? | 11 Yes | 5 No |
Answer / 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 |
Under idcams, multiple functions can be executed, each of which returns a condition code. What will be the condition code returned to the operating system?
By seeing a program how we findout it is a VSAM program?
explain how do you define a gdg in vsam?
What is the utility program closely associated with VSAM?
What is a CA, control area?
What are the different types of VSAM files available?
what is the meaning of dynamic processing in vsam?
Explain the function of the relative record data set?
if you wish to use the rewrite command how must the vsam file be opened?
What is the purpose of idcams?
What is an alternate index?
What are the different commands used in idcams for vsam?