Option

The valid global parameters are:

$$TABLE_NAME which returns the table name that this procedure is being execute against. This parameter is only available for load tables.

$$SOURCE_TABLE which returns the maximum value in the source_table field of the column properties for the specified tale. This parameter is only available for load tables.

Job id

Integer key of the job, when running under the scheduler. If being executed manually, then this key should be set to zero (0). If under scheduler control, then the procedure will have been passed the job id parameter.

Task Id

Integer key of the task, when running under the scheduler. If being executed manually, then this key should be set to the object key. If under scheduler control, then the procedure will have been passed the task id parameter.