Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> VSAM
  2. Suggest New Category

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

Question Posted / khbnaidu

Answers were Sorted based on User's Feedback



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

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

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

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

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

Answer / shiva

Gomathi you are 100% correct..

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More VSAM Interview Questions

What is the difference between shroptions(2 3) and shroptions (4 3) in the Def CLUSTER ??

3 Answers  

What is the index set?

1 Answers  

how can you copy to a vsam cluster?

0 Answers   IBM,

What is the catalog?

1 Answers  

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

0 Answers  

If FSPC(100 10 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?

1 Answers   DSRC,

Hi, I want to create alternate index on VSAM file.my file structure is ex: RoomID pic x(7) R000001 Floor pic a((6) First RoomNo pic x(2) FA1 Occupied(yes/no) pic a(3) Yes Occupied Batch pic x(10). Maths i want to create alternate index on floor,roomno fields.can i create alternate index on both the fields.and tell me how to create.

1 Answers  

there are seven idcams commands in vsam. Can you name and explain each of them?

0 Answers   IBM,

why do we use vsam file thn seqential files ?

3 Answers   Tech Mahindra,

Describe the uses of ams?

0 Answers  

what is the concept of IMPORT in vsam??

2 Answers  

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.

0 Answers  

For more VSAM Interview Questions Click Here
Categories