Importing table definitions from a data set in command line

[rosecity]

Hello,

I was wondering if it is possible to import a table definition from a data set from the command line, either through Orchestrate Schema Definitions or any other approach.

I believe orchdbutil only works with databases and not data sets.

Thank you.

[asorrell]

orchadmin...

https://www.ibm.com/developerworks/comm ... ge?lang=en

Check out #4... the -s option is what I think you need.

[ray.wurlod]

I don't often disagree with Andy, but this time alas I do. He's correct to say that orchadmin -s will display the schema of the Data Set, but incorrect to assume that it will create a DataStage table definition from that schema.

I'm not aware of any command line mechanism for doing this.

[rosecity]

Thank you for the help. The only solution I can think of would be to create a script which does the following:

1) Call orchadmin -s to output data set schema
2) Convert the output to .dsx format
3) Import from .dsx file