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
- 10083 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 |
What is a CI, control interval?
What is the difference between lds and esds?
What is the upgrade set?
Suppose 3 generations of a GDG exist. How would you reference the 1st generation in the JCL?
How are records stored in an ESDS, entry sequenced dataset?
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 are the building blocks used in vsam datasets?
what do you mean by a shareoptions parameter (shr) in define cluster command?
What does the keyranges parameter in define cluster commends do?
In vsam why we use export-import utility?
Explain the device independent method to indicate where a record is stored?
looking at the basic definition of VSAM file how to recognize whether it is a KSDS OR RRDS OR ESDS ?
COBOL 
