Use a job parameter to pass metatdata to a job
Moderators: chulett, rschirm, roy
Use a job parameter to pass metatdata to a job
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.
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,
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.
All generalizations are false, including this one - Mark Twain.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.