HOW TO SORT RECORDS IN VSAM FILE?

Answers were Sorted based on User's Feedback



HOW TO SORT RECORDS IN VSAM FILE?..

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

HOW TO SORT RECORDS IN VSAM FILE?..

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

HOW TO SORT RECORDS IN VSAM FILE?..

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

Post New Answer

More VSAM Interview Questions

How is record management performed in vsam?

0 Answers  


what are the codes returned by the ams (access method services) command during the execution in vsam?

0 Answers   IBM,


What makes vrrds different from vsam?

0 Answers  


Explain the purpose of the file status clause in the select statement?

0 Answers  


what is buffering and how does it apply to vsam files ?

0 Answers   IBM,


What does the KEYRANGES parameter in Define Cluster commend do?

1 Answers  


what is the purpose of the verify function of idcams?

0 Answers   IBM,


What is a vsam dataset?

0 Answers  


what is reuse parameter ?

3 Answers   Polaris, Xansa,


Explain the biggest disadvantage of using a vsam dataset?

0 Answers  


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?

3 Answers  


Do all versions of the GDG have to be of the same record length ?

3 Answers   IBM, iNautix,


Categories