ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-113
User Mapping (UMAP) Statements
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 – ADD UMAP
The ADD UMAP statement:
•
Creates a new entry in ZNSUMAP that associates the user and SCS process to
the specified server class
•
Generates a warning if alias-username is not a valid NonStop ODBC Server
alias
•
Generates a warning if server-name is not a valid NonStop ODBC server class
•
Generates an error if you are not authorized to modify the system catalog
Example
ADD UMAP $myscs sql_dave ser?? alpha
MODIFY UMAP
The MODIFY UMAP changes the mapping between an SCS process and alias
username with a specified server class. To execute MODIFY UMAP, you must be a
privileged user.
scs-processname
is an alphabetic string up to 15 characters in length that specifies the name of the
SCS process in the following format:
\node.$process-name
alias-username
is an alphanumeric string up to 60 characters in length that specifies an alias
username to associate with logical-user-name; alias-username must
begin with an alphabetic character, followed by alphabetic, numeric, and
underscore characters. This name must be unique and must already exist in
ZNSALT.
MODIFY UMAP scs-processname alias-username
SER_NAME server-name
[ UPDATE_SYSTEM_CONFIG ]