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

ALTER EVAR Command
The ALTER EVAR command changes the values of a specific type of environment variable for
the specified data source.
Syntax
ALTER EVAR type, DSNAME data-source-name, VALUE "string"
type is:
0 | 1 | 2
0
specifies the ENV_SET environment variable, which supports SET commands.
1
specifies the ENV_CONTROL environment variable, which supports CONTROL commands.
2
specifies the ENV_DEFINE environment variable, which supports DEFINE commands.
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.
• To avoid duplicate entries, use the INFO EVAR command to display the existing environment
variables. See the “INFO EVAR Command” (page 172).
• Delete the environment variables that need to be updated before issuing the ALTER EVAR
command. See the “DELETE EVAR Command” (page 169). Make sure to save the values
that you wish to retain before deleting the environment variable.
• The association server is notified immediately of the changes to the environment variables
for the data source.
Example
These commands modify the values of the ENV_SET environment variable for the data source
DDLTestDS:
SQL>alter evar 0, dsname DDLTestDS, value "SET SESSION DEFAULT ESP_PRIORITY_DELTA ''-2''";
SQL>alter evar 0, dsname DDLTestDS, value "SET SESSION DEFAULT MASTER_PRIORITY ''175''";
ALTER EVAR Command 165