DSXchange

I'm trying to use datastage to load to a warehouse. I have successfully loaded a partial file. When I try to load the full file which has spaces for DOB for some records, the job aborts. How do I specify in the schemafile to allow spaces for dates(not null - I tried nullable date)

I am using datastage in an ETL environment. I have written a master sequence that is triggered by a Trigfile. Each file that I receive from a vendor is deposited into their own directory. This tells me which vendor sent a file. I use the directory name(same as the vendor name) to call a job from my ...

I would appreciate looking at your routine.
Thanks
George

We are using datastage as an ETL tool. We have both server and parallel jobs. We use server because we could write a function to translate the Cobol over/under punches. We want to use the DSJOB report to generate an XML file that we can put job statistics into an Audit table. This, we have working f...