USING Access-Method Clause

The USING Access Method clause can specify an access method.

This syntax fragment is part of the CREATE TABLE statement.
Read syntax diagramSkip visual syntax diagram
USING Access-Method Clause

                            (1)   
|--USING--| Specific Name |------------------------------------->

   .-,--------------------------------------------------.   
   V                                                    |   
>----+------------------------------------------------+-+-------|
     |    .-,--------------.                          |     
     |    V                |                          |     
     '-(----config_keyword-+--+------------------+--)-'     
                              '- ='config_value'-'          

Notes:
  1. 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. Informix® 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=':');

Copyright© 2019 HCL Technologies Limited