DSXchange

Well thanks for very informative response but can you also tell me why do they use the 9's complement version for the date in mainframes and also what does '8764' mean i mean does that mean 87 year and 64 something in this example. Sorry to bother you with such basic questions but I am a rookie so.....

Hi,
Can any one throw some light on 9's complement date transformations, so as to what it is and why it is necessary and also can some one give me links to material which explains what level 88 and all those levels in the cobol copy book mean.
I am using Data Stage MVS.
Thanks
Srikie

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

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 alte...

Hi Mike and Peter, Thanks and I think now I have an idea about how it goes. Your suggestion have been very valuable to me. Yeah, I am doing your way peter so even I will be joining the crazy ppl :wink: . We first load into flat files and then load into db2.If there any more questions regarding this ...

Hi Mike,
I want to know the other alternatives for the look up.
Thanks
Srikanth

Hi peternolan9 , Even I thought so. But there should still be the way to atleast put the checkpoints cause it is the most important thing in whatever datastage version you are working for. I am not very particular about mvs I just want to know if it has it or not. Cause I think if there is any facil...

Hi Mike, Can you please elaborate a little more on how "saving status information" is acheived. Yeh I work with lot of VSAM source files but I beleive my work would exclusively contain db2 as target not as source. And regarding the look ups am still not sure about it. I also want to know h...

Hi Mike,
Thanks for fast reply. My source is VSAM files and source is db2.
I just want to know few mechanisms which datastage provides. and the
data volume is about 200 gig.
Thanks

Hi,
Is there anyway we could put check point for data bulk/incremental loading

Hi, Can any one please tell about about features what Ascential Data Stage MVS provides that can help with the following for very large data loads that will require initial loads plus incremental updates: Describe the checkpoint/restart safeguards we are putting place in the conversion that will ens...

Can any one please tell me the differences between the various versions of datastage.
Thanks,
Srikanth