Synopsis
Records multiple messages in the Audit Log.
Description
Adds the specified multiple messages to the WS_WRK_AUDIT_LOG workflow metadata table, which is referred to as the Audit Log or Audit Trail. A variety of message types are supported, such as Information, Warning, and Error that are included in the corresponding message type counts for the task and job. Audit Log messages are accessible via the "Scheduler" tab/window and/or the WS_ADMIN_V_AUDIT view of the WS_WRK_AUDIT_LOG table.
Note
Both the Audit Log and Error/Detail Log support similar information and in user-defined custom procedures, either or both logs can be used. However, in RED-generated procedures/scripts, the Audit Log is used for higher-level or summary messages while the Error/Detail Log is used for more detailed supporting information.
Input
Input | Description |
---|---|
Common Input | Includes all 5 inputs of the Callable Routines Common Input. Note Refer to the RDBMS-specific parameters for the relative positions (they are NOT declared as the first parameters). |
Audit Message Type Code | Audit Message Type Code:
|
Audit Message(s) Text | Custom message(s) text to be recorded in the WhereScape RED Audit Log. Multiple messages can be specified but each is limited to 256 characters. Each message must be separated by either a new-line (ASCII 10) or tilde (~) character. e.g. Message1~Message2~Message3 will create 3 messages. |
RDBMS Code | RDBMS-specific message code. e.g. The Oracle special variable SQLCODE. It is optional but recommended to populate this when an error occurs. |
RDBMS Message | RDBMS-specific message. e.g. The Oracle special variable SQLERRM. It is optional but recommended to populate this when an error occurs. |
Output
Output | Description |
---|---|
Result Number | Note Not provided for all RDBMS. Output Result Number:
|
SQL Server
SQL Server Parameters: WsWrkAuditBulk
Callable Routine Type: PROCEDURE.
Parameter Name | Datatype | Mode |
---|---|---|
@p_status_code | VARCHAR(1) | IN |
@p_job_name | VARCHAR(64) | IN |
@p_task_name | VARCHAR(64) | IN |
@p_sequence | INTEGER | IN |
@p_message | VARCHAR(4000) | IN |
@p_db_code | VARCHAR(10) | IN |
@p_db_msg | VARCHAR(256) | IN |
@p_task_key | INTEGER | IN |
@p_job_key | INTEGER | IN |
SQL Server Examples: WsWrkAuditBulk
– 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 @v_result_num = WsWrkAuditBulk 'I', @p_job_name, @p_task_name, @p_sequence , 'Message1~Message2~Message3' , NULL , NULL , @p_job_id , @p_task_id
Teradata
Teradata Parameters: WsWrkAuditBulk
Callable Routine Type: PROCEDURE.
Parameter Name | Datatype | Mode |
---|---|---|
p_status_code | VARCHAR(64) | IN |
p_job_name | VARCHAR(64) | IN |
p_task_name | VARCHAR(64) | IN |
p_sequence | INTEGER | IN |
p_message | VARCHAR(61440) | IN |
p_db_code | VARCHAR(10) | IN |
p_db_msg | VARCHAR(256) | IN |
p_job_id | INTEGER | IN |
p_task_id | INTEGER | IN |
p_result | INTEGER | OUT |
Teradata Examples: WsWrkAuditBulk
– 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; CALL [METABASE].WsWrkAuditBulk ( 'I', p_job_name, p_task_name, p_sequence , 'Message1~Message2~Message3' , NULL , NULL , p_job_id --### NOTE order. , p_task_id --### NOTE order. , v_result_num );
Oracle
Oracle Parameters: WsWrkAuditBulk
Callable Routine Type: FUNCTION.
Parameter Name | Datatype | Mode |
---|---|---|
v_status_code | VARCHAR2 | IN |
v_job_name | VARCHAR2 | IN |
v_task_name | VARCHAR2 | IN |
v_sequence | NUMBER | IN |
v_message | VARCHAR2 | IN |
v_db_code | VARCHAR2 | IN |
v_db_msg | VARCHAR2 | IN |
v_task_key | NUMBER | IN |
v_job_key | NUMBER | IN |
FUNCTION Return Value | NUMBER | OUT-Function |
Oracle Examples: WsWrkAuditBulk
– 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_result_num := WsWrkAuditBulk ( 'I', p_job_name, p_task_name, p_sequence , 'Message1~Message2~Message3' , NULL , NULL , p_task_id , p_job_id );
DB2
DB2 Parameters: WsWrkAuditBulk
Callable Routine Type: PROCEDURE.
Parameter Name | Datatype | Mode |
---|---|---|
p_status_code | VARCHAR(64) | IN |
p_job_name | VARCHAR(64) | IN |
p_task_name | VARCHAR(64) | IN |
p_sequence | INTEGER | IN |
p_message | VARCHAR(32672) | IN |
p_db_code | VARCHAR(10) | IN |
p_db_msg | VARCHAR(256) | IN |
p_job_id | INTEGER | IN |
p_task_id | INTEGER | IN |
p_result | INTEGER | OUT |
DB2 Examples: WsWrkAuditBulk
– 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; CALL [METABASE].WsWrkAuditBulk ( 'I', p_job_name, p_task_name, p_sequence , 'Message1~Message2~Message3' , NULL , NULL , p_job_id --### NOTE order. , p_task_id --### NOTE order. , v_result_num );