Command Reference Guide

Object EVAR Commands
SQL/MX Connectivity Service Administrative Command Reference—526350-005
6-7
Considerations—ALTER EVAR
PREFIX string
is the portion of the object definition that appears before the name. It is an SQL
string literal, and so requires single quotes. The default value is determined by the
type. See EVAR Types on page 6-1. For consistency, this value is stored in
uppercase letters, even though it is a quoted literal.
VALUE string
is the portion of the object definition that appears after the name. It is an SQL
string literal, and so requires single quotes. There is no default. See the SQL/MX
Reference Manual for name and value syntax details.
LIMIT number
is the threshold value for the monitored attribute for this resource management
policy. There is no default. This value must be positive and not exceed the
maximum value of the LARGEINT SQL data type of 9,223,372,036,854,775,807.
The number entered should have no commas and should appear as
9223372036854775807. Commas are inserted only for clarity
ACTION key-val
is the desired action when the limit is exceeded for this resource management
policy. The valid values are LOG, LOG_WITH_INFO, and STOP (with LOG also).
The LOG option is the default.
Considerations—ALTER EVAR

ALTER EVAR is a sensitive command.

The asterisk (*) wild card is not supported for evar-name.

The order of the EVARs is not changed. Use the INFO EVAR to determine the
order in which the environment variables can be applied when used.

ALTER EVAR changes the first EVAR it finds with a prefix and name match. It then
scans for additional matches and displays warnings because subsequent names
can be used at run time instead of the first name.

ALTER EVAR rebuilds the object from the data provided in the command.

Syntax and use of this command are similar to the ADD EVAR command. But
unlike ADD EVAR, which places the new EVAR at the end of the list, ALTER EVAR
replaces the object where it originally appeared in the list.

Names for some EVARs must be multiword to be unique, so blank spaces are
permitted in this name with double quotes. The resulting definition consists of the
prefix, name, and value fields, concatenated together in that order.

The existing values for PREFIX, LIMIT, and ACTION become the defaults, but
VALUE does not default.