ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual429151-002
7-44
ALIAS Statements
alias-username
specifies the alias username you want to modify.
NOS_USERNAME logical-username
specifies the logical username associated with alias-username.
logical-username must begin with an alphabetic character, followed by
alphabetic, numeric, and underscore characters.
CHANGE_PASSWORD_OPTION { 0 | 1 | 2 }
specifies the level of notification sent to users for Safeguard passwords that are
expired or are about to expire. See the ADD ALIAS statement for a description of
the options.
PROFILE profile-name
specifies the name of a profile to associate with alias-username. The value
must be either an SQL identifier or an asterisk (*). An asterisk indicates that the
profile to use is to be determined at run time from the ZNSALT record in which
NOS_ALIASNAME is equated with logical-username.
If you enter the PROFILE keyword, you must also enter profile-name. If you
omit the entire parameter, the profile name DEFAULT is assumed.
UPDATE_SYSTEM_CONFIG
resets the time to update system configuration values to the current time. This
option causes running system components to reread their configuration values on
the next polling cycle.
Considerations – MODIFY ALIAS
The MODIFY ALIAS statement:
Changes the existing logical username or profile name entry in ZNSALT for the
specified alias-username
Generates a warning if alias-username is not a valid NonStop ODBC Server
alias username
Generates a warning if logical-username is not a valid NonStop ODBC Server
logical username
Generates a warning if profile-name is not a valid NonStop ODBC Server
profile
Generates an error if you are not a privileged user or the user associated with
logical-username