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

• Foreign server definition
  Can create and delete foreign server definitions.
  
• User mapping
  Can define and delete user mapping definitions.
  
• Foreign tables
  HiRDB External Data Access permits the following operations on foreign tables:
  
  • Defining and deleting foreign tables
  • Searching, inserting, updating, and deleting data in foreign tables
  • Defining and deleting a view table that uses a foreign table as a base table
  • Searching, inserting, updating, and deleting data in a view table that uses a foreign table as a base table
  • Deleting schemas containing a foreign table, and deleting schemas containing a view table that uses a foreign table as a base table
• Foreign indexes
  HiRDB External Data Access permits the following operations on foreign indexes:
  
  • Defining and deleting foreign indexes
  • Deleting schemas containing a foreign index

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

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.