Home | Previous Page | Next Page   SQL Statements for Access Methods > CREATE ACCESS_METHOD (+) >

Sample Statements

The following statement creates a primary access method named textfile that resides in an extspace. The am_getnext purpose function is assigned to a function name that already exists. The textfile access method supports clustering.

Figure 30. Sample CREATE PRIMARY ACCESS_METHOD Statement
CREATE PRIMARY ACCESS_METHOD textfile(
AM_GETNEXT = textfile_getnext,
AM_CLUSTER,
AM_SPTYPE = ' X' );

References

See the descriptions of:

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]