Statements that the access method does not support
The user can receive an SQL error for statements that require a purpose function that you did not supply. The access-method user guide must advise users which statements to avoid.
If the access method does not supply one or more of the
following purpose functions or set the corresponding purpose flags,
the access-method user guide must advise users not to use any of the
following statements.
| Without this purpose function and purpose flag | Avoid this SQL statement |
|---|---|
| am_insert, am_readwrite | INSERT, ALTER FRAGMENT |
| am_delete, am_readwrite, am_rowids | DELETE, ALTER FRAGMENT |
| am_update, am_readwrite, am_rowids | UPDATE |
| am_stats | UPDATE STATISTICS |
Important: For statements that alter data, a purpose
function alone does not avoid the SQL error. You must also set the am_readwrite purpose
flag and the am_rowids purpose flag when the database server
uses a row identifier.