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
DB2 Load Ready Flat file stage
Moderators: chulett, rschirm, roy
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
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