When the {ENABLE | DISABLE} RLV STORE clause of the CREATE TABLE statement is not present, the BASE_TABLES_IN_RLV_STORE option setting is used to determine RLV storage. Thus,
you can allow existing CREATE TABLE statements to run
without modifying scripts to enable RLV storage.
Prerequisites
- SAP Sybase IQ server has a simplex database.
- The RLV dbspace exists with at least one dbfile.
TaskEnable the option at the database level.
Set option PUBLIC.BASE_TABLES_IN_RLV_STORE = 'ON'
Note: The settings on an individual table made by using the CREATE TABLE statement override this option. The
default setting is OFF. If set to ON, any CREATE TABLE
statement without the ENABLE | DISABLE RLV clause results in the
creation of an RLV-enabled table.