VSAM Interview questions

sivatechdrive · Posted: Mon Feb 14, 2005 5:02 pm

Hi all

i was asked the following questions in Capgemini interviews,but i was unable to answer properly,plz do reply

1. how to copy a VSAM file without using Repro

2.Suppose i have 10,00 records in a ESDS file,and 1 record is currupted,what is the quick way to identify the currupted record.

3.what happens when you open and read an empty VSAM file

Thanks
Siva

rick · New User Joined: 18 Jun 2004 Posts: 59 Location: Chennai

Hi,

1) you can use Tools such as FILE-AID , DATA-EXPERT to copy the records to a VSAM file.

3) When u try to read an empty VSAM file it shoots up an error. An EMPTY file cannot be read.

Rick
frederick.tybalt@anewcon.com

kingofmf · New User Joined: 02 Mar 2005 Posts: 13 Location: Bangalore

to make one exact copy of a VSAM there is a key LIKE=source dataset
i dont know the actual syntax how to use.

srividya.srinivasan · Posted: Thu May 05, 2005 4:47 pm

Hi,

If u have more records, and the Job abended you can do two things,

(i) First of all catalogue the new file on to which you are writing, with new, catlg , catlg option so that even though the job abends all the records processed would be written into the new file and you can hence find the Record which is corrupt.

(ii) The other method is with the help of the Offset value, which is much easier.

pls let me know if i am wrong.

thanks

Vidya