BUFFER-PARTITION-ID function

Returns the partition ID (as an integer) of the partition of the current record in a specified buffer.

Syntax 

 

BUFFER-PARTITION-ID ( buffer-name )

buffer-name

An identifier that specifies the name of a record buffer.

If the buffer is not populated with a record, this function returns the Unknown value (?). If there is a record in the buffer but it is not for a partitioned table, this function returns zero (0).

Notes 

If you use this function in a WHERE clause, it will be evaluated for each iteration on the client side after the record has been retrieved. It will not participate in any index bracketing, so unless there are other partition-column criteria in the same WHERE clause, it will be very inefficient.

The partition ID is only unique within a given table.

See also 

BUFFER-PARTITION-ID attribute, IS-PARTITIONED attribute