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.
|
Job Name | p_job_name | Name of the running job that executed the routine.
|
Task Name | p_task_name | Name of the running task (of a running job) that executed the routine.
|
Job Identifier | p_job_id | Unique identifier of the held or scheduled job that the running job is a specific instance of.
|
Task Identifier | p_task_id | Unique identifier of the running task (of a running job) that executed the routine.
|
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.