ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-41
ALIAS Statements
Example
CREATE ACC_LOG IN persnl SECURE COOO
DROP ACC_LOG
The DROP ACC_LOG statement drops an existing accounting log table and removes
the mapping entry for the log table in the specified database. To execute DROP
ACC_LOG, you must be a privileged user.
FROM database
specifies the name of the database from which to drop the accounting log table.
database must be a customized NonStop ODBC Server database; otherwise, the
statement returns an error.
Considerations – DROP ACC_LOG
The DROP ACC_LOG statement:
•
Preserves the entry in ZNSPROF for the log table
•
Returns an error if you are not a privileged user
•
Returns an error if either the database cannot be updated for resource or privilege
reasons or the associated SQL DROP TABLE statement fails
Example
DROP ACC_LOG FROM persnl
ALIAS Statements
Use the following statements to map alias usernames to logical usernames and user
profiles:
•
ADD ALIAS
•
MODIFY ALIAS
•
REMOVE ALIAS
DROP ACC_LOG FROM database