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, the access-method user guide must advise
users not to use any of the following corresponding 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.