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
- 10298 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 Base Cluster ?
Define gdg?
How do you calculate record size of an alternate cluster? Give your values for both unique and nonunique.
What is the meaning of VSAM RETURN-CODE 28?
explain how can you initialize a vsam file before any operation?
What is the use of lds (linear data set)?
how can you copy to a vsam cluster?
explain the differences between vsam and non-vsam files
What are the distinctive features of a ksds, key sequenced dataset?
can you specify some the distinctive features of a ksds, key sequenced dataset?
In vsam why we use export-import utility?
How do you load a VSAM data set with records ?
COBOL 
