HOW TO SORT RECORDS IN VSAM FILE?
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 |
how yo view the vsam file?
Explain what are the optional parameters to the input dataset while loading the empty cluster with the data records?
What are the optional parameters to the input dataset While loading the empty cluster with the data records?
Do primary key values have to be unique? Do alternate key values have to be unique?
looking at the basic definition of VSAM file how to recognize whether it is a KSDS OR RRDS OR ESDS ?
what do you mean by define model parameter?
How do you define an altindx?
Can we copy a sequential file to a VSAM file ? If yes, What will happen of the size of the sequential file is bigger than that of the VSAM file?
How do you define a KSDS ?
In vsam why we use export-import utility?
when u r using repro command what happens if both infile and outfile names same
By looking into JCL can we identify the dataset is VSAM (VSAM dataset supposed to be a input dataset).In this scenerio how will we identify the dataset is VSAM ?
5 Answers Cognizant, EDS, Shridhar,