This function shows the Compass partition for the record. The functions and parameters are case-insensitive.

The default result set column name is infor.Partition. You can specify an alias to override the default result set column name.


select infor.partition('object') from object

The parameter is the object name. Use single quotes around the object name because it is a literal for the function. Use the object name as a parameter if the query contains joins to select the Partition from a specific object name.


select infor.partition() from object

The object name is optional if the query selects data from a single object.

Note: Before v2020-09, the default name of the partition was rd, this is now deprecated