VSAM Interview Questions
Questions Answers Views Company eMail

What is the use Free space in CI ?

4 7062

Is CA(Control Area) is part of CI(Control Interval)

3 5499

How can you create a VSAM dataset? Can you write a JCL for it?

IBM, TCS,

4 21854

is there any lock for vsam file so that no one can update the vsam file ?

HCL,

2 8716

what is the use of aix in vsam why do we go for aix and wht is build index in vsam?

HCL, IBM,

5 10516

what is the difference between vsam and dataset how do u create vsam dataset which file you r used?

Fidelity,

2 9952

By seeing the file itself how can we identify whether it is A vsam file or flat file

IBM,

7 12226

looking at the basic definition of VSAM file how to recognize whether it is a KSDS OR RRDS OR ESDS ?

IBM, Infosys,

2 9115

OPEN INPUT StudentFile READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ PERFORM UNTIL EndOfStudentFile DISPLAY StudentId SPACE StudentName SPACE CourseCode SPACE YOBirth READ StudentFile AT END SET EndOfStudentFile TO TRUE END-READ END-PERFORM CLOSE StudentFile STOP RUN what will be output

2057

write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...

CTS,

2268

what is meant by BUFND & BUFNI..?

1 10345

How to open VSAM file from 3.4? i have millions of records and i dont want to use the print ch ids(/) command bcz it takes to much time. so if you have any another command to open this plz tell me.

HSBC,

2 22756

In a KSDS file, key is missing for one record. How to insert the key for that particular record from back up file. Is there any sorting needed for the back up file before the key insertion?

RBS,

982

what is the syntax of ams modal commands?

IBM,

766

what how do you initialize a vsam file before any operation? A vsam with alternate index?

IBM,

551


Post New VSAM Questions

Un-Answered Questions { VSAM }

What does the keyranges parameter in define cluster command do?

516


explain how do you define a gdg in vsam?

580


What is recovery parameters in define cluster command?

553


explain the information contained in ci

593


Differentiate between control interval (ci) and control area (ca)?

522






explain how many ways you can load data in a vsam cluster?

572


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

650


what do you mean by idcams? Explain its purpose?

535


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.

1870


On which dataset you can have alt index?

495


Tell me how many alternate indexes you can have on a dataset?

602


is delete operation supported in an esds? Is rewrite operation possible in esds?

585


how many buffers are allocated to vsam ksds and esds?

703


what is the use of the file status clause in the select statement in vsam?

562


What are the different parameters that are used in vsam?

714