Neoview Command Interface (NCI) Guide (R2.5)

0
specifies the ENV_SET environment variable, which supports a SET command.
1
specifies the ENV_CONTROL environment variable, which supports a CONTROL command
(CONTROL QUERY DEFAULT or CONTROL TABLE).
2
specifies the ENV_DEFINE environment variable, which supports a DEFINE command.
DSNAME data-source-name
is the name of the data source. data-source-name is case-sensitive and cannot be the
asterisk (*) wild card.
VALUE "string"
is a string value in double quotes that specifies the attribute-value pair for one of these types
of commands: SET, CONTROL, or DEFINE. Any single quote within the command string in
double quotes must be escaped by doubling the single-quote character. For example, in the
command string, put the value portion of the attribute-value pair between two single quotes.
Considerations
• To run this command in SQL mode, you must first run the CMDOPEN command. This
command does not run in CS mode.
• The command requires an SQL terminator.
• Only users associated with roles that have OPERATOR privileges can execute this command.
For more information, see the “ADD USER Command” (page 158) or “ALTER USER
Command” (page 167).
• The wild card (*) is not supported for the data source name, and the data source name is
case-sensitive.
• After you create a data source, the data source has no environment variables defined for it.
Use this command to define the environment variables for the data source.
• Environment variables are evaluated in the order in which they are created or added for a
data source, with the latest environment variable added for a specific type at the end of the
list. To determine the order of the environment variables for a data source, use the “INFO
EVAR Command” (page 172).
Examples
• This command adds an environment variable that issues a SET command for the data source
DDLTestDS:
SQL>add evar 0, dsname DDLTestDS, value "SET SESSION DEFAULT ESP_PRIORITY_DELTA ''-2''";
• This command adds an environment variable that issues a CONTROL QUERY DEFAULT
command for the data source DDLTestDS:
SQL>add evar 1, dsname DDLTestDS, value "CONTROL QUERY DEFAULT DEFAULT_CHARSET ''UCS2''";
• This command adds an environment variable that adds a DEFINE for the data source
DDLTestDS:
SQL>add evar 2, dsname DDLTestDS, value "ADD DEFINE =EMP, CLASS MAP, FILE PERSNL.EMPLOYEE";
ADD RESOURCE Command
The ADD RESOURCE command adds a resource management policy for the specified data
source.
Syntax
ADD RESOURCE "attribute-name", DSNAME data-source-name, LIMITVALUE value, ACTION "action"
action is:
LOG | LOG_WITH_INFO | STOP
ADD RESOURCE Command 157