Using Data Stage Job Parameters,Using Data Stage After/before job routines,Data Stage Job Control Functions

To Define job parameters ,Specify before and after routines ,Use job control routines ,Create a job that controls other jobs. Job Parameters can be used and included in:

Passive stage file and table names

Passive stage directory paths

Account names for hashed files

Transformer stage derivations

Transformer stage constraints

Example for Defining Job Parameters:

Click Edit--->Job Properties ---->Select parameters tab ---->Type parameters

Example for using Parameters in Passive Stages:

Parameter Need pound (#) signs Using Job Parameters in Transformer stages: Parameters are Inserted from Operand menu Example for Running Jobs with Parameters: Enter values for parameters Before and After Routines Can be called:

• Run before or after a job
• Run before or after a transformer stage
• Built-in Before/After routines can used to call ExecDos , ExecShell ,ExecTCL
• Can define custom routines

Examplle for Using Before and After Routines in a job :

In this example dos command is called an its value is mentioned in Input value using job parameters. Job Control Functions can be used:

• Use to control jobs and obtain project and job information
• Can be executed In Job control tab of Job Properties window
• Can be executed Within DS routines
• Can be executed Within derivations
• DSAttachJob
• DSSetParam
• DSRunJob
• DSWaitForJob
• DSGetProjectInfo
• DSGetJobInfo
• DSLogInfo

Exampe for Creating a Controlling Job or calling a jb within a job: