GET-EFFECTIVE-TENANT-NAME function

Returns the name of the effective tenant as a character string.

Syntax 

 

GET-EFFECTIVE-TENANT-NAME( [ 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 name 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 name of the default tenant ("Default").

If a regular-tenant user executes this function, it returns the tenant name associated with the user’s tenancy.

See also 

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