DSXchange

What is the quickest way to obtain a schema file definition given a table definition from DataStage Repository using command line interface?

Thanks.

The quickest way will involve about a month's worth of research into the internal structure of the DS_METADATA table and how to translate this into a schema.

You really don't want to do it from the command line. (I'm not asking.)

Much easier is to look at the table definition using the Manager or the Repository view in Designer. Go to the layout tab and you can view the table definition in "standard" (SQL) format, COBOL format or schema format.

After all, you are looking at the same metadata; the tool simply presents it in different ways.

Copy and paste the schema definition.