Synopsis
Returns the value of a "global" WhereScape RED metadata Parameter that relates to a load table.
Description
Returns the value of an internal parameter that is defined and populated by WhereScape RED, which is available to a procedure that is currently processing a load table.
The supported parameters are $$TABLE_NAME and $$SOURCE_TABLE.
Input

Input

Description

Global Parameter Name

The supported global parameters are:

  • $$TABLE_NAME returns the Load Table Name that the procedure is executing against. Only available for load tables.
  • $$SOURCE_TABLE returns the maximum value of the Source Table property from the columns of the Load Table that the procedure is executing against. Only available for load tables.

Typically, a Load Table has a single Source Table but if it has multiple sources then the maximum (alphabetically) Source Table Name will be returned.


Job Identifier

Unique identifier of the held or scheduled job that the running job is a specific instance of. When invoked from a WhereScape RED Scheduler the routine will be passed the parameter argument. When invoked manually or externally to the WhereScape RED Scheduler, it is recommended to use 0 (zero).

Task or Object Identifier

Unique identifier of the running task (of a running job) that executed the routine. When invoked from a WhereScape RED Scheduler the routine will be passed the parameter argument. When invoked manually or externally to the WhereScape RED Scheduler, it should be the object key.

Output

Output

Description

Result Table Name

The requested Load Table Name or Source Table Name.


  • No labels