ODBC Supported APIs¶

The following APIs are supported for ODBC in Snappy Driver:

Function APIs
Attribute APIs

Function Conformance of ODBC Supported APIs in Snappy Driver¶

Function	Conformance level	Supported in Snappy Driver	Exceptions
SQLAllocHandle	Core	Yes
SQLBindCol	Core	Yes
SQLBindParameter	Core[1]	Yes
SQLBrowseConnect	Level 1	No
SQLBulkOperations	Level 1	Yes
SQLCancel	Core[1]	Yes
SQLCancelHandle	Core[1]	Yes
SQLCloseCursor	Core	Yes
SQLColAttribute	Core[1]	Yes
SQLColumnPrivileges	Level 2	Yes
SQLColumns	Core	Yes
SQLConnect	Core	Yes
SQLCopyDesc	Core	No
SQLDataSources	Core	No	It should be implemented by the Driver Manager.
SQLDescribeCol	Core[1]	Yes
SQLDescribeParam	Level 2	Yes
SQLDisconnect	Core	Yes
SQLDriverConnect	Core	Yes
SQLDrivers	Core	No	It should be implemented by the Driver Manager.
SQLEndTran	Core[1]	Yes
SQLExecDirect	Core	Yes
SQLExecute	Core	Yes
SQLFetch	Core	Yes
SQLFetchScroll	Core[1]	Yes
SQLForeignKeys	Level 2	Yes
SQLFreeHandle	Core	Yes
SQLFreeStmt	Core	Yes
SQLGetConnectAttr	Core	Yes
SQLGetCursorName	Core	Yes
SQLGetData	Core	Yes
SQLGetDescField	Core	No
SQLGetDescRec	Core	No
SQLGetDiagField	Core	Yes
SQLGetDiagRec	Core	Yes
SQLGetEnvAttr	Core	Yes
SQLGetFunctions	Core	Yes
SQLGetInfo	Core	Yes	SQL_DEFAULT_TXN_ISOLATION - not supported SQL_TXN_ISOLATION_OPTION -not supported SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1 supported SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2 supported
SQLGetStmtAttr	Core	Yes
SQLGetTypeInfo	Core	Yes	Supports call only with SQL_ALL_TYPES info type parameter
SQLMoreResults	Level 1	Yes
SQLNativeSql	Core	Yes
SQLNumParams	Core	Yes
SQLNumResultCols	Core	Yes
SQLParamData	Core	Yes
SQLPrepare	Core	Yes
SQLPrimaryKeys	Level 1	Yes
SQLProcedureColumns	Level 1	Yes
SQLProcedures	Level 1	Yes
SQLPutData	Core	Yes
SQLRowCount	Core	Yes
SQLSetConnectAttr	Core[2]	Yes
SQLSetCursorName	Core	Yes
SQLSetDescField	Core[1]	No
SQLSetDescRec	Core	No
SQLSetEnvAttr	Core[2]	Yes
SQLSetPos	Level 1[1]	Yes
SQLSetStmtAttr	Core[2]	Yes
SQLSpecialColumns	Core[1]	Yes
SQLStatistics	Core	Yes
SQLTablePrivileges	Level 2	Yes
SQLTables	Core	Yes

Attribute Conformance of ODBC Supported APIs in Snappy Driver¶

ODBC Environment Attribute¶

Attributes	Conformance Level	Supported in Snappy Driver	Exceptions
SQL_ATTR_CONNECTION_POOLING	[1]	Yes	This is an optional feature and as such is not part of the conformance levels.
SQL_ATTR_CP_MATCH	[1]	Yes
SQL_ATTR_ODBC_VER	Core	Yes
SQL_ATTR_OUTPUT_NTS	[1]	Yes

ODBC Connection Attribute¶

Attributes	Conformance Level	Supported in Snappy Driver	Exceptions
SQL_ATTR_ACCESS_MODE	Core	Yes
SQL_ATTR_ASYNC_ENABLE	Level 1/Level 2[1]	Yes	Applications that support connection-level asynchronously (required for Level 1) must support setting this attribute to SQL_TRUE by calling SQLSetConnectAttr; the attribute need not be settable to a value other than its default value through SQLSetStmtAttr. Applications that support statement-level asynchronously (required for Level 2) must support setting this attribute to SQL_TRUE using either function.
SQL_ATTR_AUTO_IPD	Level 2	No
SQL_ATTR_AUTOCOMMIT	Level 1	Yes	For Level 1 interface conformance, the driver must support one value in addition to the driver-defined default value (available by calling SQLGetInfo with the SQL_DEFAULT_TXN_ISOLATION option). For Level 2 interface conformance, the driver must also support SQL_TXN_SERIALIZABLE.
SQL_ATTR_CONNECTION_DEAD	Level 1	Yes
SQL_ATTR_CONNECTION_TIMEOUT	Level 2	Yes
SQL_ATTR_CURRENT_CATALOG	Level 2	Yes
SQL_ATTR_LOGIN_TIMEOUT	Level 2	Yes
SQL_ATTR_ODBC_CURSORS	Core	Yes
SQL_ATTR_PACKET_SIZE	Level 2	Yes
SQL_ATTR_QUIET_MODE	Core	Yes
SQL_ATTR_TRACE	Core	Yes
SQL_ATTR_TRACEFILE	Core	Yes
SQL_ATTR_TRANSLATE_LIB	Core	Yes
SQL_ATTR_TRANSLATE_OPTION	Core	Yes
SQL_ATTR_TXN_ISOLATION	Level 1/Level 2[2]	Yes

ODBC Statement Attribute¶

Attributes	Conformance Level	Supported in Snappy Driver	Exceptions
SQL_ATTR_APP_PARAM_DESC	Core	Yes
SQL_ATTR_APP_ROW_DESC	Core	Yes
SQL_ATTR_ASYNC_ENABLE	Level 1/Level 2[1]	Yes
SQL_ATTR_CONCURRENCY	Level 1/Level 2[2]	Yes
SQL_ATTR_CURSOR_SCROLLABLE	Level 1	Yes
SQL_ATTR_CURSOR_SENSITIVITY	Level 2	Yes
SQL_ATTR_CURSOR_TYPE	Core/Level 2[3]	Yes	Applications that support connection-level asynchronously (required for Level 1) must support setting this attribute to SQL_TRUE by calling SQLSetConnectAttr; the attribute need not be settable to a value other than its default value through SQLSetStmtAttr. Applications that support statement-level asynchronously (required for Level 2) must support setting this attribute to SQL_TRUE using either function.
SQL_ATTR_ENABLE_AUTO_IPD	Level 2	Yes
SQL_ATTR_FETCH_BOOKMARK_PTR	Level 2	Yes	For Level 2 interface conformance, the driver must support SQL_CONCUR_READ_ONLY and at least one other value.
SQL_ATTR_IMP_PARAM_DESC	Core	Yes
SQL_ATTR_IMP_ROW_DESC	Core	Yes	For Level 1 interface conformance, the driver must support SQL_CURSOR_FORWARD_ONLY and at least one other value. For Level 2 interface conformance, the driver must support all values defined in this document.
SQL_ATTR_KEYSET_SIZE	Level 2	Yes
SQL_ATTR_MAX_LENGTH	Level 1	Yes
SQL_ATTR_MAX_ROWS	Level 1	Yes
SQL_ATTR_METADATA_ID	Core	Yes
SQL_ATTR_NOSCAN	Core	Yes
SQL_ATTR_PARAM_BIND_OFFSET_PTR	Core	Yes
SQL_ATTR_PARAM_BIND_TYPE	Core	Yes
SQL_ATTR_PARAM_OPERATION_PTR	Core	Yes
SQL_ATTR_PARAM_STATUS_PTR	Core	Yes
SQL_ATTR_PARAMS_PROCESSED_PTR	Core	Yes
SQL_ATTR_PARAMSET_SIZE	Core	Yes
SQL_ATTR_QUERY_TIMEOUT	Level 2	Yes
SQL_ATTR_RETRIEVE_DATA	Level 1	Yes
SQL_ATTR_ROW_ARRAY_SIZE	Core	Yes
SQL_ATTR_ROW_BIND_OFFSET_PTR	Core	Yes
SQL_ATTR_ROW_BIND_TYPE	Core	Yes
SQL_ATTR_ROW_NUMBER	Level 1	Yes
SQL_ATTR_ROW_OPERATION_PTR	Level 1	Yes
SQL_ATTR_ROW_STATUS_PTR	Core	Yes
SQL_ATTR_ROWS_FETCHED_PTR	Core	Yes
SQL_ATTR_SIMULATE_CURSOR	Level 2	No
SQL_ATTR_USE_BOOKMARKS	Level 2	No