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 |
Define dynamic processing?
in a cobol select statement for a ksds can you tell me what are the 3 possibilities for access?
what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?
While designing vsam files,what is the best way to choose control interval size for the data and the index?
What is SHAREOPTS ?
What is control interval?
How to get the last record in vsam file in cluster? And how can u get the ksds file records into cobol program?
What is the meaning of dynamic processing?
what is the difference between vsam and dataset how do u create vsam dataset which file you r used?
what do you mean by define model parameter?
What is a vsam dataset?
explain in brief why do vsam take more disk space than other utilities?