db2api.h

SQLAPI C/C++ 连接Oracle 数据库！

// db2API.h
//

#if !defined(__DB2API_H__)
#define __DB2API_H__

#include "SQLAPI.h"
#include <sqlcli.h>
#include <sqlcli1.h>

extern long g_nDB2DLLVersionLoaded;

extern void AddDB2Support();
extern void ReleaseDB2Support();

typedef SQLRETURN (SQL_API_FN  *SQLAllocConnect_t)(SQLHENV           henv,
                                        SQLHDBC     FAR   *phdbc);
typedef SQLRETURN (SQL_API_FN  *SQLAllocEnv_t)(SQLHENV     FAR   *phenv);
typedef SQLRETURN (SQL_API_FN *SQLAllocHandle_t)(    SQLSMALLINT fHandleType,
                                        SQLHANDLE hInput,
                                        SQLHANDLE * phOutput );
typedef SQLRETURN (SQL_API_FN  *SQLAllocStmt_t)(SQLHDBC           hdbc,
                                        SQLHSTMT    FAR   *phstmt);
typedef SQLRETURN (SQL_API_FN  *SQLBindCol_t)(SQLHSTMT          hstmt,
                                        SQLUSMALLINT      icol,
                                        SQLSMALLINT       fCType,
                                        SQLPOINTER        rgbValue,
                                        SQLLEN        cbValueMax,
                                        SQLLEN  FAR   *pcbValue);
typedef SQLRETURN (SQL_API_FN *SQLBindFileToCol_t)(SQLHSTMT          hstmt,
                                        SQLUSMALLINT      icol,
                                        SQLCHAR     FAR   *FileName,
                                        SQLSMALLINT FAR   *FileNameLength,
                                        SQLUINTEGER FAR   *FileOptions,
                                        SQLSMALLINT       MaxFileNameLength,
                                        SQLINTEGER  FAR   *StringLength,
                                        SQLINTEGER  FAR   *IndicatorValue);
typedef SQLRETURN (SQL_API_FN *SQLBindFileToParam_t)(SQLHSTMT          hstmt,
                                        SQLUSMALLINT      ipar,
                                        SQLSMALLINT       fSqlType,
                                        SQLCHAR     FAR   *FileName,
                                        SQLSMALLINT FAR   *FileNameLength,
                                        SQLUINTEGER FAR   *FileOptions,
                                        SQLSMALLINT       MaxFileNameLength,
                                        SQLINTEGER  FAR   *IndicatorValue);
typedef SQLRETURN (SQL_API *SQLBindParameter_t)(
	SQLHSTMT           hstmt,
	SQLUSMALLINT       ipar,
	SQLSMALLINT        fParamType,
	SQLSMALLINT        fCType,
	SQLSMALLINT        fSqlType,
	SQLULEN            cbColDef,   
	SQLSMALLINT        ibScale,
	SQLPOINTER         rgbValue,
	SQLLEN             cbValueMax, 
	SQLLEN             *pcbValue); 

typedef SQLRETURN (SQL_API *SQLBrowseConnect_t)(
    SQLHDBC            hdbc,
    SQLTCHAR               *szConnStrIn,
    SQLSMALLINT        cbConnStrIn,
    SQLTCHAR               *szConnStrOut,
    SQLSMALLINT        cbConnStrOutMax,
    SQLSMALLINT       *pcbConnStrOut);
typedef SQLRETURN (SQL_API_FN *SQLBuildDataLink_t)(  SQLHSTMT hStmt,
                                        SQLCHAR FAR * pszLinkType,
                                        SQLINTEGER cbLinkType,
                                        SQLCHAR FAR * pszDataLocation,
                                        SQLINTEGER cbDataLocation,
                                        SQLCHAR FAR * pszComment,
                                        SQLINTEGER cbComment,
                                        SQLCHAR FAR * pDataLink,
                                        SQLINTEGER cbDataLinkMax,
                                        SQLINTEGER FAR * pcbDataLink );
typedef SQLRETURN       (SQL_API *SQLBulkOperations_t)(
        SQLHSTMT                        StatementHandle,
        SQLSMALLINT                     Operation);
typedef SQLRETURN (SQL_API_FN  *SQLCancel_t)(SQLHSTMT          hstmt);
typedef SQLRETURN (SQL_API_FN *SQLCloseCursor_t)(    SQLHSTMT hStmt );
#ifdef ODBC64
typedef SQLRETURN (SQL_API_FN  *SQLColAttribute_t)(SQLHSTMT          hstmt,
                                        SQLUSMALLINT      icol,
                                        SQLUSMALLINT      fDescType,
                                        SQLPOINTER        rgbDesc,
                                        SQLSMALLINT       cbDescMax,
                                        SQLSMALLINT FAR   *pcbDesc,
                                        SQLLEN			  *pfDesc);
#else
typedef SQLRETURN (SQL_API_FN  *SQLColAttribute_t)(SQLHSTMT          hstmt,
                                        SQLUSMALLINT      icol,
                                        SQLUSMALLINT      fDescType,
                                        SQLPOINTER        rgbDesc,
                                        SQLSMALLINT       cbDescMax,
                                        SQLSMALLINT FAR   *pcbDesc,
                                        SQLPOINTER         pfDesc);
#endif
typedef SQLRETURN (SQL_API *SQLColAttributes_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       icol,
    SQLUSMALLINT       fDescType,
    SQLPOINTER         rgbDesc,
    SQLSMALLINT        cbDescMax,
    SQLSMALLINT           *pcbDesc,
    SQLLEN            *pfDesc);
typedef SQLRETURN (SQL_API *SQLColumnPrivileges_t)(
    SQLHSTMT           hstmt,
    SQLTCHAR               *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLTCHAR               *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLTCHAR               *szTableName,
    SQLSMALLINT        cbTableName,
    SQLTCHAR               *szColumnName,
    SQLSMALLINT        cbColumnName);
typedef SQLRETURN (SQL_API_FN  *SQLColumns_t)(SQLHSTMT          hstmt,
                                        SQLTCHAR     FAR   *szCatalogName,
                                        SQLSMALLINT       cbCatalogName,
                                        SQLTCHAR     FAR   *szSchemaName,
                                        SQLSMALLINT       cbSchemaName,
                                        SQLTCHAR     FAR   *szTableName,
                                        SQLSMALLINT       cbTableName,
                                        SQLTCHAR     FAR   *szColumnName,
                                        SQLSMALLINT       cbColumnName);
typedef SQLRETURN (SQL_API_FN  *SQLConnect_t)(SQLHDBC           hdbc,
                                        SQLTCHAR     FAR   *szDSN,
                                        SQLSMALLINT       cbDSN,
                                        SQLTCHAR     FAR   *szUID,
                                        SQLSMALLINT       cbUID,
                                        SQLTCHAR     FAR   *szAuthStr,
                                        SQLSMALLINT       cbAuthStr);
typedef SQLRETURN  (SQL_API_FN *SQLCopyDesc_t)(      SQLHDESC hDescSource,
                                        SQLHDESC hDescTarget );
typedef SQLRETURN (SQL_API_FN  *SQLDataSources_t)(SQLHENV           henv,
                                        SQLUSMALLINT      fDirection,
                                        SQLTCHAR     FAR   *szDSN,
                                        SQLSMALLINT       cbDSNMax,
                                        SQLSMALLINT FAR   *pcbDSN,
                                        SQLTCHAR     FAR   *szDescription,
                                        SQLSMALLINT       cbDescriptionMax,
                                        SQLSMALLINT FAR   *pcbDescription);
typedef SQLRETURN  (SQL_API *SQLDescribeCol_t)(SQLHSTMT StatementHandle,
           SQLUSMALLINT ColumnNumber, SQLTCHAR *ColumnName,
           SQLSMALLINT BufferLength, SQLSMALLINT *NameLength,
           SQLSMALLINT *DataType, SQLULEN *ColumnSize,
           SQLSMALLINT *DecimalDigits, SQLSMALLINT *Nullable);
typedef SQLRETURN (SQL_API *SQLDescribeParam_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       ipar,
    SQLSMALLINT           *pfSqlType,
    SQLULEN           *pcbParamDef,
    SQLSMALLINT           *pibScale,
    SQLSMALLINT           *pfNullable);
typedef SQLRETURN  (SQL_API *SQLDisconnect_t)(SQLHDBC ConnectionHandle);
typedef SQLRETURN (SQL_API *SQLDriverConnect_t)(
    SQLHDBC            hdbc,
    SQLHWND            hwnd,
    SQLTCHAR               *szConnStrIn,
    SQLSMALLINT        cbConnStrIn,
    SQLTCHAR           *szConnStrOut,
    SQLSMALLINT        cbConnStrOutMax,
    SQLSMALLINT           *pcbConnStrOut,
    SQLUSMALLINT       fDriverCompletion);
typedef SQLRETURN  (SQL_API *SQLEndTran_t)(SQLSMALLINT HandleType, SQLHANDLE Handle,
           SQLSMALLINT CompletionType);
typedef SQLRETURN (SQL_API_FN  *SQLError_t)(SQLHENV           henv,
                                        SQLHDBC           hdbc,
                                        SQLHSTMT          hstmt,
                                        SQLTCHAR     FAR   *szSqlState,
                                        SQLINTEGER  FAR   *pfNativeError,
                                        SQLTCHAR     FAR   *szErrorMsg,
                                        SQLSMALLINT       cbErrorMsgMax,
                                        SQLSMALLINT FAR   *pcbErrorMsg);

typedef SQLRETURN (SQL_API_FN  *SQLExecDirect_t)(SQLHSTMT          hstmt,
                                        SQLTCHAR     FAR   *szSqlStr,
                                        SQLINTEGER        cbSqlStr);
typedef SQLRETURN (SQL_API_FN  *SQLExecute_t)(SQLHSTMT          hstmt);
typedef SQLRETURN (SQL_API_FN  *SQLExtendedBind_t)(SQLHSTMT          hstmt,
                                          SQLSMALLINT       fBindCol,
                                          SQLSMALLINT       cRecords,
                                          SQLSMALLINT *     pfCType,
                                          SQLPOINTER  *     rgbValue,
                                          SQLINTEGER  *     cbValueMax,
                                          SQLUINTEGER *     puiPrecisionCType,
                                          SQLSMALLINT *     psScaleCType,
                                          SQLINTEGER  **    pcbValue,
                                          SQLINTEGER  **    piIndicatorPtr,
                                          SQLSMALLINT *     pfParamType,
                                          SQLSMALLINT *     pfSQLType,
                                          SQLUINTEGER *     pcbColDef,
                                          SQLSMALLINT *     pibScale );
typedef SQLRETURN (SQL_API *SQLExtendedFetch_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       fFetchType,
    SQLLEN         irow,
    SQLULEN           *pcrow,
    SQLUSMALLINT          *rgfRowStatus);
typedef SQLRETURN (SQL_API_FN *SQLExtendedPrepare_t)( SQLHSTMT      hstmt,
                                         SQLTCHAR *     pszSqlStmt,
                                         SQLINTEGER    cbSqlStmt,
                                         SQLINTEGER    cPars,
                                         SQLSMALLINT   sStmtType,
                                         SQLINTEGER    cStmtAttrs,
                                         SQLINTEGER *  piStmtAttr,
                                         SQLINTEGER *  pvParams );