DSXchange

HI All, I want to make one program that can transfer the simple ETL requirement( represented by a flat file ) to a parallel job( Edition 7.5.1 ) automatically( represented by a XML or .dsx file ). Then the XML file can be imported into datastage by manager application.

Could any guys give me some advice? who can give me the document about the job xml representation or URL where I can download?

Thanks in advance.

Wow... this is not a minor task you are attempting to undertake, especially for someone that ranks themselves 'new to the product'.

There's no document or URL for anything like this, so what you'd need to do is export some simple jobs from the Manager to dsx or xml format and start from there. Learn the format and then decide if it's really something you want to tackle.

If it helps, this can be done and I know at least one person who has done something like this for Server jobs - take a template job and build metadata-driven versions of it. And just so you know there is a product in the suite that IBM sells that does this - it's called FastTrack and you should be able to find information on it by Googling or by searching here for posts by Vincent McBurney on the subject.

I have done something like this in both server and PX. The best you can probably do is create one job as a template. Look at the XML file or the DSX. What I did was cut out the parts of the DSX file I did not need any more and replace it with the new table's information like column names.

OK, make that two people.