Neoview Workload Management Services Guide (R2.4)

HOLD
causes the query to be put in the holding state.
EXEC "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. 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.
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.
Examples
• This command changes the number of estimated access rows for the compilation rule named
COMPRULE50.
ALTER RULE COMP COMPRULE50 (EST_ACCESS_ROWS = 36);
96 WMS Commands