1.11 Relationship to HiRDB External Data Access

Installation of HiRDB External Data Access permits the use of the following functions:

Table 1-34 shows SQL statements that are available when HiRDB External Data Access is installed.

Table 1-34 SQL statements that are available when HiRDB External Data Access is installed

ClassificationSQLAvailable function
Definition SQLALTER PROCEDUREModifying procedure definitions using a foreign table or a view table using a foreign table as a base table
COMMENTAdding comments to a foreign table or a column in a foreign table
CREATE FOREIGN INDEXDefining a foreign index
CREATE FOREIGN TABLEDefining a foreign table
CREATE PROCEDUREDefining a procedure using a foreign table or a view table using a foreign table as a base table
CREATE SERVERDefining a foreign server
CREATE USER MAPPINGDefining a user mapping
CREATE VIEWDefining a foreign table or a view table using a foreign table as a base table
DROP FOREIGN INDEXDeleting a foreign index
DROP FOREIGN TABLEDeleting a foreign table
DROP PROCEDUREDeleting a procedure using a foreign table or a view table using a foreign table as a base table*
DROP SERVERDeleting a foreign server
DROP USER MAPPINGDeleting a user mapping
DROP SCHEMADeleting a foreign table or a schema containing a foreign index
Data manipulation SQLSingle-row SELECT statementRetrieving a foreign table or a view table using a foreign table as a base table
Dynamic SELECT statementRetrieving a foreign table or a view table using a foreign table as a base table
INSERT statement (format 1)Inserting a row into a foreign table or into a view table that uses a foreign table as a base table
INSERT statement (format 3)Using an embedded variable array to insert multiple rows into a foreign table or into a view table that uses a foreign table as a base table
UPDATE statement (format 1)Updating the value of a specified column in a foreign table or in a view table that uses a foreign table as a base table
UPDATE statement (format 3)Using an embedded variable array to update rows column by column in a foreign table or in a view table that uses a foreign table as a base table
DELETE statement (format 1)Deleting a specified row from a foreign table or from a view table that uses a foreign table as a base table
DELETE statement (format 3)Using an embedded variable array to delete specified rows from a foreign table or from a view table that uses a foreign table as a base table
Control SQLLOCK statementExecuting locking in units of tables on external DB tables corresponding to a foreign table
Note
If HiRDB External Data Access is not installed, or it has been uninstalled, SQL statements other than the COMMENT and DROP PROCEDURE statements cannot be used.
* This function can be executed without the installation of HiRDB External Data Access.