Converting flat file to VSAM using JCL only

wicked1925

Hi guys... i need to convert an input flat file into a VSAM file with the use of JCL only. can anyone suggest to me the utility that i should use. just to be more detailed, i need to convert my input INFILE to OUTFILE.VSAM setting it's first field as the key.

i'll appreaciate your suggestions guys...thanks.

expat · Posted: Fri Mar 23, 2007 3:03 pm Post subject:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DGT2I230/30.0?DT=20040628101835

Dead easy - there are manuals available with the manuals button at the top of this page[/url]

William Thompson · Posted: Fri Mar 23, 2007 3:04 pm Post subject:

Sort and idcams are two, maybe gener too.

timburkart · New User Joined: 17 Mar 2007 Posts: 30 Location: USA

You can code the JCL in a number of different ways but these are the logical steps.

1) Use SORT to sort the flat file by key
2) Use IDCAMS to define the new KSDS cluster
3) Load sorted file (#1) into VSAM file (#2).

regards,

tim

guptaa · New User Joined: 22 Feb 2007 Posts: 10 Location: pune

a sample code is as follows-

//REPRO EXEC PGM=IDCAMS
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSABOUT DD SYSOUT=*
//IN01 DD DSN=(Input flat file),DISP=SHR
//OUT01 DD DSN=(Output VSAM file name),DISP=OLD
//SYSIN DD *
REPRO INFILE(IN01) OUTFILE(OUT01) REPLACE
/*

if output VSAM file is not defined then you need to define it firsh