GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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