Synopsis
Updates row counts for a task in the Task Log.
Description
Updates row counts for the specified task in the Task Log. Task Log messages (and row counts) are accessible via the "Scheduler" tab/window and/or the WS_ADMIN_V_TASK view of the WS_WRK_TASK_RUN and WS_WRK_TASK_LOG tables.
This routine is intended to be executed by a task of a job since it requires a valid job, task, and job sequence number that are provided by a WhereScape RED Scheduler.
Input
Input | Description |
---|---|
Common Input | Includes 3 inputs of the Callable Routines Common Input. |
Inserted Row Count | The number of rows inserted by the task. |
Updated Row Count | The number of rows updated by the task. |
Replaced Row Count | The number of rows replaced by the task. |
Deleted Row Count | The number of rows deleted by the task. |
Discarded Row Count | The number of rows discarded by the task. |
Rejected Row Count | The number of rows rejected by the task. |
Error Row Count | The number of rows with an error that were failed by the task. |
Output
Output | Description |
---|---|
Result Number | Output Result Number:
|
SQL Server
SQL Server Parameters: WsWrkTask
Callable Routine Type: PROCEDURE.
Parameter Name | Datatype | Mode |
---|---|---|
@p_job_key | INTEGER | IN |
@p_task_key | INTEGER | IN |
@p_sequence | INTEGER | IN |
@p_inserted | INTEGER | IN |
@p_updated | INTEGER | IN |
@p_replaced | INTEGER | IN |
@p_deleted | INTEGER | IN |
@p_discarded | INTEGER | IN |
@p_rejected | INTEGER | IN |
@p_errored | INTEGER | IN |
SQL Server Examples: WsWrkTask
– The p_ VARIABLES are normally PARAMETERS in a RED-generated Procedure. DECLARE @p_sequence integer DECLARE @p_job_name varchar(256) DECLARE @p_task_name varchar(256) DECLARE @p_job_id integer DECLARE @p_task_id integer DECLARE @p_return_msg varchar(256) DECLARE @p_status integer DECLARE @v_result_num integer EXEC WsWrkTask @p_job_id, @p_task_id, @p_sequence , 27, 30, 0, 0, 0, 0, 0
Teradata
Teradata Parameters: WsWrkTask
Callable Routine Type: PROCEDURE.
Parameter Name | Datatype | Mode |
---|---|---|
p_job_key | INTEGER | IN |
p_task_key | INTEGER | IN |
p_sequence | INTEGER | IN |
p_inserted | INTEGER | IN |
p_updated | INTEGER | IN |
p_replaced | INTEGER | IN |
p_deleted | INTEGER | IN |
p_discarded | INTEGER | IN |
p_rejected | INTEGER | IN |
p_errored | INTEGER | IN |
Teradata Examples: WsWrkTask
– The p_ VARIABLES are normally PARAMETERS in a RED-generated Procedure. DECLARE p_sequence integer; DECLARE p_job_name varchar(256); DECLARE p_task_name varchar(256); DECLARE p_job_id integer; DECLARE p_task_id integer; DECLARE p_return_msg varchar(256); DECLARE p_status integer; DECLARE v_insert_count integer; DECLARE v_update_count integer; CDATA[CALL [METABASE].WsWrkTask ( p_job_id, p_task_id, p_sequence , v_insert_count, v_update_count, 0, 0, 0, 0, 0 );
Oracle
Oracle Parameters: WsWrkTask
Callable Routine Type: FUNCTION.
Parameter Name | Datatype | Mode |
---|---|---|
v_job_key | NUMBER | IN |
v_task_key | NUMBER | IN |
v_sequence | NUMBER | IN |
v_inserted | NUMBER | IN |
v_updated | NUMBER | IN |
v_replaced | NUMBER | IN |
v_deleted | NUMBER | IN |
v_discarded | NUMBER | IN |
v_rejected | NUMBER | IN |
v_errored | NUMBER | IN |
FUNCTION Return Value | NUMBER | OUT-Function |
Oracle Examples: WsWrkTask
– The p_ VARIABLES are normally PARAMETERS in a RED-generated Procedure. p_sequence number; p_job_name varchar2(256); p_task_name varchar2(256); p_job_id number; p_task_id number; p_return_msg varchar2(256); p_status number; v_result_num number; v_insert_count number; v_update_count number; v_result_num := WsWrkTask ( p_job_id, p_task_id, p_sequence , v_insert_count, v_update_count, 0, 0, 0, 0, 0 );
DB2
DB2 Parameters: WsWrkTask
Callable Routine Type: PROCEDURE.
Parameter Name | Datatype | Mode |
---|---|---|
p_job_key | INTEGER | IN |
p_task_key | INTEGER | IN |
p_sequence | INTEGER | IN |
p_inserted | INTEGER | IN |
p_updated | INTEGER | IN |
p_replaced | INTEGER | IN |
p_deleted | INTEGER | IN |
p_discarded | INTEGER | IN |
p_rejected | INTEGER | IN |
p_errored | INTEGER | IN |
DB2 Examples: WsWrkTask
– The p_ VARIABLES are normally PARAMETERS in a RED-generated Procedure. DECLARE p_sequence integer; DECLARE p_job_name varchar(256); DECLARE p_task_name varchar(256); DECLARE p_job_id integer; DECLARE p_task_id integer; DECLARE p_return_msg varchar(256); DECLARE p_status integer; DECLARE v_insert_count integer; DECLARE v_update_count integer; CALL [METABASE].WsWrkTask ( p_job_id, p_task_id, p_sequence , v_insert_count, v_update_count, 0, 0, 0, 0, 0 );