DSXchange

HI Team,

Requirement: Need to import table definitions of multiple tables and then convert the table definitions into xml.

Existing way which we are doing: we are using the Import>>>Table Definitions>>ODBC to import the table definitions.

Then we are exporting the same table definition and saving it on our local machine as .xml then moving it to our UNIX path.

I wanted to automate this process.

I have used orchdbutil which is printing the table definitions on the screen.
Not sure how to save the output of the orchdbutil command as an object in DataStage repository.

I tried saving the file as .isx and tried to import but in vain.

Please request you to guide me.

Why not take a full export which I assume you do nightly and use the Perl script to cut exports into files and modify it to do table definitions. Do a search for it.It cuts out jobs into one dsx per job. I am sure you can get what you need this way.

Assuming this post is the one: viewtopic.php?t=113429

That is the one. Nice work Craig.