Enabling or Disabling Row-Level Versioning in a Table

You can set a base table to use row-level versioning (RLV) in order to track row changes for read-write transactions.

Prerequisites
Database Version Table Privileges
SAP Sybase IQ 15.3 and 15.4 Not supported.
SAP Sybase IQ 16.0 Requires one of:
  • ALTER ANY TABLE system privilege.
  • ALTER ANY OBJECT system privilege.
Task

If your implementation uses the in-memory RLV store, you can enable row-level snapshot versioning so multiple connections can make concurrent updates to different rows of the same table.

  1. In the Perspective Resources view, select the resource and select Resource > Administration Console.
  2. In the Administration Console, expand IQ Servers > Schema Objects > Tables.
  3. Select Tables.
  4. In the right pane, select a table, click the drop-down arrow that appears next to the table name and select Properties.
  5. Select Row-level Versioning.
  6. Select the Enabled checkbox if you want the table to use row-level versioning to track row changes for read-write transactions on the table. The RLV dbspace must exist to enable RLV on tables
    Or, deselect the Enabledcheckbox to disable row-level versioning. .
  7. Click OK.
Parent topic: Tables
Related concepts
Table Columns
Table Permissions
Table Constraints
Table Indexes
Table Triggers
Table Partitions
Related tasks
Creating a Table
Creating a Global Temporary Table
Creating a Proxy Table
Viewing Table Data in the Execute SQL Window
Deleting a Table
Generating Table DDL Commands
Moving a Table to Another Dbspace
Validating a System Store Table
Setting the Primary Key
Setting a Clustered Index
Merging Table Data from RLV Store with IQ Main Store
Calculating the Number of Rows in a Table
Moving Table Objects to Another Dbspace
Viewing or Modifying Base Table Properties
Viewing or Modifying Global Temporary Table Properties
Viewing and Modifying Proxy Table Properties
Authenticating a Login Account for a Managed Resource
Related reference
Table Privilege Summary