How do you convert flat files to VSAM files ?
Answers were Sorted based on User's Feedback
Answer / dev
u can not directly convert a flat file to vsam file because
vasam file have something called key filed which u need to
specify and it should be in some order asc/dsc or we can
say sorted on key filed and then we can copy the flat file
to vsam file
| Is This Answer Correct ? | 12 Yes | 4 No |
Answer / mainframe virumbi
The attributes of the VSAM and Flat files are totally
different, so we cant copy the entire characteristics, but
i think we can copy the contents i.e datas using idcams
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / sajid
use idcams export option which will convert a flat file into
vsam file by copying the datset along with its attributes...
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / jerry
please make sure that we should sort primary keys only in
asending order while copying.... here some one gave
ase/dse.. i think its not possible
| Is This Answer Correct ? | 3 Yes | 6 No |
is it necessary that all versions of the gdg have to be of the same record length?
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 is the upgrade set?
What are the types of VSAM datasets?
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 the meaning of each of the values in shareopts(2 3)?
Define dynamic processing?
There are at least seven IDCAMS commands; name and explain each of them ?.
Yes. Because the alternate key would first locate the primary key, which in turn locates the actual record. Needs twice the number of I/Os.
What is the difference between shroptions(2 3) and shroptions (4 3) in the Def CLUSTER ??
is it slower if you access a record through alternative index as compared to primary index?
Explain the device independent method to indicate where a record is stored?