Neoview Workload Management Services Guide (R2.5)

conn-expression
specifies one of these connection rule expressions:
Specifies the session name for the connection rule. By default, the
string-value is case-sensitive. 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 (that is, the Neoview role of the user
who logs on, not the user name) for the connection rule. The LOGIN
does not support the user name. If you specify a user name, it is
ignored in the connection rule without any warnings. By default,
the string-value is case-sensitive. 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.
LOGIN { string-value | ICASE
(string-value) }
Specifies the application name for the connection rule. By default,
the string-value is case-sensitive. The keyword ICASE causes
the NDCS server to ignore the case during the comparison of the
application name from the client and the connection rule. The
maximum character length is 30. Put string-value within double
quotes when it contains spaces. APPL supports multibyte characters.
APPL { string-value | ICASE
(string-value) }
Specifies the client data source name for the connection rule. By
default, the string-value is case-sensitive. The keyword ICASE
causes the NDCS server to ignore the case during the comparison
of the data source name from the client and the connection rule.
The maximum character length is 32. Put string-value within
double quotes when it contains spaces. DSN supports multibyte
characters.
DSN { string-value | ICASE
(string-value) }
warn-level
specifies the warning level. warn-level can be one of these values:
• WARN-LOW
• NO-WARN
If you do not specify a warning level, the default is NO-WARN.
rule-action
specifies an action to take if rule-specifier-list evaluates to true. For a connection
rule, you can specify this action:
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, for instance a SET SCHEMA statement, which is issued
when the rule evaluates to true. You must enclose the SQL string in double quotes.
The combined length of 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.
ADD RULE CONN Command 179