Creating a New Table with RLV Storage Settings

When creating a new base table, you can specifically enable or disable RLV storage.

Prerequisites

SAP Sybase IQ server has a simplex database.
The RLV dbspace exists with at least one dbfile.
You must have RESOURCE authority.
You must have CREATE permission on the RLV store dbspace.

Task

Use the statement CREATE TABLE <table-name> {ENABLE | DISABLE} RLV STORE

<table-name> – the name of the table for which the RLV storage is to be enabled.
CREATE TABLE [ owner] table-name IN dbspace-name – not allowed, unless you specifically use the exact name of the RLV store dbspace.

Note: If the ENABLE | DISABLE RLV STORE clause is omitted, RLV storage settings for the table will default to the value of the global database option BASE_TABLES_IN_RLV_STORE.