ALTER ACCESS

The ALTER ACCESS_METHOD statement changes the attributes of a user-defined access method in the sysams system catalog table.

Only Dynamic Server supports this statement, which is an extension to the ANSI/ISO standard for SQL.

Syntax

>>-ALTER ACCESS_METHOD--access_method--------------------------->
 
   .-,---------------------------------------.
   V                                  (1)    |
>----+-+-MODIFY-+--| Purpose Option |------+-+-----------------><
     | '-ADD----'                          |
     '-DROP--purpose_keyword---------------'

Notes:

See Purpose Options

Element	Description	Restrictions	Syntax
access _method	Name of the access method to alter	Access method must be registered in the sysams system catalog table by a previous CREATE ACCESS_METHOD statement	Database Object Name
purpose _keyword	A keyword that indicates which feature to change	Keyword must be associated with the access method by a previous CREATE or ALTER ACCESS_METHOD statement	Purpose Functions, Methods, Flags, and Values

Usage

Use ALTER ACCESS_METHOD to modify the definition of a user-defined access method. You must be the owner of the access method or have DBA privileges to alter an access method.

When you alter an access method, you change the purpose-option specifications (purpose functions, purpose methods, purpose flags, or purpose values) that define the access method. For example, you might alter an access method to assign a new user-defined function or method name or to provide a multiplier for the scan cost on a table.

If a transaction is in progress, the database server waits to alter the access method until after the transaction is committed or rolled back. No other users can execute the access method until the transaction has completed.