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
Classification | SQL | Available function |
---|---|---|
Definition SQL | ALTER PROCEDURE | Modifying procedure definitions using a foreign table or a view table using a foreign table as a base table |
COMMENT | Adding comments to a foreign table or a column in a foreign table | |
CREATE FOREIGN INDEX | Defining a foreign index | |
CREATE FOREIGN TABLE | Defining a foreign table | |
CREATE PROCEDURE | Defining a procedure using a foreign table or a view table using a foreign table as a base table | |
CREATE SERVER | Defining a foreign server | |
CREATE USER MAPPING | Defining a user mapping | |
CREATE VIEW | Defining a foreign table or a view table using a foreign table as a base table | |
DROP FOREIGN INDEX | Deleting a foreign index | |
DROP FOREIGN TABLE | Deleting a foreign table | |
DROP PROCEDURE | Deleting a procedure using a foreign table or a view table using a foreign table as a base table* | |
DROP SERVER | Deleting a foreign server | |
DROP USER MAPPING | Deleting a user mapping | |
DROP SCHEMA | Deleting a foreign table or a schema containing a foreign index | |
Data manipulation SQL | Single-row SELECT statement | Retrieving a foreign table or a view table using a foreign table as a base table |
Dynamic SELECT statement | Retrieving 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 SQL | LOCK statement | Executing locking in units of tables on external DB tables corresponding to a foreign table |