how to convert a flat file to a ksds vsam file

j_rymbei · Posted: Wed Feb 14, 2007 5:33 pm

Hi,
How to convert a flat file to a vsam file without using define cluster commands.

prav_06 · Posted: Wed Feb 14, 2007 5:48 pm

j_rymbei,
I don't think there is any utility that would convert a flat file to KSDS, instead create a KSDS vsam file and then REPRO the flat file data to the created KSDS file. This would surely work

Cheer's,

Thamilzan.

William Thompson · Posted: Wed Feb 14, 2007 8:46 pm

Check the JCL manual, I faintly recall that all needed vsam info is possible there.

j_rymbei · Posted: Thu Feb 15, 2007 6:54 pm

Check this out. It will work only if SMS is active in your profile or system..

//VKSDS1 DD DSN=DAVE.CUST.MASTER,DISP=(,CATLG,DELETE),
// SPACE=(CYL,(10,10)),LRECL=100,KEYOFF=10,
// KEYLEN=12,RECORG=KS
//*
//VKSDS2 DD DSN=&LEVEL.CUST.ADDR,DISP=(,CATLG,DELETE),
// SPACE=(TRK,(5,10)),LRECL=55,KEYOFF=0,
// KEYLEN=12,RECORG=KS,DATACLAS=VSDEF

KEYOFF specifies the offset of the key field, while KEYLEN specifies the length of the key field. These two statements take the place of the KEYS parameter in the IDCAMS DEFINE statement. (Don't forget that the key offset starts at position 0)

RECORG is used to specify the type of VSAM dataset, for example RECORG=KS would specify a Key Sequenced Data Set (KSDS). Valid values are KS (for Key sequenced datasets), ES (for Entry Sequenced Datasets), RR (for relative record datasets) and LS (for VSAM linear space datasets).
If you do not specify a volume (UNIT and VOL parameters) where the dataset is to be kept then SMS will automatically select a volume.

For all the other parameters required on an IDCAMS DEFINE, default values will be assumed, unless you specify a DATACLAS parameter which can be used to point to a data class containing default values for RETPD, volume count, IMBED, REPLICATE, CISIZE, FREESPACE and SHAREOPTIONS. If you specify a DATACLAS and, say, a UNIT and VOL parameters then the UNIT/VOL will override the defaults in the DATACLAS.

You also specify the space to be allocated for the VSAM cluster using the SPACE parameter as you would for any non-VSAM file. If you code RLSE then this will be ignored. CONTIG or ROUND will cause a JCL error.

On the DSN parameter you can only code the name of the dataset, you cannot specify the names of any data or index components. Any data or index components will be created as the dataset name plus either .DATA or .INDEX

William Thompson · Posted: Thu Feb 15, 2007 7:00 pm

Thanks, I knew I saw it somewhere...BTW, Which manual did you find it in, the JCL Language Reference?

Bitneuker · Posted: Thu Feb 15, 2007 7:34 pm

Bill, page 38 shows: