db2api.h

能够连接各种数据库的API

           SQLSMALLINT RecNumber, SQLSMALLINT FieldIdentifier,
           SQLPOINTER Value, SQLINTEGER BufferLength);
typedef SQLRETURN  (SQL_API_FN *SQLSetDescRec_t)(SQLHDESC DescriptorHandle,
           SQLSMALLINT RecNumber, SQLSMALLINT Type,
           SQLSMALLINT SubType, SQLINTEGER Length,
           SQLSMALLINT Precision, SQLSMALLINT Scale,
           SQLPOINTER Data, SQLINTEGER *StringLength,
           SQLINTEGER *Indicator);
typedef SQLRETURN (SQL_API_FN *SQLSetEnvAttr_t)(SQLHENV           henv,
                                        SQLINTEGER        Attribute,
                                        SQLPOINTER        Value,
                                        SQLINTEGER        StringLength);
typedef SQLRETURN (SQL_API_FN  *SQLSetParam_t)(SQLHSTMT          hstmt,
                                        SQLUSMALLINT      ipar,
                                        SQLSMALLINT       fCType,
                                        SQLSMALLINT       fSqlType,
                                        SQLUINTEGER       cbParamDef,
                                        SQLSMALLINT       ibScale,
                                        SQLPOINTER        rgbValue,
                                        SQLINTEGER  FAR   *pcbValue);
typedef SQLRETURN (SQL_API *SQLSetPos_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       irow,
    SQLUSMALLINT       fOption,
    SQLUSMALLINT       fLock);
typedef SQLRETURN (SQL_API_FN  *SQLSetStmtAttr_t)(SQLHSTMT          hstmt,
                                        SQLINTEGER        fOption,
                                        SQLPOINTER        pvParam,
                                        SQLINTEGER       fStrLen);
typedef SQLRETURN (SQL_API_FN  *SQLSetStmtOption_t)(SQLHSTMT          hstmt,
                                        SQLUSMALLINT      fOption,
                                        SQLUINTEGER       vParam);
typedef SQLRETURN (SQL_API_FN  *SQLSpecialColumns_t)(SQLHSTMT          hstmt,
                                        SQLUSMALLINT      fColType,
                                        SQLCHAR     FAR   *szCatalogName,
                                        SQLSMALLINT       cbCatalogName,
                                        SQLCHAR     FAR   *szSchemaName,
                                        SQLSMALLINT       cbSchemaName,
                                        SQLCHAR     FAR   *szTableName,
                                        SQLSMALLINT       cbTableName,
                                        SQLUSMALLINT      fScope,
                                        SQLUSMALLINT      fNullable);
typedef SQLRETURN (SQL_API_FN  *SQLStatistics_t)(SQLHSTMT          hstmt,
                                        SQLCHAR     FAR   *szCatalogName,
                                        SQLSMALLINT       cbCatalogName,
                                        SQLCHAR     FAR   *szSchemaName,
                                        SQLSMALLINT       cbSchemaName,
                                        SQLCHAR     FAR   *szTableName,
                                        SQLSMALLINT       cbTableName,
                                        SQLUSMALLINT      fUnique,
                                        SQLUSMALLINT      fAccuracy);
typedef SQLRETURN (SQL_API *SQLTablePrivileges_t)(
    SQLHSTMT           hstmt,
    SQLCHAR               *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR               *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR               *szTableName,
    SQLSMALLINT        cbTableName);
typedef SQLRETURN (SQL_API_FN  *SQLTables_t)(SQLHSTMT          hstmt,
                                        SQLCHAR     FAR   *szCatalogName,
                                        SQLSMALLINT       cbCatalogName,
                                        SQLCHAR     FAR   *szSchemaName,
                                        SQLSMALLINT       cbSchemaName,
                                        SQLCHAR     FAR   *szTableName,
                                        SQLSMALLINT       cbTableName,
                                        SQLCHAR     FAR   *szTableType,
                                        SQLSMALLINT       cbTableType);
typedef SQLRETURN (SQL_API_FN  *SQLTransact_t)(SQLHENV           henv,
                                        SQLHDBC           hdbc,
                                        SQLUSMALLINT      fType);


class SQLAPI_API db2API : public saAPI
{
public:
	db2API();

	SQLAllocConnect_t	SQLAllocConnect;
	SQLAllocEnv_t	SQLAllocEnv;
	SQLAllocHandle_t	SQLAllocHandle;
	SQLAllocStmt_t	SQLAllocStmt;
	SQLBindCol_t	SQLBindCol;
	SQLBindFileToCol_t	SQLBindFileToCol;
	SQLBindFileToParam_t	SQLBindFileToParam;
	SQLBindParameter_t	SQLBindParameter;
	SQLBrowseConnect_t	SQLBrowseConnect;
	SQLBuildDataLink_t	SQLBuildDataLink;
	SQLBulkOperations_t	SQLBulkOperations;
	SQLCancel_t	SQLCancel;
	SQLCloseCursor_t	SQLCloseCursor;
	SQLColAttribute_t	SQLColAttribute;
	SQLColAttributes_t	SQLColAttributes;
	SQLColumnPrivileges_t	SQLColumnPrivileges;
	SQLColumns_t	SQLColumns;
	SQLConnect_t	SQLConnect;
	SQLCopyDesc_t	SQLCopyDesc;
	SQLDataSources_t	SQLDataSources;
	SQLDescribeCol_t	SQLDescribeCol;
	SQLDescribeParam_t	SQLDescribeParam;
	SQLDisconnect_t	SQLDisconnect;
	SQLDriverConnect_t	SQLDriverConnect;
	SQLEndTran_t	SQLEndTran;
	SQLError_t	SQLError;
	SQLExecDirect_t	SQLExecDirect;
	SQLExecute_t	SQLExecute;
	SQLExtendedBind_t	SQLExtendedBind;
	SQLExtendedFetch_t	SQLExtendedFetch;
	SQLExtendedPrepare_t	SQLExtendedPrepare;
	SQLFetch_t	SQLFetch;
	SQLFetchScroll_t	SQLFetchScroll;
	SQLForeignKeys_t	SQLForeignKeys;
	SQLFreeConnect_t	SQLFreeConnect;
	SQLFreeEnv_t	SQLFreeEnv;
	SQLFreeHandle_t	SQLFreeHandle;
	SQLFreeStmt_t	SQLFreeStmt;
	SQLGetConnectAttr_t	SQLGetConnectAttr;
	SQLGetConnectOption_t	SQLGetConnectOption;
	SQLGetCursorName_t	SQLGetCursorName;
	SQLGetData_t	SQLGetData;
	SQLGetDataLinkAttr_t	SQLGetDataLinkAttr;
	SQLGetDescField_t	SQLGetDescField;
	SQLGetDescRec_t	SQLGetDescRec;
	SQLGetDiagField_t	SQLGetDiagField;
	SQLGetDiagRec_t	SQLGetDiagRec;
	SQLGetEnvAttr_t	SQLGetEnvAttr;
	SQLGetFunctions_t	SQLGetFunctions;
	SQLGetInfo_t	SQLGetInfo;
	SQLGetLength_t	SQLGetLength;
	SQLGetPosition_t	SQLGetPosition;
	SQLGetSQLCA_t	SQLGetSQLCA;
	SQLGetStmtAttr_t	SQLGetStmtAttr;
	SQLGetStmtOption_t	SQLGetStmtOption;
	SQLGetSubString_t	SQLGetSubString;
	SQLGetTypeInfo_t	SQLGetTypeInfo;
	SQLMoreResults_t	SQLMoreResults;
	SQLNativeSql_t	SQLNativeSql;
	SQLNumParams_t	SQLNumParams;
	SQLNumResultCols_t	SQLNumResultCols;
	SQLParamData_t	SQLParamData;
	SQLParamOptions_t	SQLParamOptions;
	SQLPrepare_t	SQLPrepare;
	SQLPrimaryKeys_t	SQLPrimaryKeys;
	SQLProcedureColumns_t	SQLProcedureColumns;
	SQLProcedures_t	SQLProcedures;
	SQLPutData_t	SQLPutData;
	SQLRowCount_t	SQLRowCount;
	SQLSetColAttributes_t	SQLSetColAttributes;
	SQLSetConnectAttr_t	SQLSetConnectAttr;
	SQLSetConnection_t	SQLSetConnection;
	SQLSetConnectOption_t	SQLSetConnectOption;
	SQLSetCursorName_t	SQLSetCursorName;
	SQLSetDescField_t	SQLSetDescField;
	SQLSetDescRec_t	SQLSetDescRec;
	SQLSetEnvAttr_t	SQLSetEnvAttr;
	SQLSetParam_t	SQLSetParam;
	SQLSetPos_t	SQLSetPos;
	SQLSetStmtAttr_t	SQLSetStmtAttr;
	SQLSetStmtOption_t	SQLSetStmtOption;
	SQLSpecialColumns_t	SQLSpecialColumns;
	SQLStatistics_t	SQLStatistics;
	SQLTablePrivileges_t	SQLTablePrivileges;
	SQLTables_t	SQLTables;
	SQLTransact_t	SQLTransact;
};

class SQLAPI_API db2ConnectionHandles : public saConnectionHandles
{
public:
	db2ConnectionHandles();

	SQLHENV	m_hevn;
	SQLHDBC	m_hdbc;
};

class SQLAPI_API db2CommandHandles : public saCommandHandles
{
public:
	db2CommandHandles();

	SQLHSTMT	m_hstmt;
};

class SQLAPI_API db2Exception : public SAException
{
public:
	SQLRETURN return_code;
	SQLCHAR Sqlstate[5+1];
	SQLINTEGER NativeError;

private:
	db2Exception(
		SQLRETURN return_code,
		SQLCHAR Sqlstate[5+1],
		SQLINTEGER NativeError,
		const SAString &sMsg);

	friend class Idb2Connection;
};

extern db2API g_db2API;

#endif // !defined(AFX_DB2API_H__11EAA72A_EFF5_4944_8B1F_44973D30EF73__INCLUDED_)