Use a job parameter to pass metatdata to a job

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Marley777
Premium Member
Premium Member
Posts: 316
Joined: Tue Jan 27, 2004 3:26 pm

Use a job parameter to pass metatdata to a job

Post by Marley777 »

Hi, is it possible to pass different metadata definitions to the same generic job? RCP doesn't work for what we are trying to do. We want to use one job to load many tables. Want to pass everything the job needs by using job parameters.
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

You cannot pass the metadata that would be present within the column grid definitions in your input and output links, or transformer derivations, or items that are generally" non-parameterizable".

Things you can pass: Filter Stage Statements or portions thereof, modify stage logic, filenames, db connection information, SQL statements, schema filenames, sort/join/merge key columns, external filter/source/target names

Why won't RCP work for you? Be specific...maybe there's something that can be done.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

We don't know what you're trying to do, and therefore can not challenge your assertion about RCP.

I recently have had good success generating SQL dynamically based on reading metadata from the system tables and passing the SQL statements as job parameters. But this used RCP.

Even if you use the Schema File property with Sequential File stage, RCP must be enabled.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply