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 |
In the COBOL SELECT statement what is the ORGANIZATION for a KSDS?
in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?
what is meant by BUFND & BUFNI..?
If you wish to use the REWRITE command haw must the VSAM file be opened?
During processing of a VSAM file, some system error occurs and it is subsequently unusable . What do you do ?
State the differences between vsam and non-vsam files?
Explain the catalog?
print ids(/)char??what is the full form of ids??
what how do you initialize a vsam file before any operation? A vsam with alternate index?
what is the difference b/w sequential and ESDS
What does the KEYRANGES parameter in Define Cluster commend do?
What is the difference between shroptions(2 3) and shroptions (4 3) in the Def CLUSTER ??