The following table lists the scalar system functions that ODBC supports.

Table 1. Scalar system functions supported by ODBC
System function Returns 
DATABASE()
 Name of the database, corresponding to the connection handle (odbc) 
IFNULL(exp, value)
 value, if exp is null 
ROWID(extension)
 The row identifier of the current row in a table 
USER()
 Authorization name of the user 
tenantname()
 Name of the tenant corresponding to the connection handle (odbc). 
tenantid()
 Unique ID associated with the name of the tenant. 
tenantName_tbl
 ([ owner_name. | catalog_name.owner_name.]table_name)
 Name of the tenant for the current row of the specified table. 
tenantid_tbl
 ([ owner_name. | catalog_name.owner_name.]table_name)
 Unique ID of the tenant for the current row of the specified table.