DSXchange

Hi,
I am trying to convert VSAM files to flat files and then flat files to db2 tables. Can I used DB2 Load Ready FLat file stage for this?
If so I wanna know if it is an active stage or passive stage?
If I cannot use this for VSAM-> Flat file converison then can you please suggest me some other alternatives.
Thanks
srikie

Hello again,

You'll find that a DB2 Load Ready Flat File is really just a Fixed-width Flat File with a few extra features to make the DB2 load easier to develop.

Some of the features when you use the DB2 Load Ready Flat File:
1) DataStage will generate the load control cards and the load JCL as part of the execution JCL.
2) DataStage will automatically create and populate a 1-byte null indicator column for each table column that allows NULL.

Mike

So what would be the best way to convert is it complex flat->transformer->db2loadready.??

If you're going to use the DB2 load utility, then yes.