Returns the tenant ID of the effective tenant
as an integer.
Syntax
GET-EFFECTIVE-TENANT-ID( [database-name] )
database-name
A character expression that evaluates to a logical database
name or database alias. 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
If
a super tenant executes this function and they have already executed
the SET-EFFECTIVE-TENANT function, this function returns the tenant ID of any effective tenant
that is in scope. If they have not executed the SET-EFFECTIVE-TENANT function or there is no effective tenant in scope, this
function returns the default tenant ID (0).
If a regular-tenant user executes this function, it returns
the tenant ID associated with the user's tenancy.