Dropping a nickname
Dropping a nickname deletes the nickname from the global catalog on the federated server. The data source object that the nickname references is not affected.
Before you begin
Ensure that the nickname is listed in the catalog.
Ensure
that the the authorization ID of the DROP statement when dropping
nicknames has one of the following:
- SYSADM or DBADM authority
- DROPIN privilege on the schema for the nickname
- Definer of the nickname as recorded in the DEFINER column of the catalog view for the nickname
- CONTROL privilege on the nickname
About this task
When you drop a nickname, other objects that you registered
with the federated server are impacted:
- Dropping a nickname affects the objects that depend on those nicknames:
- Any index specifications that depend on the dropped nicknames are dropped.
- Any views that depend on the dropped nicknames are marked inoperative.
- Any materialized query tables that depend on the dropped nicknames are dropped.
- All packages and cached dynamic SQL statements that depend on the dropped nickname are marked invalid, and remain invalid until the dependent objects are recreated.
For nicknames on relational data sources, the federated
server cannot process the DROP NICKNAME statement within a particular
unit of work (UOW) under any of the following conditions:
- A nickname that is referenced in this statement has a cursor open on it in the same UOW.
- A nickname that is referenced in this statement is referenced by a SELECT statement in the same UOW.
- An INSERT, DELETE or UPDATE statement that is issued in the same UOW for the nickname that is referenced in the statement.
- A nickname that is referenced in this statement has a cursor open on it in the same UOW.
- A nickname that is referenced in this statement is referenced by a SELECT statement in the same UOW.
Procedure
Use one of the following methods: