| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: How do you pass the parameter to the job sequence if the job is running at night?
|
| May 05, 2007 12:09:26 |
#2 |
| gagan8877 |
Member Since: May 2007 Total Comments: 8 |
RE: How do you pass the parameter to the job sequence ... |
You can insert the parameter values in a table and read them when the package runs using ODBC Stage or Plug-In stage and use DS variables to assign them in the data pipeline, or pass the parameters using DSSetParam from the controling job (batch job or job sequence) or Job Control Routine from with DS or use dsjob -param from within a shell script or a dos batch file when running from CLI. |
| |
Back To Question | |