ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-114
User Mapping (UMAP) Statements
SER_NAME server-name
is an alphanumeric string up to 32 characters in length that specifies the name of
the server class configuration entity to associate with a user and profile;
server-name must already be mapped to scs-processname in ZNSMAP.
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 UMAP
The MODIFY UMAP statement:
•
Modifies an existing entry in ZNSUMAP that maps an SCS process and user to the
specified server class
•
Generates a warning if alias-username is not a valid NonStop ODBC Server
alias
•
Generates a warning if scs-processname and alias-username are not
already mapped to each other and represented by an entry in ZNSUMAP
•
Generates a warning if server-name is not a valid NonStop ODBC server class
configuration entity represented by an entry in ZNSSER
•
Generates an error if you are not authorized to modify the system catalog
Example
MODIFY UMAP $myscs sql_dave SER_NAME beta UPDATE_SYSTEM_CONFIG
REMOVE UMAP
The REMOVE UMAP statement remove an existing association between an SCS
process and user association and a server class. To execute REMOVE UMAP, you
must be a privileged user.
Considerations – REMOVE UMAP
The REMOVE UMAP statement:
•
Modifies an existing entry in ZNSUMAP that maps an SCS process and user to a
server class
•
Generates an error if you are not a privileged user
REMOVE UMAP scs-processname alias-username
[ UPDATE_SYSTEM_CONFIG ]