Difference between a .dsx file and .xml file

Svengiyil · Post by **Svengiyil** » Mon Jul 20, 2009 11:52 pm

Hi,

I'm quite new to datastage and i work on server jobs,
I want to know the difference between the options on the files we have , that is .dsx file and .xml file that gets created during job export?

Thanks,
Svengiyil

fareeda_b · Post by **fareeda_b** » Tue Jul 21, 2009 12:07 am

Hi ,
viewtopic.php?t=117993&highlight=.dsx+and+.xml

ray.wurlod · Post by **ray.wurlod** » Tue Jul 21, 2009 12:07 am

There is no difference whatsoever in terms of the information stored within them. It's purely a formatting difference.

Some commands, such as dsjob -import or dsimport, (available in version 8 only) can only use DSX format files. There exists a conversion utility called xml2dsx to convert XML format export files into DSX format.

Svengiyil · Post by **Svengiyil** » Tue Jul 21, 2009 2:24 am

Thanks for all the reply,

Is there any scenario where using .xml file is a must?

ArndW · Post by **ArndW** » Tue Jul 21, 2009 3:01 am

I cannot think of such a scenario. The .xml format was most likely implemented so that DataStage could boast being "open" and that it uses a common interchangeable format.

chulett · Post by **chulett** » Tue Jul 21, 2009 5:19 am

There is an extra step needed when importing a .xml export file, it will first be converted to .dsx 'under the covers' automatically and then imported. This conversion can be... lengthy. FYI.

Svengiyil · Post by **Svengiyil** » Tue Jul 21, 2009 11:39 pm

Thanks again for all the info..