Try OpenEdge Now
skip to main content
SQL Reference
ODBC Reference : ODBC Scalar Functions : System functions
 

System functions

The following table lists the scalar system functions that ODBC supports.
Table 69. 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.