Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

fc_ptadmin_num()

Performs partition administration actions to a partitioned table based on the partition number. You must be connected to the database that contains the table. This uses the ptADMINnewthd mode which requires the table to be closed.

Parameters (4)

owner VARCHAR(64)

table_name VARCHAR(64)

action VARCHAR(16)

part_num INTEGER


action is one of the following strings:

( 'purge' | 'reuse' | 'archive' | 'activate' | 'add' | 'rebuild')

Example

>call fc_ptadmin_num('admin', 'custmast', 'purge', 12345);

Requires DBA privilege.

TOCIndex