The partition ID of the partition of the buffer.

Data type: INTEGER

Access: Read-only

Applies to: Buffer object handle

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

Notes

  • If you use this attribute in a WHERE clause, it will be evaluated before the FOR EACH starts, which will result in no records being found unless the specified buffer is not the same as the buffer of the query or FOR EACH statement.
  • The partition ID is only unique within a given table.

See also

BUFFER-PARTITION-ID function, IS-PARTITIONED attribute