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

What is IDCAMS ?

2 Answers  


What is the difference between sequential files and ESDS files?

1 Answers   IBM,


What is IDCAMS? and what is the purpose of it?

4 Answers  


Alt key is used for what type of vsam file

3 Answers  


While designing vsam files,what is the best way to choose control interval size for the data and the index?

1 Answers  






What is VERIFY command ? when do you use this command?? What actually it does ??

2 Answers   Xansa,


How do you define a KSDS ?

1 Answers   IBM,


How to createing new version of GDG with out loosing the data in preaves GDG version?

7 Answers   Patni, Satyam,


What's a LDS (Linear Data Set) and what's it used for?

1 Answers   Cap Gemini, Steria,


What is the maximum no. of records that can be allowed in VSAM ?

2 Answers  


how do you create an alternate index ?

0 Answers   IBM,


Is CA(Control Area) is part of CI(Control Interval)

3 Answers  


Categories