SQL restrictions
The database server raises exceptions due to restrictions that the virtual-index interface (VII) imposes on SQL.
A user cannot specify a dbspace in a CREATE INDEX or ALTER
FRAGMENT statement. The VII does not support the following statements
for virtual indexes:
- An ALTER INDEX statement that adds, drops, or modifies a column
- A LOCK TABLE or UNLOCK TABLE statement
- An ATTACH or DETACH keyword in an ALTER FRAGMENT statement