Product Documentation

SQL Operations Guide

Previous Topic

Next Topic

fc_get_partbounds()

fc_get_partbounds(owner, table_name)

Returns the first and last active partition numbers for a partitioned table. This is useful to determine the oldest (Firstactprt) partition to purge, for example. You must be connected to the database that contains the table.

Parameters (2)

------------------

owner VARCHAR(64)

table_name VARCHAR(64)


Result Set Fields (2)

------------------

Firstactprt -- "First Active Partition number"

Lastactprt -- "Last Active Partition number"

TOCIndex