Import a table definition using a command line utility

Umbix62 · Post by **Umbix62** » Tue Dec 05, 2006 4:09 am

Good morning

I'm looking for a method to import a table def using an external utility to run in the command line as, for example, dsojob. May I do that?

Thank you very much

Umberto

ArndW · Post by **ArndW** » Tue Dec 05, 2006 5:15 am

Umberto - you are out of luck, such a tool doesn't exist

Umbix62 · Post by **Umbix62** » Tue Dec 05, 2006 5:27 am

ArndW wrote:Umberto - you are out of luck, such a tool doesn't exist ...

Ok, I have supposed it. Is it possible via API?

ray.wurlod · Post by **ray.wurlod** » Tue Dec 05, 2006 5:29 am

Are you looking for a mainframe command line utility, or a server command line utility? The latter does not exist. I suspect there's not going to be one on the mainframe either, as there really isn't the same concept of a command line, but generating the COBOL FD or DCLGen is definitely possible. But that doesn't get it in to your DataStage Repository.

kduke · Post by **kduke** » Tue Dec 05, 2006 6:39 am

There is a import command which will import any DSX file. The dsimport.exe command will do the trick. You need to be able to create a DSX file. I am not sure it can import XML files but I would try it if I was you. Ray posted the program to create XML files from DS_METADATA the internal table of DataStage. You might be able to write your own if you really need this concept.