In This Chapter

This chapter describes the steps that you take to implement a user-defined access method with the Virtual-Index Interface (VII).

To provide an access method

Choose the optional features that the access method supports.
Program and compile the C header files and purpose functions as well as the modules that the purpose functions call.
Execute the CREATE FUNCTION statement to register each purpose function in the sysprocedures system catalog table.
Execute the CREATE SECONDARY ACCESS_METHOD statement to register the user-defined access method in the sysams system catalog table.
If necessary, create support and strategy functions for an operator class and then execute the CREATE FUNCTION to register the functions in the sysprocedures system catalog table.
Execute the CREATE OPERATOR CLASS statement to register the operator class in the sysopclasses system catalog table.
Test the access method in an end-user environment.