How to declare the EMP Name, EMP No., DOB in VSAM KSDS
file? Please explain.....
Answer Posted / 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 |
Post New Answer View All Answers
Can you delete vsam files with the delete option of the disposition parameter of jcl?
Define free space?
explain how can you initialize a vsam file before any operation?
What are the distinctive features of a ksda, key sequenced dataset?
Explain the biggest disadvantage of using a vsam dataset?
How do you define an altindx?
Explain the index set?
OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output
What is control interval?
explain the differences between vsam and non-vsam files
is it required that primary key values have to be unique? Do alternate key values have to be unique?
what is the meaning of each of the values in shareopts(2 3)?
what is the use of the file status clause in the select statement in vsam?
what is meant by s0c-07 system abend codes?
Define a path?