The following statement alters the remote user-defined access method:
ALTER ACCESS_METHOD remote ADD am_scancost = FS_scancost, ADD am_rowids, DROP am_getbyid, MODIFY am_costfactor = 0.9;
The preceding example makes the following changes to the access method:
Related statements: CREATE ACCESS_METHOD and DROP ACCESS_METHOD
For information about how to set purpose-option specifications, see Purpose Options.
For the schema of the sysams system catalog table, see the IBM Informix Guide to SQL: Reference.
For more information on primary-access methods, see the IBM Informix Virtual-Table Interface Programmer's Guide.
For more information on secondary-access methods, see the IBM Informix Virtual-Index Interface Programmer's Guide and the IBM Informix User-Defined Routines and Data Types Developer's Guide.
For a discussion of privileges, see the GRANT statement in this chapter, or the IBM Informix Database Design and Implementation Guide.