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"