Neoview Workload Management Services Guide (R2.4)

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 ROLE.DBA or the super ID (super.services or super.super).

Syntax

ALTER RULE CONN rule-specifier

rule-specifier is:

rule-name ( rule-specifier-list [, warn-level] [, rule-action ])

[ 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;" }

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.

conn-expression

specifies one of these connection rule expressions:

Specifies the session name for the connection rule. The keyword

ICASE causes the NDCS server to ignore the case during the

comparison of the session name from the client and the connection

rule. The maximum character length is 24. Put string-value

within double quotes when it contains spaces. SESSION does not

support multibyte characters.

SESSION { string-value | ICASE

(string-value) }

Specifies the client login role (not alias) for the connection rule. The

keyword ICASE causes the NDCS server to ignore the case during

the comparison of the login role from the client and the connection

rule. The maximum character length is 17. Put string-value

within double quotes when it contains spaces. LOGIN does not

support multibyte characters.

(string-value) }

ALTER RULE CONN Command 97