/**********************************************************************
* FILENAME : ListFunctions.c
*
* DESCRIPTION :
* Example to call SQLGetFunctions()
*
* ODBC USAGE :
* SQLGetFunctions with :
*
* SQL_API_ODBC3_ALL_FUNCTIONS
* - used by an ODBC 3.x application to determine support
* of ODBC 3.x and earlier functions
* SQL_API_ALL_FUNCTIONS
* - used by an ODBC 2.x application to determine support
* of ODBC 2.x and earlier functions
*/
#include <stdio.h>
#include <stdlib.h>
#include <sql.h>
#include <sqlext.h>
#include <string.h>
#include "util.c"
#define FUNCTIONS 100
main () {
SQLHENV henv = SQL_NULL_HENV; // Environment
SQLHDBC hdbc = SQL_NULL_HDBC; // Connection handle
SQLRETURN retcode;
SQLRETURN retcodeTables, retcodeColumns, retcodeStatistics;
SQLUSMALLINT fODBC3Exists[SQL_API_ODBC3_ALL_FUNCTIONS_SIZE];
SQLUSMALLINT fALLExists[FUNCTIONS];
// Allocate environment handle
retcode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
CHECK_ERROR(retcode, "SQLAllocHandle(SQL_HANDLE_ENV)",
henv, SQL_HANDLE_ENV);
// Set ODBC Version
retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
(SQLPOINTER*)SQL_OV_ODBC3, 0);
CHECK_ERROR(retcode, "SQLSetEnvAttr(SQL_ATTR_ODBC_VERSION)",
henv, SQL_HANDLE_ENV);
// Allocate connection handle
retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
CHECK_ERROR(retcode, "SQLAllocHandle(SQL_HANDLE_DBC)",
hdbc, SQL_HANDLE_DBC);
// Connect to datasource
retcode = SQLConnect(hdbc, (SQLCHAR*) "DATASOURCE", SQL_NTS,
(SQLCHAR*) NULL, 0, NULL, 0);
CHECK_ERROR(retcode, "SQLConnect(DATASOURCE)",
hdbc, SQL_HANDLE_DBC);
// SQL_API_ODBC3_ALL_FUNCTIONS is used by an ODBC 3.x application
// to determine the level of support of ODBC 3.x and earlier functions.
// SQL_API_ALL_FUNCTIONS is used by an ODBC 2.x application
// to determine the level of support of ODBC 2.x and earlier functions.
retcode = SQLGetFunctions(hdbc,
SQL_API_ODBC3_ALL_FUNCTIONS, fODBC3Exists);
CHECK_ERROR(retcode, "SQLGetFunctions(SQL_API_ODBC3_ALL_FUNCTIONS)",
hdbc, SQL_HANDLE_DBC);
// SQLGetFunctions has completed successfully. Check if SQLTables,
// SQLColumns, and SQLStatistics are supported by the driver.
if (retcode == SQL_SUCCESS &&
SQL_FUNC_EXISTS(fODBC3Exists, SQL_API_SQLTABLES) == SQL_TRUE &&
SQL_FUNC_EXISTS(fODBC3Exists, SQL_API_SQLCOLUMNS) == SQL_TRUE &&
SQL_FUNC_EXISTS(fODBC3Exists, SQL_API_SQLSTATISTICS) == SQL_TRUE)
{
printf ("ODBC3: SQLTables, SQLColumns, and SQLStatistics are supported\n");
}
retcode = SQLGetFunctions(hdbc,
SQL_API_ALL_FUNCTIONS, fALLExists);
CHECK_ERROR(retcode, "SQLAllocHandle(SQL_HANDLE_ENV)",
henv, SQL_HANDLE_ENV);
// SQLGetFunctions is completed successfully. Check if SQLTables,
// SQLColumns, and SQLStatistics are supported by the driver.
if (retcode == SQL_SUCCESS &&
fALLExists[SQL_API_SQLTABLES] == SQL_TRUE &&
fALLExists[SQL_API_SQLCOLUMNS] == SQL_TRUE &&
fALLExists[SQL_API_SQLSTATISTICS] == SQL_TRUE)
{
printf ("ODBC2: SQLTables, SQLColumns, and SQLStatistics are supported\n");
}
exit:
printf ("\nComplete.\n");
// Free handles
// Connection
if (hdbc != SQL_NULL_HDBC) {
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
}
// Environment
if (henv != SQL_NULL_HENV)
SQLFreeHandle(SQL_HANDLE_ENV, henv);
return 0;
}
Further information
