Hi
I need to pass the parameters for Datastage job (multiple instance)
For each instance the following set of parameters I need to pass to DS job
SourceFileName, SchemaFileName, TargetTableName, Invocation ID
File1.txt, File1.schema, Table1 , 1
File2.txt , File2.schema , Table2 , 2
Like this I need to pass the paramerts for 150 (Times) files to DS Job (Multiple Instance.
To pass the parameters should I use unix script, anyone can give me the script logic in detail.
How to read param values from a file and pass them to DS job .
I am new to Data warehouse environment
Thanks
Srini
Passing Parameters for Multiple instance DS job
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
-
- Participant
- Posts: 246
- Joined: Mon Jun 30, 2008 3:22 am
- Location: New York
- Contact:
We have a similar situation, and the control point for setting the parameters for each instance is a table. It can be set dynamically, in that the number of jobs executed is equal to the number of rows in the parameters table.
Franklin Evans
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
"Shared pain is lessened, shared joy increased. Thus do we refute entropy." -- Spider Robinson
Using mainframe data FAQ: viewtopic.php?t=143596 Using CFF FAQ: viewtopic.php?t=157872
-
- Premium Member
- Posts: 38
- Joined: Sat Dec 29, 2007 9:58 am
reading parameter values from table and passing them to job
Actually I need to read the parmeter values from a table and pass them to datastge job(Multiple instance).
If you have unix script to read params from table and passing the params ds job(multiple instance), can you let me konw the unix script.
please let me know the implementation steps of unix and Datastge job
Thanks
Srini
If you have unix script to read params from table and passing the params ds job(multiple instance), can you let me konw the unix script.
please let me know the implementation steps of unix and Datastge job
Thanks
Srini
You could use a parameterset, build your valueset dynamically from the table and then pass the name of the valueset to the job at runtime. The valueset is just a text file with records of the form:
parameter=value
Easy to create, easy to implement using many methods in and out of DataStage. Each instance would have a valueset created, and you can always remove it at end of job if you wish.
Regards,
parameter=value
Easy to create, easy to implement using many methods in and out of DataStage. Each instance would have a valueset created, and you can always remove it at end of job if you wish.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.