USING Access-Method Clause

The USING Access Method clause can specify an access method.

This syntax fragment is part of the CREATE TABLE statement.

Notes:

¹ See Specific Name


Element	Description	Restrictions	Syntax
config_keyword	Configuration keyword associated with the specified access method	No more than 18 bytes. The access method must exist.	Literal keyword
config_value	Value of the specified configuration keyword	No more than 236 bytes. Must be defined by the access method.	Quoted String

A primary-access method is a set of routines to perform DDL and DML operations, such as create, drop, insert, delete, update, and scan, to make a table available to the database server. HCL OneDB™ provides a built-in primary-access method.

You store and manage a virtual table either outside of the database server in an extspace or inside the database server in an sbspace. (See Storage options.) You can access a virtual table with SQL statements. Access to a virtual table requires a user-defined primary-access method.

DataBlade® modules can provide other primary-access methods to access virtual tables. When you access a virtual table, the database server calls the routines associated with that access method rather than the built-in table routines. For more information on these other primary-access methods, refer to your access-method documentation.

You can retrieve a list of configuration values for an access method from a table descriptor (mi_am_table_desc) using the MI_TAB_AMPARAM macro. Not all keywords require configuration values.

The access method must already exist. For example, if an access method called textfile exists, you can specify it with the following syntax:

CREATE TABLE mybook
   (... )
   IN myextspace
   USING textfile (DELIMITER=':');