TENANT-WHERE option of the record phrase — Adds tenancy criteria to the data in a query independent of the current effective tenancy. Given the specified multi-tenant tables and joins in a query, this option can be used to qualify the tenancy of each individual record buffer, including record instances from multiple tenants. If multiple specified tenants are in a tenant group, the associated SKIP-GROUP-DUPLICATES option skips all but the first tenant record in any group.

REPOSITION statement and REPOSITION-TO-ROWID( ) method on a query handle — Provides an option to reposition to a query row owned by a specified tenant.