지원 함수와 하위 호환성

CUBRID ODBC에서 지원하는 함수 목록, ODBC Spec 버전 및 호환성은 다음 표를 참고한다.

API

Version Introduced

Standards Compliance

Support

SQLAllocHandle

3.0

ISO 92

YES

SQLBindCol

1.0

ISO 92

YES

SQLBindParameter

2.0

ODBC

YES

SQLBrowseConnect

1.0

ODBC

NO

SQLBulkOperations

3.0

ODBC

YES

SQLCancel

1.0

ISO 92

YES

SQLCloseCursor

3.0

ISO 92

YES

SQLColAttribute

3.0

ISO 92

YES

SQLColumnPrivileges

1.0

ODBC

NO

SQLColumns

1.0

X/Open

YES

SQLConnect

1.0

ISO 92

YES

SQLCopyDesc

3.0

ISO 92

YES

SQLDescribeCol

1.0

ISO 92

YES

SQLDescribeParam

1.0

ODBC

NO

SQLDisconnect

1.0

ISO 92

YES

SQLDriverConnect

1.0

ODBC

YES

SQLEndTran

3.0

ISO 92

YES

SQLExecDirect

1.0

ISO 92

YES

SQLExecute

1.0

ISO 92

YES

SQLFetch

1.0

ISO 92

YES

SQLFetchScroll

3.0

ISO 92

YES

SQLForeignKeys

1.0

ODBC

YES(2008 R3.1이상 버전)

SQLFreeHandle

3.0

ISO 92

YES

SQLFreeStmt

1.0

ISO 92

YES

SQLGetConnectAttr

3.0

ISO 92

YES

SQLGetCursorName

1.0

ISO 92

YES

SQLGetData

1.0

ISO 92

YES

SQLGetDescField

3.0

ISO 92

YES

SQLGetDescRec

3.0

ISO 92

YES

SQLGetDiagField

3.0

ISO 92

YES

SQLGetDiagRec

3.0

ISO 92

YES

SQLGetEnvAttr

3.0

ISO 92

YES

SQLGetFunctions

1.0

ISO 92

YES

SQLGetInfo

1.0

ISO 92

YES

SQLGetStmtAttr

3.0

ISO 92

YES

SQLGetTypeInfo

1.0

ISO 92

YES

SQLMoreResults

1.0

ODBC

YES

SQLNativeSql

1.0

ODBC

YES

SQLNumParams

1.0

ISO 92

YES

SQLNumResultCols

1.0

ISO 92

YES

SQLParamData

1.0

ISO 92

YES

SQLPrepare

1.0

ISO 92

YES

SQLPrimaryKeys

1.0

ODBC

YES(2008 R3.1이상 버전)

SQLProcedureColumns

1.0

ODBC

YES(2008 R3.1이상 버전)

SQLProcedures

1.0

ODBC

YES(2008 R3.1이상 버전)

SQLPutData

1.0

ISO 92

YES

SQLRowCount

1.0

ISO 92

YES

SQLSetConnectAttr

3.0

ISO 92

YES

SQLSetCursorName

1.0

ISO 92

YES

SQLSetDescField

3.0

ISO 92

YES

SQLSetDescRec

3.0

ISO 92

YES

SQLSetEnvAttr

3.0

ISO 92

NO

SQLSetPos

1.0

ODBC

YES

SQLSetStmtAttr

3.0

ISO 92

YES

SQLSpecialColumns

1.0

X/Open

YES

SQLStatistics

1.0

ISO 92

YES

SQLTablePrivileges

1.0

ODBC

YES(2008 R3.1이상 버전)

SQLTables

1.0

X/Open

YES

ODBC 3.x에서 하위 호환성을 지원하지 않는 일부 함수에 대해서는 아래의 매핑 테이블을 참고하여 적합한 함수로 변환한다.

ODBC 2.x 함수

ODBC 3.x 함수

SQLAllocConnect

SQLAllocHandle

SQLAllocEnv

SQLAllocHandle

SQLAllocStmt

SQLAllocHandle

SQLBindParam

SQLBindParameter

SQLColAttributes

SQLColAttribute

SQLError

SQLGetDiagRec

SQLFreeConnect

SQLFreeHandle

SQLFreeEnv

SQLFreeHandle

SQLFreeStmt with SQL_DROP

SQLFreeHandle

SQLGetConnectOption

SQLGetConnectAttr

SQLGetStmtOption

SQLGetStmtAttr

SQLParamOptions

SQLSetStmtAttr

SQLSetConnectOption

SQLSetConnectAttr

SQLSetParam

SQLBindParameter

SQLSetScrollOption

SQLSetStmtAttr

SQLSetStmtOption

SQLSetStmtAttr

SQLTransact

SQLEndTran