Synopsis
Returns the value and comment (for most RDBMS) of a WhereScape RED metadata Parameter.
Description
Returns the value and comment (for most RDBMS) of the specified parameter from the DSS_PARAMETER metadata table. For SQL Server, Teradata, and DB2 this routine is a PROCEDURE that returns both the parameter value and comment.
Typically, this routine is used by procedures to read information that is written by another process (automatically or manually via the RED Tools > Parameters menu item), which is external to the procedure.
Input
Input | Description |
|---|---|
Parameter Name | The case-sensitive name of the WhereScape RED metadata parameter to be retrieved. The name must exactly match an existing parameter, otherwise a NULL value is returned. |
Output
Output | Description |
|---|---|
Parameter Value | The retrieved value of the parameter. Corresponds to the "Value" property that is visible and maintainable via Tools > Parameters. |
Parameter Comments | The maximum number of versions to retain for each object. If 5 is specified then the last 5 versions are retained per object regardless of the specified maximum age to retain. |