Product Documentation

SQL Operations Guide

Previous Topic

Next Topic


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')


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

Requires DBA privilege.