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 did you refresh a VSAM file and how frequently you do it ?
3 Answers CSC, IBM, Patni, Xansa,
Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now?
What is RECOVERY and SPEED parameters in DEFINE CLUSTER command?
What are the different types of VSAM files available?
what is freespace
What are the types of VSAM datasets?
what do you mean by the repro command?
explain in brief how are different versions of gdg named?
Tell about the ams used in vsam?
in a cobol select statement, can you tell what is the organization for a ksds?
What is recovery parameters in define cluster command?
Suppose a generation of GDG gets created in a particular step of a proc. How would you refer the current generation in a subsequent step? What would be the disposition of this generation now ?