DB2 Load Ready Flat file stage

srikie · Post by **srikie** » Thu Jan 20, 2005 10:28 am

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

Mike · Post by **Mike** » Thu Jan 20, 2005 12:01 pm

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

srikie · Post by **srikie** » Thu Jan 20, 2005 1:22 pm

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

Mike · Post by **Mike** » Thu Jan 20, 2005 1:35 pm

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