Synopsis
Records a message in the Error/Detail Log.
Description
Adds the specified message to the WS_WRK_ERROR_LOG workflow metadata table, which is referred to as the Error Log or Detail Log. A variety of message types are supported such as Information, Warning, and Error that are included in the "detail" message counts for the task and job (viewable via the "Scheduler" tab/window). Error/Detail Log messages are accessible via the "Scheduler" tab/window and/or the WS_WRK_ERROR_LOG table.
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. |
Error/Detail Message Type Code | Error/Detail Message Type Code:
|
Error/Detail Message Text | Custom message text to be recorded in the WhereScape RED Error/Detail Log. |
RDBMS Code | RDBMS-specific message code. It is optional but recommended to populate this when an error occurs. |
RDBMS Message | RDBMS-specific message. It is optional but recommended to populate this when an error occurs. |
Custom Message Type Code | Custom Message Type Code. For custom usage and has no meaning within the WhereScape RED metadata. |
Output
Output | Description |
|---|---|
Result Number | Output Result Number:
|