Full text search
function	SQL_FUNC_EXISTS

Sample Code

Related Syntax

Other Library Functions

Library: ODBC Include: omodbc.xin

Returns: Numeric The function existence code: SQL_FALSE (the functions are not supported) or SQL_TRUE (the functions are supported).

Declaration

  define external counter function SQL_FUNC_EXISTS
     ( modifiable SQL_array_type Supported,
       value counter FunctionId )

Purpose

Determines support of a specific ODBC 3.0 (or earlier) function after a call to SQLGetFunctions using SQL_API_ODBC3_ALL_FUNCTIONS as an argument.

Input argument: FunctionID. The ID of the function of interest. The following values are allowed:

• SQL_API_SQLBULKOPERATIONS
• SQL_API_SQLBINDPARAMETER
• SQL_API_SQLBROWSECONNECT
• SQL_API_SQLCOLATTRIBUTES
• SQL_API_SQLCOLUMNPRIVILEGES
• SQL_API_SQLDESCRIBEPARAM
• SQL_API_SQLDRIVERCONNECT
• SQL_API_SQLDRIVERS
• SQL_API_SQLEXTENDEDFETCH
• SQL_API_SQLFOREIGNKEYS
• SQL_API_SQLMORERESULTS
• SQL_API_SQLNATIVESQL
• SQL_API_SQLNUMPARAMS
• SQL_API_SQLPARAMOPTIONS
• SQL_API_SQLPRIMARYKEYS
• SQL_API_SQLPROCEDURECOLUMNS
• SQL_API_SQLPROCEDURES
• SQL_API_SQLSETPOS
• SQL_API_SQLSETSCROLLOPTIONS
• SQL_API_SQLTABLEPRIVILEGES
• SQL_API_SQLALLOCCONNECT
• SQL_API_SQLALLOCENV
• SQL_API_SQLALLOCHANDLE
• SQL_API_SQLALLOCSTMT
• SQL_API_SQLBINDCOL
• SQL_API_SQLBINDPARAM
• SQL_API_SQLCANCEL
• SQL_API_SQLCLOSECURSOR
• SQL_API_SQLCOLATTRIBUTE
• SQL_API_SQLCOLUMNS
• SQL_API_SQLCONNECT
• SQL_API_SQLCOPYDESC
• SQL_API_SQLDATASOURCES
• SQL_API_SQLDESCRIBECOL
• SQL_API_SQLDISCONNECT
• SQL_API_SQLENDTRAN
• SQL_API_SQLERROR
• SQL_API_SQLEXECDIRECT
• SQL_API_SQLEXECUTE
• SQL_API_SQLFETCH
• SQL_API_SQLFETCHSCROLL
• SQL_API_SQLFREECONNECT
• SQL_API_SQLFREEENV
• SQL_API_SQLFREEHANDLE
• SQL_API_SQLFREESTMT
• SQL_API_SQLGETCONNECTATTR
• SQL_API_SQLGETCONNECTOPTION
• SQL_API_SQLGETCURSORNAME
• SQL_API_SQLGETDATA
• SQL_API_SQLGETDESCFIELD
• SQL_API_SQLGETDESCREC
• SQL_API_SQLGETDIAGFIELD
• SQL_API_SQLGETDIAGREC
• SQL_API_SQLGETENVATTR
• SQL_API_SQLGETFUNCTIONS
• SQL_API_SQLGETINFO
• SQL_API_SQLGETSTMTATTR
• SQL_API_SQLGETSTMTOPTION
• SQL_API_SQLGETTYPEINFO
• SQL_API_SQLNUMRESULTCOLS
• SQL_API_SQLPARAMDATA
• SQL_API_SQLPREPARE
• SQL_API_SQLPUTDATA
• SQL_API_SQLROWCOUNT
• SQL_API_SQLSETCONNECTATTR
• SQL_API_SQLSETCONNECTOPTION
• SQL_API_SQLSETCURSORNAME
• SQL_API_SQLSETDESCFIELD
• SQL_API_SQLSETDESCREC
• SQL_API_SQLSETENVATTR
• SQL_API_SQLSETPARAM
• SQL_API_SQLSETSTMTATTR
• SQL_API_SQLSETSTMTOPTION
• SQL_API_SQLSPECIALCOLUMNS
• SQL_API_SQLSTATISTICS
• SQL_API_SQLTABLES
• SQL_API_SQLTRANSACT

Output argument:

• Supported. The support indicator variable used in the call to SQLGetFunctions.

Sample Code      ODBC connections

Related Syntax    SQLGetFunctions    SQLGetInfo

Other Library Functions    SQL_FUNC_EXISTS    SQL_LibraryVersion    SQLAllocConnect    SQLAllocEnv    SQLAllocHandle    SQLAllocStmt    SQLBindCol    SQLBindParameter    SQLBrowseConnect    SQLBulkOperations    SQLCancel    SQLCloseCursor    SQLColAttribute    SQLColAttributes    SQLColumnPrivileges    SQLColumns    SQLConnect    SQLCopyDesc    SQLDataSources    SQLDescribeCol    SQLDescribeParam    SQLDisconnect    SQLDriverConnect    SQLDrivers    SQLEndTran    SQLError    SQLExecDirect    SQLExecute    SQLExtendedFetch    SQLFetch    SQLFetchScroll    SQLForeignKeys    SQLFreeConnect    SQLFreeEnv    SQLFreeHandle    SQLFreeStmt    SQLGetArrayAsCounter    SQLGetArrayAsCounterShelf    SQLGetArrayAsStream    SQLGetArrayAsStreamShelf    SQLGetArrayAsString    SQLGetArrayElementCount    SQLGetArrayElementLen    SQLGetConnectAttr    SQLGetConnectOption    SQLGetCursorName    SQLGetData    SQLGetDescField    SQLGetDescRec    SQLGetDiagField    SQLGetDiagRec    SQLGetEnvAttr    SQLGetFunctions    SQLGetInfo    SQLGetStmtAttr    SQLGetStmtOption    SQLGetTypeInfo    SQLGetVectorAsCounter    SQLGetVectorAsStream    SQLGetVectorAsString    SQLGetVectorSize    SQLMoreResults    SQLNativeSQL    SQLNumParams    SQLNumResultCols    SQLParamOptions    SQLPrepare    SQLPrimaryKeys    SQLProcedureColumns    SQLProcedures    SQLPutData    SQLRowCount    SQLSetArrayAsCounter    SQLSetArrayAsCounterShelf    SQLSetArrayAsStream    SQLSetArrayAsStreamShelf    SQLSetArrayAsString    SQLSetArraySize    SQLSetConnectAttr    SQLSetConnectOption    SQLSetCursorName    SQLSetDescField    SQLSetDescRec    SQLSetEnvAttr    SQLSetPos    SQLSetScrollOptions    SQLSetStmtAttr    SQLSetStmtOption    SQLSetVectorAsCounter    SQLSetVectorAsStream    SQLSetVectorAsString    SQLSetVectorSize    SQLSpecialColumns    SQLStatistics    SQLTablePrivileges    SQLTables    SQLTransact

----

[CONTENTS] [CONCEPTS] [SYNTAX] [LIBRARIES] [SAMPLES] [ERRORS] [INDEX]

Copyright © OmniMark Technologies Corporation, 1988-1999.