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:

  • 0   Success.
  • -1  Warning.
  • -3  Fatal/Unexpected Error.

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
);


  • No labels