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 the meaning of each of the values in shareopts(2 3)?

0 Answers   IBM,


During processing of a VSAM file, some system error occurs and it is subsequently unusable . What do you do ?

1 Answers  


What are the different types of VSAM files available?

3 Answers   CSC,


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.

4 Answers   Target,


what do you mean by idcams? Explain its purpose?

0 Answers   IBM,


What makes vrrds different from vsam?

0 Answers  


What happens when you open an empty VSAM file in a COBOL program for input?

5 Answers   IBM,


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?

0 Answers   IBM,


Differentiate between ci split and ca split?

0 Answers  


What are the different parameters that are used in vsam?

0 Answers  


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...

0 Answers   CTS,


Categories