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
- 10406 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 |
to use the rewrite command, how should the vsam file be opened?
How to insert values for variables that are declared as COMP-3 variables in COBOL program in an already created VSAM file.
can alternate index use in ESDS since it does not contain primary index? if yes can you explain?
What is Control Interval, Control Area ?
Can you delete vsam files with the delete option of the disposition parameter of jcl?
What do you mean by RDW in VSAM?
In a file(PS), we dont know how many records are there. requirement is divide half n half the records n insert into 2 another files(PS).
what is vsam catalog ?
What are the three levels of definition for the VSAM DEFINE?
What is VERIFY command ? when do you use this command?? What actually it does ??
How to delete a member using JCL.?
What is the maximum no. of records that can be allowed in VSAM ?
COBOL 
