sql.h

能够连接各种数据库的API

#define SQL_OJ_FULL				0x00000004L
#define SQL_OJ_NESTED				0x00000008L
#define SQL_OJ_NOT_ORDERED			0x00000010L
#define SQL_OJ_INNER				0x00000020L
#define SQL_OJ_ALL_COMPARISON_OPS		0x00000040L
#endif


/*
 *  SQLGetInfo - SQL_SCROLL_CONCURRENCY
 */
#define SQL_SCCO_READ_ONLY			0x00000001L
#define SQL_SCCO_LOCK				0x00000002L
#define SQL_SCCO_OPT_ROWVER			0x00000004L
#define SQL_SCCO_OPT_VALUES			0x00000008L


/*
 *  SQLGetInfo - SQL_TXN_CAPABLE
 */
#define SQL_TC_NONE				0
#define SQL_TC_DML				1
#define SQL_TC_ALL				2
#define SQL_TC_DDL_COMMIT			3
#define SQL_TC_DDL_IGNORE			4


/*
 *  SQLGetInfo - SQL_TXN_ISOLATION_OPTION
 */
#define SQL_TXN_READ_UNCOMMITTED		0x00000001L
#define SQL_TRANSACTION_READ_UNCOMMITTED	SQL_TXN_READ_UNCOMMITTED
#define SQL_TXN_READ_COMMITTED			0x00000002L
#define SQL_TRANSACTION_READ_COMMITTED		SQL_TXN_READ_COMMITTED
#define SQL_TXN_REPEATABLE_READ			0x00000004L
#define SQL_TRANSACTION_REPEATABLE_READ		SQL_TXN_REPEATABLE_READ
#define SQL_TXN_SERIALIZABLE			0x00000008L
#define SQL_TRANSACTION_SERIALIZABLE		SQL_TXN_SERIALIZABLE



/*
 *  SQLGetStmtAttr - statement attributes
 */
#if (ODBCVER >= 0x0300)
#define SQL_ATTR_APP_ROW_DESC			10010
#define SQL_ATTR_APP_PARAM_DESC			10011
#define SQL_ATTR_IMP_ROW_DESC			10012
#define SQL_ATTR_IMP_PARAM_DESC			10013
#define SQL_ATTR_CURSOR_SCROLLABLE		(-1)
#define SQL_ATTR_CURSOR_SENSITIVITY		(-2)
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetStmtAttr - SQL_ATTR_CURSOR_SCROLLABLE
 */
#if (ODBCVER >= 0x0300)
#define SQL_NONSCROLLABLE			0
#define SQL_SCROLLABLE				1
#endif	/* ODBCVER >= 0x0300 */


/*
 *  SQLGetStmtAttr - SQL_ATTR_CURSOR_SENSITIVITY
 */
#if (ODBCVER >= 0x0300)
#define SQL_UNSPECIFIED				0
#define SQL_INSENSITIVE				1
#define SQL_SENSITIVE				2
#endif	/* ODBCVER >= 0x0300 */



/*
 *  SQLGetTypeInfo - SEARCHABLE
 */
#if (ODBCVER >= 0x0300)
#define SQL_PRED_NONE				0
#define SQL_PRED_CHAR				1
#define SQL_PRED_BASIC				2
#endif	/* ODBCVER >= 0x0300 */



/*
 *  SQLSpecialColumns - Column scopes
 */
#define SQL_SCOPE_CURROW			0
#define SQL_SCOPE_TRANSACTION 			1
#define SQL_SCOPE_SESSION			2


/*
 *  SQLSpecialColumns - PSEUDO_COLUMN
 */
#define SQL_PC_UNKNOWN				0
#if (ODBCVER >= 0x0300)
#define SQL_PC_NON_PSEUDO			1
#endif	/* ODBCVER >= 0x0300 */
#define SQL_PC_PSEUDO				2


/*
 *  SQLSpecialColumns - IdentifierType
 */
#if (ODBCVER >= 0x0300)
#define SQL_ROW_IDENTIFIER			1
#endif	/* ODBCVER >= 0x0300 */



/*
 *  SQLStatistics - fUnique
 */
#define SQL_INDEX_UNIQUE			0
#define SQL_INDEX_ALL				1


/*
 *  SQLStatistics - TYPE
 */
#define SQL_INDEX_CLUSTERED 			1
#define SQL_INDEX_HASHED			2
#define SQL_INDEX_OTHER				3



/*
 *  SQLTransact/SQLEndTran
 */
#define SQL_COMMIT				0
#define SQL_ROLLBACK				1



/*
 *  Function Prototypes
 */
SQLRETURN SQL_API SQLAllocConnect (
    SQLHENV EnvironmentHandle,
    SQLHDBC * ConnectionHandle);


SQLRETURN SQL_API SQLAllocEnv (
    SQLHENV * EnvironmentHandle);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLAllocHandle (
    SQLSMALLINT HandleType,
    SQLHANDLE InputHandle,
    SQLHANDLE * OutputHandle);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLAllocStmt (
    SQLHDBC ConnectionHandle,
    SQLHSTMT * StatementHandle);


SQLRETURN SQL_API SQLBindCol (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT ColumnNumber,
    SQLSMALLINT TargetType,
    SQLPOINTER TargetValue,
    SQLINTEGER BufferLength,
    SQLINTEGER * StrLen_or_Ind);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLBindParam (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT ParameterNumber,
    SQLSMALLINT ValueType,
    SQLSMALLINT ParameterType,
    SQLUINTEGER LengthPrecision,
    SQLSMALLINT ParameterScale,
    SQLPOINTER ParameterValue,
    SQLINTEGER * StrLen_or_Ind);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLCancel (
    SQLHSTMT StatementHandle);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLCloseCursor (
    SQLHSTMT StatementHandle);


SQLRETURN SQL_API SQLColAttribute (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT ColumnNumber,
    SQLUSMALLINT FieldIdentifier,
    SQLPOINTER CharacterAttribute,
    SQLSMALLINT BufferLength,
    SQLSMALLINT * StringLength,
    SQLPOINTER NumericAttribute);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLColumns (
    SQLHSTMT StatementHandle,
    SQLCHAR * CatalogName,
    SQLSMALLINT NameLength1,
    SQLCHAR * SchemaName,
    SQLSMALLINT NameLength2,
    SQLCHAR * TableName,
    SQLSMALLINT NameLength3,
    SQLCHAR * ColumnName,
    SQLSMALLINT NameLength4);


SQLRETURN SQL_API SQLConnect (
    SQLHDBC ConnectionHandle,
    SQLCHAR * ServerName,
    SQLSMALLINT NameLength1,
    SQLCHAR * UserName,
    SQLSMALLINT NameLength2,
    SQLCHAR * Authentication,
    SQLSMALLINT NameLength3);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLCopyDesc (
    SQLHDESC SourceDescHandle,
    SQLHDESC TargetDescHandle);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLDataSources (
    SQLHENV EnvironmentHandle,
    SQLUSMALLINT Direction,
    SQLCHAR * ServerName,
    SQLSMALLINT BufferLength1,
    SQLSMALLINT * NameLength1,
    SQLCHAR * Description,
    SQLSMALLINT BufferLength2,
    SQLSMALLINT * NameLength2);


SQLRETURN SQL_API SQLDescribeCol (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT ColumnNumber,
    SQLCHAR * ColumnName,
    SQLSMALLINT BufferLength,
    SQLSMALLINT * NameLength,
    SQLSMALLINT * DataType,
    SQLUINTEGER * ColumnSize,
    SQLSMALLINT * DecimalDigits,
    SQLSMALLINT * Nullable);


SQLRETURN SQL_API SQLDisconnect (
    SQLHDBC ConnectionHandle);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLEndTran (
    SQLSMALLINT HandleType,
    SQLHANDLE Handle,
    SQLSMALLINT CompletionType);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLError (
    SQLHENV EnvironmentHandle,
    SQLHDBC ConnectionHandle,
    SQLHSTMT StatementHandle,
    SQLCHAR * Sqlstate,
    SQLINTEGER * NativeError,
    SQLCHAR * MessageText,
    SQLSMALLINT BufferLength,
    SQLSMALLINT * TextLength);


SQLRETURN SQL_API SQLExecDirect (
    SQLHSTMT StatementHandle,
    SQLCHAR * StatementText,
    SQLINTEGER TextLength);


SQLRETURN SQL_API SQLExecute (
    SQLHSTMT StatementHandle);


SQLRETURN SQL_API SQLFetch (
    SQLHSTMT StatementHandle);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLFetchScroll (
    SQLHSTMT StatementHandle,
    SQLSMALLINT FetchOrientation,
    SQLINTEGER FetchOffset);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLFreeConnect (
    SQLHDBC ConnectionHandle);


SQLRETURN SQL_API SQLFreeEnv (
    SQLHENV EnvironmentHandle);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLFreeHandle (
    SQLSMALLINT HandleType,
    SQLHANDLE Handle);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLFreeStmt (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT Option);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLGetConnectAttr (
    SQLHDBC ConnectionHandle,
    SQLINTEGER Attribute,
    SQLPOINTER Value,
    SQLINTEGER BufferLength,
    SQLINTEGER * StringLength);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLGetConnectOption (
    SQLHDBC ConnectionHandle,
    SQLUSMALLINT Option,
    SQLPOINTER Value);


SQLRETURN SQL_API SQLGetCursorName (
    SQLHSTMT StatementHandle,
    SQLCHAR * CursorName,
    SQLSMALLINT BufferLength,
    SQLSMALLINT * NameLength);


SQLRETURN SQL_API SQLGetData (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT ColumnNumber,
    SQLSMALLINT TargetType,
    SQLPOINTER TargetValue,
    SQLINTEGER BufferLength,
    SQLINTEGER * StrLen_or_Ind);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLGetDescField (
    SQLHDESC DescriptorHandle,
    SQLSMALLINT RecNumber,
    SQLSMALLINT FieldIdentifier,
    SQLPOINTER Value,
    SQLINTEGER BufferLength,
    SQLINTEGER * StringLength);


SQLRETURN SQL_API SQLGetDescRec (
    SQLHDESC DescriptorHandle,
    SQLSMALLINT RecNumber,
    SQLCHAR * Name,
    SQLSMALLINT BufferLength,
    SQLSMALLINT * StringLength,
    SQLSMALLINT * Type,
    SQLSMALLINT * SubType,
    SQLINTEGER * Length,
    SQLSMALLINT * Precision,
    SQLSMALLINT * Scale,
    SQLSMALLINT * Nullable);


SQLRETURN SQL_API SQLGetDiagField (
    SQLSMALLINT HandleType,
    SQLHANDLE Handle,
    SQLSMALLINT RecNumber,
    SQLSMALLINT DiagIdentifier,
    SQLPOINTER DiagInfo,
    SQLSMALLINT BufferLength,
    SQLSMALLINT * StringLength);


SQLRETURN SQL_API SQLGetDiagRec (
    SQLSMALLINT HandleType,
    SQLHANDLE Handle,
    SQLSMALLINT RecNumber,
    SQLCHAR * Sqlstate,
    SQLINTEGER * NativeError,
    SQLCHAR * MessageText,
    SQLSMALLINT BufferLength,
    SQLSMALLINT * TextLength);


SQLRETURN SQL_API SQLGetEnvAttr (
    SQLHENV EnvironmentHandle,
    SQLINTEGER Attribute,
    SQLPOINTER Value,
    SQLINTEGER BufferLength,
    SQLINTEGER * StringLength);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLGetFunctions (
    SQLHDBC ConnectionHandle,
    SQLUSMALLINT FunctionId,
    SQLUSMALLINT * Supported);


SQLRETURN SQL_API SQLGetInfo (
    SQLHDBC ConnectionHandle,
    SQLUSMALLINT InfoType,
    SQLPOINTER InfoValue,
    SQLSMALLINT BufferLength,
    SQLSMALLINT * StringLength);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLGetStmtAttr (
    SQLHSTMT StatementHandle,
    SQLINTEGER Attribute,
    SQLPOINTER Value,
    SQLINTEGER BufferLength,
    SQLINTEGER * StringLength);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLGetStmtOption (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT Option,
    SQLPOINTER Value);


SQLRETURN SQL_API SQLGetTypeInfo (
    SQLHSTMT StatementHandle,
    SQLSMALLINT DataType);


SQLRETURN SQL_API SQLNumResultCols (
    SQLHSTMT StatementHandle,
    SQLSMALLINT * ColumnCount);


SQLRETURN SQL_API SQLParamData (
    SQLHSTMT StatementHandle,
    SQLPOINTER * Value);


SQLRETURN SQL_API SQLPrepare (
    SQLHSTMT StatementHandle,
    SQLCHAR * StatementText,
    SQLINTEGER TextLength);


SQLRETURN SQL_API SQLPutData (
    SQLHSTMT StatementHandle,
    SQLPOINTER Data,
    SQLINTEGER StrLen_or_Ind);


SQLRETURN SQL_API SQLRowCount (
    SQLHSTMT StatementHandle,
    SQLINTEGER * RowCount);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLSetConnectAttr (
    SQLHDBC ConnectionHandle,
    SQLINTEGER Attribute,
    SQLPOINTER Value,
    SQLINTEGER StringLength);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLSetConnectOption (
    SQLHDBC ConnectionHandle,
    SQLUSMALLINT Option,
    SQLUINTEGER Value);


SQLRETURN SQL_API SQLSetCursorName (
    SQLHSTMT StatementHandle,
    SQLCHAR * CursorName,
    SQLSMALLINT NameLength);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLSetDescField (
    SQLHDESC DescriptorHandle,
    SQLSMALLINT RecNumber,
    SQLSMALLINT FieldIdentifier,
    SQLPOINTER Value,
    SQLINTEGER BufferLength);


SQLRETURN SQL_API SQLSetDescRec (
    SQLHDESC DescriptorHandle,
    SQLSMALLINT RecNumber,
    SQLSMALLINT Type,
    SQLSMALLINT SubType,
    SQLINTEGER Length,
    SQLSMALLINT Precision,
    SQLSMALLINT Scale,
    SQLPOINTER Data,
    SQLINTEGER * StringLength,
    SQLINTEGER * Indicator);


SQLRETURN SQL_API SQLSetEnvAttr (
    SQLHENV EnvironmentHandle,
    SQLINTEGER Attribute,
    SQLPOINTER Value,
    SQLINTEGER StringLength);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLSetParam (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT ParameterNumber,
    SQLSMALLINT ValueType,
    SQLSMALLINT ParameterType,
    SQLUINTEGER LengthPrecision,
    SQLSMALLINT ParameterScale,
    SQLPOINTER ParameterValue,
    SQLINTEGER * StrLen_or_Ind);


#if (ODBCVER >= 0x0300)
SQLRETURN SQL_API SQLSetStmtAttr (
    SQLHSTMT StatementHandle,
    SQLINTEGER Attribute,
    SQLPOINTER Value,
    SQLINTEGER StringLength);
#endif	 /* ODBCVER >= 0x0300 */


SQLRETURN SQL_API SQLSetStmtOption (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT Option,
    SQLUINTEGER Value);


SQLRETURN SQL_API SQLSpecialColumns (
    SQLHSTMT StatementHandle,
    SQLUSMALLINT IdentifierType,
    SQLCHAR * CatalogName,
    SQLSMALLINT NameLength1,
    SQLCHAR * SchemaName,
    SQLSMALLINT NameLength2,
    SQLCHAR * TableName,
    SQLSMALLINT NameLength3,
    SQLUSMALLINT Scope,
    SQLUSMALLINT Nullable);


SQLRETURN SQL_API SQLStatistics (
    SQLHSTMT StatementHandle,
    SQLCHAR * CatalogName,
    SQLSMALLINT NameLength1,
    SQLCHAR * SchemaName,
    SQLSMALLINT NameLength2,
    SQLCHAR * TableName,
    SQLSMALLINT NameLength3,
    SQLUSMALLINT Unique,
    SQLUSMALLINT Reserved);


SQLRETURN SQL_API SQLTables (
    SQLHSTMT StatementHandle,
    SQLCHAR * CatalogName,
    SQLSMALLINT NameLength1,
    SQLCHAR * SchemaName,
    SQLSMALLINT NameLength2,
    SQLCHAR * TableName,
    SQLSMALLINT NameLength3,
    SQLCHAR * TableType,
    SQLSMALLINT NameLength4);


SQLRETURN SQL_API SQLTransact (
    SQLHENV EnvironmentHandle,
    SQLHDBC ConnectionHandle,
    SQLUSMALLINT CompletionType);


/*
 *  Depreciated ODBC 1.0 function - Use SQLBindParameter
 */
SQLRETURN SQL_API SQLSetParam (
    SQLHSTMT hstmt,
    SQLUSMALLINT ipar,
    SQLSMALLINT fCType,
    SQLSMALLINT fSqlType,
    SQLUINTEGER cbParamDef,
    SQLSMALLINT ibScale,
    SQLPOINTER rgbValue,
    SQLINTEGER FAR * pcbValue);

#ifdef __cplusplus
}
#endif

#endif	 /* _SQL_H */