Neoview Workload Management Services Guide (R2.5)

ALTER RULE CONN Command
The ALTER RULE CONN command alters the attributes of a connection rule.
NOTE: Only administrators are permitted to run this command. By default, an administrator
is a user associated with ROLE.DBA, SUPER.SERVICES, or SUPER.SUPER.
Syntax
ALTER RULE CONN rule-specifier
rule-specifier is:
rule-name ( rule-specifier-list [, warn-level] [, rule-action ] [, aggregation] )
[ rule-comment ]
rule-specifier-list is:
conn-expression [, conn-expression ] ...
conn-expression is:
SESSION { string-value | ICASE (string-value) }
| LOGIN { string-value | ICASE (string-value) }
| APPL { string-value | ICASE (string-value) }
| DSN { string-value | ICASE (string-value) }
warn-level is:
{ WARN-LOW
| NO-WARN }
rule-action is:
{ SQL_CMD "sql-string;" } | NO-ACTION
aggregation is:
AGGREGATE aggregate-parameter-list
aggregate-parameter-list is:
aggregate-parameter
| (aggregate-parameter[, aggregate-parameter]...)
aggregate-parameter is:
QUERY_TYPE query-type-list
| REPOS_INTERVAL time-value
| WMS_INTERVAL time-value
| EXEC_INTERVAL time-value
| NO-ACTION
query-type-list is:
query-type
| (query-type[, query-type]...)
query-type is:
{ INSERT | UPDATE | DELETE | SELECT | ALL }
rule-comment is:
{ COMMENT "comment-string" }
rule-name
is the name of an existing connection rule.
rule-specifier-list
specifies one or more comma-separated conn-expression. WMS tests each
conn-expression in the rule-specifier-list in the order in which you specify them.
192 WMS Commands