Create a table definition with the columns for which you want to create a schema file(Or import it from oracle). Open the layout tab in the table definition and click on the "parallel" radio button. This will give you the schema of that table definition. You can copy this and put in a text file to create a schema file.
you don't "Have" to write routines... Just proper use of the transformer (Stage variables and the "if... then... else..." statement in the derivations) can get what you want.
Amey Vaidya<i>
I am rarely happier than when spending an entire day programming my computer to perform automatically a task that it would otherwise take me a good ten seconds to do by hand.</i>
<i>- Douglas Adams</i>
i need to pickup this info and generate a ds schema file
can any one help with ideas/clues..
Thanks in adv.
Satish
Import table definition from Oracle.
Open table definition.
Go to Layout tab and choose Parallel option.
Right click in background area and save as schema file.
Voila!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
you don't "Have" to write routines... Just proper use of the transformer (Stage variables and the "if... then... else..." statement in the derivations) can get what you want.
Could anyone explain the steps involved in above
Hi Keshav
i wrote a VB macro to create a scema file for this type of requirement.
Could you post the VB code here and how to do the same in Transformer
Nothing shown in this thread is a DataStage schema file.
You can save schema files directly from the Table Definition record (in Manager or Designer in versions earlier than 8, in Designer in version 8 or later).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.