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 |
what is the purpose of the verify function of idcams?
What is a VSAM split?
Explain what are the optional parameters to the input dataset while loading the empty cluster with the data records?
can you specify some the distinctive features of a ksds, key sequenced dataset?
What is an RBA in rrds? What does it do? What is it used for?
Would you specify FREESPACE for an ESDS?
Can we copy a sequential file to a VSAM file ? If yes, What will happen of the size of the sequential file is bigger than that of the VSAM file?
what do you mean by idcams? Explain its purpose?
How are different versions of GDG named ?
Using alternate indexes in batch program?
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?
can we access sequential files online