ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-65
PROFILE Statements
REMOVE PROCEDURE
The REMOVE PROCEDURE deletes the entry for a stored procedure from the
ZNUPROC table and all entries associated with the procedure from the ZNUPCOL
table. To execute REMOVE PROCEDURE, you must be a privileged user.
logical-procedure-name
specifies the name of the stored procedure you want to delete.
For Transact-SQL users only, a number appended to the name identifies a
procedure in a group of procedures with the same name that you want to delete. If
you omit the number, all procedures in the group are deleted.
Considerations – REMOVE PROCEDURE
The REMOVE PROCEDURE statement:
•
Deletes the specified procedure from the ZNUPROC and ZNUOBJ catalog tables
•
Deletes all entries associated with the procedure from the ZNUPCOL table
•
Generates an error if you are not a privileged user
If an error occurs, the effects of REMOVE PROCEDURE are rolled back.
Example
REMOVE PROCEDURE tess_data1_db.sql_dave.select_dept3000
PROFILE Statements
The following PROFILE statements affect named profile configuration:
•
ADD PROFILE
•
MODIFY PROFILE
•
REMOVE PROFILE
REMOVE PROCEDURE logical-procedure-name