Before deleting a plug-in, the HiRDB administrator must delete the database resources listed below. The table below lists the SQL statements issued to delete the following resources:

• Tables, view tables, functions, procedures, and abstract data types (when a user-defined abstract data type specifies the abstract data type provided by the plug-in as one of its attributes) that use the abstract data type provided by the plug-in that is to be deleted
• 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
  View table	DROP VIEW
  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.
   • The owner of a plugin registered with HiRDB Version 5.0 (with HiRDB Object Option) is not MASTER. Therefore, you need to take the actions described previously.
   • 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 pdplgset -d command is used to cancel setup of the plug-in. Before this command is executed, save all necessary files. No files are deleted from the conf directory. Plug-in setup cancellation must be performed at all units where HiRDB is set up.

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