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.
Table owned by self – Requires CREATE privilege on the dbspace where the table is created. Also requires one of:
- CREATE TABLE system privilege.
- CREATE ANY OBJECT system privilege.
Table owned by any user – Requires CREATE privilege on the dbspace where the table is created. Also requires one of:
- CREATE ANY TABLE system privilege.
- CREATE ANY OBJECT system privilege.

Task

To create a new RLV-enabled table, execute:

CREATE TABLE [ owner.]table-name 
   {ENABLE | DISABLE} RLV STORE 
   [ IN dbspace-name ]

table-name – the name of the table for which the RLV storage is to be enabled.
dbspace-name – a valid IQ main 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.