What is the quickest way to obtain a schema file definition given a table definition from DataStage Repository using command line interface?
Thanks.
Table Definition -> Schema File
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.