SQL restrictions
The database server raises exceptions due to restrictions that the virtual-table interface (VTI) imposes on SQL.
A user cannot specify a dbspace in a CREATE TABLE or ALTER
FRAGMENT statement. The VTI does not support the following statements
for virtual tables:
- An ALTER TABLE 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