Neoview Workload Management Services Guide (R2.5)

HOLD
causes the query to be put in the holding state.
SQL_CMD "sql-string;"
causes the NDCS server to execute an SQL command (or a series of SQL commands)
before executing the query.
“sql-string;”
is an SQL command string, which is issued when the rule evaluates to true. You must
enclose the SQL string in double quotes. The combined length for the command string
must not exceed 1024 bytes. Separate each command with a semicolon (;). The last
command must always end with a semicolon. The string can contain multibyte
characters. For information on using multibyte character sets, see the Neoview Character
Sets Administrator's Guide.
NO-ACTION
removes an existing action from the rule.
rule-comment
is optional text that you can specify to describe the rule you are creating. comment-string
cannot exceed 256 characters. You must delimit the comment in double quotes.
Considerations
If you specify NO-WARN, you must specify a rule-action.
CAUTION: When altering an attribute of a compilation rule, you must also specify any existing
attributes in the ALTER RULE COMP command. Otherwise, the ALTER RULE COMP command
deletes the existing attributes.
Example
This command alters the compilation rule, COMPRULE1, so that the estimated used rows must
be greater than or equal to 50,000 rows for the rule to evaluate to true:
ALTER RULE COMP COMPRULE1 (EST_USED_ROWS >= 50000, WARN-HIGH, REJECT);
ALTER RULE COMP Command 191