abhijeet

• Mar 6th, 2006

 

Hello,

You can use RERPO option in IDCAMS utility.

Regarsds,

Abhijeet

DavidStagg

 Profile Answers by DavidStagg 

• Mar 19th, 2006

 

Let's be a little more precise.We will take the tack that you will be creating a KSDS file.First, you need to know which field/s you will be using as the primary key and if you need, alternate keys. Sort the records by that field/s.Use IDCAMS REPRO to load the flat file into the VSAM file.

Selva

• Sep 29th, 2006

 

Hi all,

     You can't convert the flat files to Vsam files. The data, it means the record in the flat file will be copied to vsam file where you can have any field as the primary key but it should be unique.

Etnad

• Nov 18th, 2007

 

You can convert flat files to VSAM:
1. Identify what will be your primary key. If you don't want to, the whole record can be your primary key.
2. Sort the file by primary key or the whole record (if no primary key selected) and use the sort statement that drop duplicates.
3. Submit a JCL (IDCAMS - Define Cluster) using the output of step #2 as your input.  

kousikgeek

 Profile Answers by kousikgeek 

• Oct 25th, 2008

 

Following steps will convert a sequential file to VSAM file.
1. Sort the sequential fille, with SORT FIELD=NONE, to remove the duplicate key records.
2. Define a VSAM file
3. Use REPRO to copy the sequential file to VSAM file.