Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO SORT RECORDS IN VSAM FILE?
- 3 Answers
- 23816 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sumit agnihotri
when we load a records through the REPRO command in the VSAM file so the input file must be sorted on the primary key using SORT utility ..
//sysin dd *
sort fileds = (1,5,ch,a)
/*
//
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pooja
by using pgm=sort
and in sysin dd pass sort fields(first coloumn no,lenth of
the character,ch,a/d)
a for ascending and d for descending
| Is This Answer Correct ? | 7 Yes | 5 No |
Answer / sumit agnihotri
vsam file record are enter in a sorted order but when we
retrieve a records in KSDS so we specify a primary key
(unique) , in ESDS we enter a record in any order but
retrieve a records through the RBA (Relative byte address)
who r auto-generated, and also enter a record in any order
but retrieve records through the RRN (relative record
number)....
so the Answer is that we enter a records in a VSAM file
in a sorted order ....
| Is This Answer Correct ? | 3 Yes | 2 No |
Explain about the file objects in vsam?
what is vsam catalog ?
What is a CA, control area?
What is the utility program closely associated with VSAM?
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.
How vsam datasets are cataloged?
Differentiate between control interval (ci) and control area (ca)?
what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?
How do you initialize a VSAM file before any operation? a VSAM with alternate index?
Explain the catalog?
How do you load a VSAM data set with records ?
why do we use vsam file thn seqential files ?
COBOL 
