WhereScape RED callable routines provide an Application Program Interface (API) to the WhereScape RED metadata using the following SQL-invoked routines:
Routine Name | Description |
|---|---|
Adds an entry to the documentation glossary. | |
Replaces the contents of a connection with details from another connection. | |
Aborts a job if it is in a running state. | |
Purges archived job logs that are older than the specified age in days. | |
Archives job logs when the maximum number of current logs to retain is exceeded. | |
Archives job logs that are older than the specified age in days. | |
Creates a job based on an existing job and optionally starts it immediately. | |
Creates a job based on an existing job and schedules it to start later. | |
Adds or removes a child-to-parent dependency between two jobs to control the child job. | |
Starts a job if it is a holding or waiting state. | |
Starts a job if it is in a failed state. | |
Schedules a job if it is in a holding or waiting state. | |
Returns the current status of a job. | |
Changes the Connection or Schema of a load table. | |
Drops and/or builds database indexes that are defines in the WhereScape RED metadata. | |
Purges metadata versions for all objects that do not meet the specified retention criteria. | |
Returns the value and comment (for most RDBMS) of a WhereScape RED metadata Parameter. | |
| Returns the value of a WhereScape RED metadata Parameter. [SQL Server only] | |
Returns the value of a "global" WhereScape RED metadata Parameter that relates to a load table. | |
Updates the value and comment of a WhereScape RED metadata Parameter or creates it. | |
Records a message in the Audit Log. | |
Records multiple messages in the Audit Log. | |
Records a message in the Error/Detail Log. | |
Records multiple messages in the Error/Detail Log. | |
Updates row counts for a task in the Task Log. |