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 |
what is the meaning of each of the values in shareopts(2 3)?
During processing of a VSAM file, some system error occurs and it is subsequently unusable . What do you do ?
What are the different types of VSAM files available?
what is the drawback of vsam dataset?? a.execution slow. b.free space. c.independent storage device. d.none of the above. let me know the answer with reason.
what do you mean by idcams? Explain its purpose?
What makes vrrds different from vsam?
What happens when you open an empty VSAM file in a COBOL program for input?
By looking into JCL can we identify the dataset is VSAM (VSAM dataset supposed to be a input dataset).In this scenerio how will we identify the dataset is VSAM ?
5 Answers Cognizant, EDS, Shridhar,
how many buffers are allocated to vsam ksds and esds?
Differentiate between ci split and ca split?
What are the different parameters that are used in vsam?
write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...