How to declare the EMP Name, EMP No., DOB in VSAM KSDS
file? Please explain.....

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does the keyranges parameter in define cluster command do?

528


what are the idcams commands that can be used for vsam and explain each of them.

554


in a cobol select statement, can you tell what is the organization for a ksds?

630


differentiate between sequential files and esds files in vsam?

587


How does control intervals and control areas related to each other?

558






What is a ci split? What is a ca split?

655


Can you delete vsam files with the delete option of the disposition parameter of jcl?

658


Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.

1880


What are the information stored in ci?

579


What is the main function of key sequenced data set in vsam?

533


If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?

638


Define gdg?

565


Explain the purpose of the file status clause in the select statement?

524


how do you define an altindx ? How do you use altindxs in batch, cics programs?

612


How do you calculate record size of an alternate cluster?

673