How to declare the EMP Name, EMP No., DOB in VSAM KSDS
file? Please explain.....
- 3 Answers
- 8861 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 |
Explain the meaning and syntax for the START command. ?
What is the difference between CI( Control Interval)and CA (Control Area)?
if not using the 'commit' when closing VSAM file,what will happend
What is a path?
What is the purpose of relative record data set used in vsam?
Why is it required to have a keyed directed retrieval?
The first VSAM file V1 has 2 fields A and B . There is a DB2 file which has fields E and f. We need the fields A, B , E and F to another VSAM file called V2. Kindly mention the logic in procedure division in cobol..
What is IDCAMS ?
What is an alternate index and path ?
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?
Is it slower if you access a record through alt index as compared to primary index?
what do you mean by gdg in vsam?
COBOL 
