The CREATE ACCESS_METHOD (+) statement

Use the CREATE SECONDARY ACCESS_METHOD statement to register a new secondary access method. When you register an access method, the database server places an entry in the sysams system catalog table.

Syntax

(1)
Notes:
Element Purpose Restrictions Syntax
access-method name The access method to add The access method must have a unique name in the sysams system catalog table. Database Object Name segment; see Informix® Guide to SQL: Syntax.

Usage

The CREATE SECONDARY ACCESS_METHOD statement adds a user-defined access method to a database. When you create an access method, you specify purpose functions, purpose flags, or purpose values as attributes of the access method.

You must have the DBA or Resource privilege to create an access method.

Sample statements

The following statement creates a secondary access method named T-tree that is in an sbspace. The am_getnext purpose function is assigned to a function name that already exists. The T_tree access method supports unique keys and clustering.
Figure 1: Sample CREATE SECONDARY ACCESS_METHOD statement
CREATE SECONDARY ACCESS_METHOD T_tree(
AM_GETNEXT = ttree_getnext,
AM_UNIQUE,
AM_CLUSTER,
AM_SPTYPE = ' S ' );