SQL system functions supported by the Connectivity Kit

MORE INFORMATION

The following table lists the supported System functions.

Parameter arguments denoted as <exp> can be the name of a column, the result of another scaler function, or a literal, where the underlying data type could be represented as SQL_NUMERIC, SQL_DECIMAL, SQL_TINYINT, SQL_SMALLINT, SQL_INTEGER, SQL_BIGINT, SQL_FLOAT, SQL_REAL, SQL_DOUBLE, SQL_DATE, SQL_TIME, or SQL_TIMESTAMP.

Parameter arguments listed as <value> can be a literal constant, where the underlying data type can be represented as SQL_NUMERIC, SQL_DECIMAL, SQL_TINYINT, SQL_SMALLINT, SQL_INTEGER, SQL_BIGINT, SQL_FLOAT, SQL_REAL, SQL_DOUBLE, SQL_DATE, SQL_TIME, or SQL_TIMESTAMP.

Values returned are represented as ODBC data types.

   Function            Description
   --------------------------------------------------------------------

   USER()              Returns the user's authorization name. (The
                       user's authorization name is also available via
                       SQLGetInfo by specifying the information type
                       SQL_USER_NAME.)

   DATABASE()          Returns the name of the database corresponding
                       to the connection handle (hdbc). (The name of
                       the database is also available via SQLGetInfo
                       by specifying the information type
                       SQL_DATABASE_NAME.)

   IFNULL(exp,value)   If <exp> is null, <value> is returned. If <exp>
                       is not null, <exp> is returned. The possible
                       data type(s) of <value> must be compatible with
                       the data type of <exp>.
				

Following is an example of how the USER() function could be used from within FoxPro to return the user's authorization name. This example assumes that a valid connection to an ODBC data source has already been established and that the connection handle is contained in the variable mhand:

FoxPro 2.x Example

      result=DBEXEC(mhand, "SELECT {FN USER()}","output")
				

Visual FoxPro Example

      result=SQLEXEC(mhand, "SELECT { FN USER() }", "output")