Neoview Workload Management Services Guide (R2.4)

Specifies the application name for the connection rule. 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. 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 classification. 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. 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
• Use the ALTER WMS CONN command a connection rule with a service.
• You cannot add a rule that begins with the reserved “HPS_” prefix or that has the same
name as one of the predefined rules, HPS_MANAGEABILITY1 through 9 and
HPS_TRANSPORTER1.
Examples
• These commands define several connection rules:
ADD RULE CONN CONNRULE1 (SESSION JOB2468, LOGIN ROLE.USR1);
ADD RULE CONN CONNRULE2 (SESSION JOB2468, LOGIN ROLE.USR2);
ADD RULE CONN CONNRULE3 (SESSION JOB2510, APPL QtrReport.exe, LOGIN ROLE.USR3, DSN ICASE(DSN1));
ADD RULE CONN CONNRULE4 (APPL "Quarterly Report", LOGIN ROLE.USR4, DSN ICASE(DSN1));
ADD RULE CONN Command 87