Friday, August 23, 2013
DataStage BASIC functions
These functions can be used in a job control routine, which is defined as part of a jobs properties and allows other jobs to be run and controlled from the first job. Some of the functions can also be used for getting status information on the current job; these are useful in active stage expressions and before- and after-stage subroutines.
Specify the job you want to control
Set parameters for the job you want to control
Set limits for the job you want to control
Request that a job is run
Wait for a called job to finish
Gets the meta data details for the specified link
Get information about the current project
Get buffer size and timeout value for an IPC or Web Service stage
Get information about the controlled job or current job
Get information about the meta bag properties associated with the named job
Get information about a stage in the controlled job or current job
Get the names of the links attached to the specified stage
Get a list of stages of a particular type in a job.
Get information about the types of stage in a job.
Get information about a link in a controlled job or current job
Get information about a controlled jobs parameters
Get the log event from the job log
Get a number of log events on the specified subject from the job log
Get the newest log event, of a specified type, from the job log
Log an event to the job log of a different job
Stop a controlled job
Return a job handle previously obtained from DSAttachJob
Log a fatal error message in a job's log file and aborts the job.
Log an information message in a job's log file.
Put an info message in the job log of a job controlling current job.
Log a warning message in a job's log file.
Generate a string describing the complete status of a valid attached job.
Insert arguments into the message template.
Ensure a job is in the correct state to be run or validated.
Interface to system send mail facility.
Log a warning message to a job log file.
Convert a job control status or error code into an explanatory text message.
Suspend a job until a named file either exists or does not exist.
Checks if a BASIC routine is cataloged, either in VOC as a callable item, or in the catalog space.
Execute a DOS or Data Stage Engine command from a before/after subroutine.
Set a status message for a job to return as a termination message when it finishes