Retrieving Metadata dynamically at run time

Pavan78 · Post by **Pavan78** » Wed Feb 15, 2006 6:37 am

Hi,

I need to create a generic job which will create metadata for different tables at run time.

My source is DB2 and I need to create table definitions at run time for different tables at run time.

Please let me know how can this be accomplished.

Regards,
- Pavan

ray.wurlod · Post by **ray.wurlod** » Wed Feb 15, 2006 3:36 pm

That's a very easy one. It can't be done with this tool. DataStage is driven by the metadata, not the reverse. Some people elect to create a "generic table definition" with more than enough VarChar columns, but it's not really a satisfactory solution.

Pavan78 · Post by **Pavan78** » Wed Feb 15, 2006 11:37 pm

ray.wurlod wrote:That's a very easy one. It can't be done with this tool. DataStage is driven by the metadata, not the reverse. Some people elect to create a "generic table definition" with more than enough VarChar columns, but it's not really a satisfactory solution.

Hi Ray,

So whats the best approach, I need to create a generic job which will extract metadata for more than 40 tables.

Regards,
- Pavan

ray.wurlod · Post by **ray.wurlod** » Wed Feb 15, 2006 11:48 pm

Write it yourself in C or shell script. It can't be done with DataStage.

bhargava129189 · Post by **bhargava129189** » Tue Feb 21, 2006 6:43 am

Ray how do i create the unix script. do you mean we can pass metadata for a job using shell script please elaborate.

kumar_s · Post by **kumar_s** » Tue Feb 21, 2006 7:33 am

bhargava129189 wrote:Ray how do i create the unix script. do you mean we can pass metadata for a job using shell script please elaborate.

Hi
Welcome Aboard :D

Once the metadate been created using scripts, Scheme file option can be utilized (The option available in Sequential stage) to accomplish the task.
But for DB2 stage

Iam not sure about the dynamic metadata allocation.

ray.wurlod · Post by **ray.wurlod** » Tue Feb 21, 2006 5:43 pm

bhargava129189 wrote:Ray how do i create the unix script. do you mean we can pass metadata for a job using shell script please elaborate.

You create the script with a text editor. How you get and handle the metadata is up to you. "Dynamic metadata" can not be done in DataStage. This is not a forum for solving non-DataStage problems.