Page 1 of 1
Import a table definition using a command line utility
Posted: Tue Dec 05, 2006 4:09 am
by Umbix62
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
Posted: Tue Dec 05, 2006 5:15 am
by ArndW
Umberto - you are out of luck, such a tool doesn't exist
Posted: Tue Dec 05, 2006 5:27 am
by Umbix62
ArndW wrote:Umberto - you are out of luck, such a tool doesn't exist ...
Ok, I have supposed it. Is it possible via API?
Posted: Tue Dec 05, 2006 5:29 am
by ray.wurlod
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.
Posted: Tue Dec 05, 2006 6:39 am
by kduke
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.