The following input parameters are common to most of the WhereScape RED Callable Routines, which are primarily used for integration with the WhereScape RED Scheduler.

Input

Parameter Name

Description

Job Instance Identifier

p_sequence

Unique identifier of the running job (i.e. the running instance of a held or scheduled 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, then any integer value can be used.

Job Name

p_job_name

Name of the 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, then any name can be used.

Task Name

p_task_name

Name 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, then any name can be used.

Job Identifier

p_job_id

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 Identifier        

p_task_id

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 is recommended to use 0 (zero).

Note

Typically, the parameter names of the WhereScape RED Callable Routines use a p_ prefix as indicated but in some routines a v_ prefix is used instead. In addition, for SQL Server; all parameter names are also prefixed by an @ sign. The RDBMSspecific parameter names are included in the subsequent details of each Callable Routine.


  • No labels