CREATE ACCESS_METHOD (+)

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

Syntax

>>-CREATE--PRIMARY--ACCESS_METHOD--access-method name----------->
 
      .-'-----------------------.
      V                    (1)  |
>--(----| Purpose Option |------+--)---------------------------><

Notes:

See page Purpose Options

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 IBM Informix: Guide to SQL Syntax.

Usage

The CREATE PRIMARY 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. To set purpose options, refer to Purpose Options.

You must have the DBA or Resource privilege to create an access method. For information about privileges, refer to the IBM Informix: Database Design and Implementation Guide or the GRANT statement in the IBM Informix: Guide to SQL Syntax.