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 is record management performed in vsam?
what are the codes returned by the ams (access method services) command during the execution in vsam?
What makes vrrds different from vsam?
Explain the purpose of the file status clause in the select statement?
what is buffering and how does it apply to vsam files ?
What does the KEYRANGES parameter in Define Cluster commend do?
what is the purpose of the verify function of idcams?
What is a vsam dataset?
what is reuse parameter ?
Explain the biggest disadvantage of using a vsam dataset?
1. delete is not possible in esds. why? 2. i have 10 records in a esds file and i want to delete only 1st record ..then what i have to do?.. it will not affect any sequence of the RBA. 3. why open extend is not possible in rrds vsam file?
Do all versions of the GDG have to be of the same record length ?