Interested to Buy Any Domain ? << Click Here >> for more details...
How to declare the EMP Name, EMP No., DOB in VSAM KSDS
file? Please explain.....
- 3 Answers
- 10408 Views
- CTS, I also Faced
- E-Mail Answers
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 |
If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?
Suppose 3 generations of a GDG exist. How would you reference the 1st generation in the JCL?
Explain the function of entry-sequenced data set?
why ci and ca splits are not possible in esds and rrds?
What are the access method services used in vsam?
What is an alternate index?
HOW TO SORT RECORDS IN VSAM FILE?
What is the significance of the SHAREOPTIONS parameter?
Define free space?
What is the difference between sequential files and ESDS files?
What is the function of entry sequenced data set?
What is a VSAM slot?
COBOL 
