The AM_BASE_RPT_RECOMS table function returns recommendations
for activity reports used by the activity monitor.
Syntax
>>-AM_BASE_RPT_RECOMS--(--report_id--,--client_locale--)-------><
The schema is SYSPROC.
Table function parameters
- report_id
- An input argument of type INTEGER that specifies a report ID.
If the argument is null, recommendations for all available reports
are returned.
- client_locale
- An input argument of type VARCHAR(33) that specifies a client
language identifier. If the argument is null or an empty string, the
default value is 'En_US' (English). If the message files for the specified
locale are not available on the server, 'En_US' is used.
Authorization
EXECUTE privilege on the
AM_BASE_RPT_RECOMS table function.
Examples
Example 1: Request recommendations
(in English) for the activity monitor report with an ID of 1. Assume
the default client language identifier 'En_US'.
SELECT *
FROM TABLE(SYSPROC.AM_BASE_RPT_RECOMS(1, CAST(NULL AS VARCHAR(33))))
AS RECOMS
Example 2: Request recommendations
(in French) for the activity monitor report with an ID of 12.
SELECT *
FROM TABLE(SYSPROC.AM_BASE_RPT_RECOMS(12, CAST('Fr_FR' AS VARCHAR(33))))
AS RECOMS
Information returned
Table 1. Information
returned by the AM_BASE_RPT_RECOMS table functionColumn name |
Data type |
Description |
REPORT_ID |
INTEGER |
The report ID. |
RECOM_NAME |
VARCHAR(256) |
The name or short description of the recommendation. |
RECOM_DESCRIPTION |
CLOB(32K) |
The detailed description of the recommendation. |