Configuring Default Storage for Tables

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.

Task

Enable 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.