Returns the tenant ID (as an integer) of the real tenant associated with a database connection.

Syntax

TENANT-ID ( [ database-name  ] )
database-name

A character expression that evaluates to a logical database name or database alias. If the database is not enabled for multi-tenancy, the function returns zero (0).

If no database is specified and more than one database is connected, the AVM raises an error. If the database name is not a valid name for a connected database, the AVM raises an error.

Notes

  • The tenant ID of the default tenant is 0. The tenant ID of a non-default regular tenant is greater than 0 and that of a super tenant is less than 0.
  • For a super-tenant connection identity, this function returns the tenant ID of the super tenant, not the effective tenant.

See also

SET-EFFECTIVE-TENANT function, TENANT-NAME function, TENANT-NAME-TO-ID function