Import multiple table definitions using orchdbutil

kiranh_1214 · Post by **kiranh_1214** » Tue Dec 29, 2015 5:52 am

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.

kduke · Post by **kduke** » Wed Dec 30, 2015 11:50 am

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.

chulett · Post by **chulett** » Wed Dec 30, 2015 12:16 pm

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

kduke · Post by **kduke** » Fri Jan 01, 2016 2:41 pm

That is the one. Nice work Craig.