DSXchange

Hi all,

How to generate schema file definition from oracle tables?.

for ex: i have table with table field information

ie., table_name field start_lenght end_lenght
t1 col1 1 4
t1 col2 5 10
t2 col1 1 2

i need to pickup this info and generate a ds schema file

can any one help with ideas/clues..

Thanks in adv.
Satish

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.

Hi Minhajuddin,

table name, column name and its lenght are stored in oracle table
i need to dynamically generate the schema file.

table_name field start_lenght end_lenght
t1 col1 1 4
t1 col2 5 10
t2 col1 1 2

Any idea?

i wrote a VB macro to create a scema file for this type of requirement.

cool,

Can we do something within ds?

-Satish

yes, you can write similar code in a trasformer(may be in a routine) stage

ds routines?
this is painful

Well,

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.

getsatish_gk wrote:Hi all,

How to generate schema file definition from oracle tables?.

for ex: i have table with table field information

ie., table_name field start_lenght end_lenght
t1 col1 1 4
t1 col2 5 10
t2 col1 1 2

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!

Hi,

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).