Before deleting a plug-in, the HiRDB administrator must delete the database resources listed below. Table 5-2 lists the SQL statements that can be used to delete these resources.

• Abstract data type, procedure, function, and table using the abstract data type that is provided by the plug-in that is to be deleted (applicable when the abstract data type provided by the plug-in is specified as an attribute among all the user-defined abstract data types)
• Index using the index type that is provided by the plug-in that is to be deleted
• Function and procedure using the function provided by the plug-in that is to be deleted
  

  Table 5-2 SQL statements for deleting database resources

  Database resources to be deleted	SQL statement to be used
  Table	DROP TABLE
  Index	DROP INDEX
  Function	DROP FUNCTION
  Procedure	DROP PROCEDURE
  Abstract data type	DROP DATA TYPE*

^* The data type provided by a plug-in must not be deleted.

The following command is executed for each plug-in that is to be deleted:

pdplgrgst -d plug-in-definition-filename PIC-filename

Notes

1. When a data-type plug-in is to be deleted and an index-type plug-in providing the index facility for that data type is also registered, the index-type plug-in must be deleted first.
2. If you are deleting a plug-in with an owner who is not MASTER, note the following:
   
   • Only a plug-in's owner can delete his/her plug-in. Specify the authorization identifier and password of the plug-in owner in the PDUSER operand in the client environment definitions. Then, specify the -u option when executing the pdplgrgst command.
   • If you delete a plug-in owner's schema, the plug-in itself is also deleted. For details about the actions to be taken after the plug-in has been deleted, see the sections beginning at (3) as follows.

For details about how to delete registry information, see the applicable plug-in documentation.

The pdstop command must be entered to terminate HiRDB normally.

When HiRDB is terminated normally, the pdplugin operand must be deleted from the applicable system common definitions.

The plug-in must be uninstalled from the server machine. For details about the uninstallation, see the procedure for the applicable plug-in.