How do you calculate record size of an alternate cluster?
Give your values for both unique and nonunique.
Answer / guest
Unique Case: 5 + ( alt-key-length + primary-key )
Non unique Case: 5 + ( alt-key-length + n * primary-key )
where n = number of duplicate records for the alternate key
Is This Answer Correct ? | 7 Yes | 0 No |
looking at the basic definition of VSAM file how to recognize whether it is a KSDS OR RRDS OR ESDS ?
What does the keyranges parameter in define cluster commends do?
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.
What is an alternate index?
Explain what are the optional parameters to the input dataset while loading the empty cluster with the data records?
What is the purpose of the FILE STATUS clause in the SELECT statement?
what are the codes returned by the ams (access method services) command during the execution in vsam?
Can you delete vsam files with the delete option of the disposition parameter of jcl?
What is a sequence set?
Using alternate indexes in batch program?
Define gdg?
What is the Difference between LDS & ESDS ?