SYSCS_UTIL.SET_PURGE_DELETED_ROWS

The SYSCS_UTIL.SET_PURGE_DELETED_ROWS system procedure enables (or disables) physical deletion of logically deleted rows from a specific table.

Syntax

SYSCS_UTIL.SET_PURGE_DELETED_ROWS( VARCHAR schema,
                                  VARCHAR table,
                                  VARCHAR enable );

schema

The name of the schema.

table

The name of the table

enable

A Boolean specifying whether or not to physically delete rows that have been logically deleted during major compaction.

Results

This procedure does not return a result.

Execute Privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. The database owner can grant access to other users.

Example

This specifies that deleted rows from my_table will be physically deleted when the next major compaction is run:

CALL SYSCS_UTIL.SET_PURGE_DELETED_ROWS('SPLICE', 'my_table', true);