what is the difference between vsam and dataset how do u create vsam dataset which file you r used?
2 9952looking at the basic definition of VSAM file how to recognize whether it is a KSDS OR RRDS OR ESDS ?
2 9115OPEN 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
2057write 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,
2268How 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 22756In 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 does the keyranges parameter in define cluster command do?
explain how do you define a gdg in vsam?
What is recovery parameters in define cluster command?
explain the information contained in ci
Differentiate between control interval (ci) and control area (ca)?
explain how many ways you can load data in a vsam cluster?
Can you delete vsam files with the delete option of the disposition parameter of jcl?
what do you mean by idcams? Explain its purpose?
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.
On which dataset you can have alt index?
Tell me how many alternate indexes you can have on a dataset?
is delete operation supported in an esds? Is rewrite operation possible in esds?
how many buffers are allocated to vsam ksds and esds?
what is the use of the file status clause in the select statement in vsam?
What are the different parameters that are used in vsam?