sqlext.h

能够连接各种数据库的API

#define SQL_OSCC_NOT_COMPLIANT              0x0000
#define SQL_OSCC_COMPLIANT                  0x0001

/* SQL_ODBC_SQL_CONFORMANCE values */

#define SQL_OSC_MINIMUM                     0x0000
#define SQL_OSC_CORE                        0x0001
#define SQL_OSC_EXTENDED                    0x0002


/* SQL_CONCAT_NULL_BEHAVIOR values */

#define SQL_CB_NULL                         0x0000
#define SQL_CB_NON_NULL                     0x0001

/* SQL_SCROLL_OPTIONS masks */

#define SQL_SO_FORWARD_ONLY                 0x00000001L
#define SQL_SO_KEYSET_DRIVEN                0x00000002L
#define SQL_SO_DYNAMIC                      0x00000004L
#define SQL_SO_MIXED                        0x00000008L
#define SQL_SO_STATIC                       0x00000010L

/* SQL_FETCH_DIRECTION masks */

/* SQL_FETCH_RESUME is no longer supported
#define SQL_FD_FETCH_RESUME                 0x00000040L
*/
#define SQL_FD_FETCH_BOOKMARK               0x00000080L

/* SQL_TXN_ISOLATION_OPTION masks */
/* SQL_TXN_VERSIONING is no longer supported
#define SQL_TXN_VERSIONING                  0x00000010L
*/

/* SQL_CORRELATION_NAME values */

#define SQL_CN_NONE                         0x0000
#define SQL_CN_DIFFERENT                    0x0001
#define SQL_CN_ANY                          0x0002

/* SQL_NON_NULLABLE_COLUMNS values */

#define SQL_NNC_NULL                        0x0000
#define SQL_NNC_NON_NULL                    0x0001

/* SQL_NULL_COLLATION values */

#define SQL_NC_START                        0x0002
#define SQL_NC_END                          0x0004

/* SQL_FILE_USAGE values */

#define SQL_FILE_NOT_SUPPORTED              0x0000
#define SQL_FILE_TABLE                      0x0001
#define SQL_FILE_QUALIFIER                  0x0002
#define SQL_FILE_CATALOG                                        SQL_FILE_QUALIFIER      // ODBC 3.0


/* SQL_GETDATA_EXTENSIONS values */

#define SQL_GD_BLOCK                        0x00000004L
#define SQL_GD_BOUND                        0x00000008L

/* SQL_POSITIONED_STATEMENTS masks */

#define SQL_PS_POSITIONED_DELETE            0x00000001L
#define SQL_PS_POSITIONED_UPDATE            0x00000002L
#define SQL_PS_SELECT_FOR_UPDATE            0x00000004L

/* SQL_GROUP_BY values */

#define SQL_GB_NOT_SUPPORTED                0x0000
#define SQL_GB_GROUP_BY_EQUALS_SELECT       0x0001
#define SQL_GB_GROUP_BY_CONTAINS_SELECT     0x0002
#define SQL_GB_NO_RELATION                  0x0003
#if (ODBCVER >= 0x0300)
#define SQL_GB_COLLATE                                          0x0004

#endif  /* ODBCVER >= 0x0300 */

/* SQL_OWNER_USAGE masks */

#define SQL_OU_DML_STATEMENTS               0x00000001L
#define SQL_OU_PROCEDURE_INVOCATION         0x00000002L
#define SQL_OU_TABLE_DEFINITION             0x00000004L
#define SQL_OU_INDEX_DEFINITION             0x00000008L
#define SQL_OU_PRIVILEGE_DEFINITION         0x00000010L

/* SQL_SCHEMA_USAGE masks */
#if (ODBCVER >= 0x0300)
#define SQL_SU_DML_STATEMENTS                   SQL_OU_DML_STATEMENTS
#define SQL_SU_PROCEDURE_INVOCATION             SQL_OU_PROCEDURE_INVOCATION
#define SQL_SU_TABLE_DEFINITION                 SQL_OU_TABLE_DEFINITION
#define SQL_SU_INDEX_DEFINITION                 SQL_OU_INDEX_DEFINITION
#define SQL_SU_PRIVILEGE_DEFINITION             SQL_OU_PRIVILEGE_DEFINITION
#endif  /* ODBCVER >= 0x0300 */

/* SQL_QUALIFIER_USAGE masks */

#define SQL_QU_DML_STATEMENTS               0x00000001L
#define SQL_QU_PROCEDURE_INVOCATION         0x00000002L
#define SQL_QU_TABLE_DEFINITION             0x00000004L
#define SQL_QU_INDEX_DEFINITION             0x00000008L
#define SQL_QU_PRIVILEGE_DEFINITION         0x00000010L

#if (ODBCVER >= 0x0300)
/* SQL_CATALOG_USAGE masks */
#define SQL_CU_DML_STATEMENTS                   SQL_QU_DML_STATEMENTS
#define SQL_CU_PROCEDURE_INVOCATION             SQL_QU_PROCEDURE_INVOCATION
#define SQL_CU_TABLE_DEFINITION                 SQL_QU_TABLE_DEFINITION
#define SQL_CU_INDEX_DEFINITION                 SQL_QU_INDEX_DEFINITION
#define SQL_CU_PRIVILEGE_DEFINITION             SQL_QU_PRIVILEGE_DEFINITION
#endif  /* ODBCVER >= 0x0300 */

/* SQL_SUBQUERIES masks */

#define SQL_SQ_COMPARISON                   0x00000001L
#define SQL_SQ_EXISTS                       0x00000002L
#define SQL_SQ_IN                           0x00000004L
#define SQL_SQ_QUANTIFIED                   0x00000008L
#define SQL_SQ_CORRELATED_SUBQUERIES        0x00000010L

/* SQL_UNION masks */

#define SQL_U_UNION                         0x00000001L
#define SQL_U_UNION_ALL                     0x00000002L

/* SQL_BOOKMARK_PERSISTENCE values */

#define SQL_BP_CLOSE                        0x00000001L
#define SQL_BP_DELETE                       0x00000002L
#define SQL_BP_DROP                         0x00000004L
#define SQL_BP_TRANSACTION                  0x00000008L
#define SQL_BP_UPDATE                       0x00000010L
#define SQL_BP_OTHER_HSTMT                  0x00000020L
#define SQL_BP_SCROLL                       0x00000040L

/* SQL_STATIC_SENSITIVITY values */

#define SQL_SS_ADDITIONS                    0x00000001L
#define SQL_SS_DELETIONS                    0x00000002L
#define SQL_SS_UPDATES                      0x00000004L

/* SQL_VIEW values */
#define SQL_CV_CREATE_VIEW                                      0x00000001L
#define SQL_CV_CHECK_OPTION                                     0x00000002L
#define SQL_CV_CASCADED                                         0x00000004L
#define SQL_CV_LOCAL                                            0x00000008L

/* SQL_LOCK_TYPES masks */

#define SQL_LCK_NO_CHANGE                   0x00000001L
#define SQL_LCK_EXCLUSIVE                   0x00000002L
#define SQL_LCK_UNLOCK                      0x00000004L

/* SQL_POS_OPERATIONS masks */

#define SQL_POS_POSITION                    0x00000001L
#define SQL_POS_REFRESH                     0x00000002L
#define SQL_POS_UPDATE                      0x00000004L
#define SQL_POS_DELETE                      0x00000008L
#define SQL_POS_ADD                         0x00000010L

/* SQL_QUALIFIER_LOCATION values */

#define SQL_QL_START                        0x0001
#define SQL_QL_END                          0x0002

/* Here start return values for ODBC 3.0 SQLGetInfo */

#if (ODBCVER >= 0x0300)
/* SQL_AGGREGATE_FUNCTIONS bitmasks */
#define SQL_AF_AVG                                              0x00000001L
#define SQL_AF_COUNT                                    0x00000002L
#define SQL_AF_MAX                                              0x00000004L
#define SQL_AF_MIN                                              0x00000008L
#define SQL_AF_SUM                                              0x00000010L
#define SQL_AF_DISTINCT                                 0x00000020L
#define SQL_AF_ALL                                              0x00000040L

/* SQL_SQL_CONFORMANCE bit masks */
#define SQL_SC_SQL92_ENTRY                              0x00000001L
#define SQL_SC_FIPS127_2_TRANSITIONAL   0x00000002L
#define SQL_SC_SQL92_INTERMEDIATE               0x00000004L
#define SQL_SC_SQL92_FULL                               0x00000008L

/* SQL_DATETIME_LITERALS masks */
#define SQL_DL_SQL92_DATE                                               0x00000001L
#define SQL_DL_SQL92_TIME                                               0x00000002L
#define SQL_DL_SQL92_TIMESTAMP                                  0x00000004L
#define SQL_DL_SQL92_INTERVAL_YEAR                              0x00000008L
#define SQL_DL_SQL92_INTERVAL_MONTH                             0x00000010L
#define SQL_DL_SQL92_INTERVAL_DAY                               0x00000020L
#define SQL_DL_SQL92_INTERVAL_HOUR                              0x00000040L
#define SQL_DL_SQL92_INTERVAL_MINUTE                    0x00000080L
#define SQL_DL_SQL92_INTERVAL_SECOND                    0x00000100L
#define SQL_DL_SQL92_INTERVAL_YEAR_TO_MONTH             0x00000200L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_HOUR               0x00000400L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_MINUTE             0x00000800L
#define SQL_DL_SQL92_INTERVAL_DAY_TO_SECOND             0x00001000L
#define SQL_DL_SQL92_INTERVAL_HOUR_TO_MINUTE    0x00002000L
#define SQL_DL_SQL92_INTERVAL_HOUR_TO_SECOND    0x00004000L
#define SQL_DL_SQL92_INTERVAL_MINUTE_TO_SECOND  0x00008000L

/* SQL_CATALOG_LOCATION values */
#define SQL_CL_START                                            SQL_QL_START
#define SQL_CL_END                                                      SQL_QL_END

/* values for SQL_BATCH_ROW_COUNT */
#define SQL_BRC_PROCEDURES                      0x0000001
#define SQL_BRC_EXPLICIT                        0x0000002
#define SQL_BRC_ROLLED_UP                       0x0000004

/* bitmasks for SQL_BATCH_SUPPORT */
#define SQL_BS_SELECT_EXPLICIT                          0x00000001L
#define SQL_BS_ROW_COUNT_EXPLICIT                       0x00000002L
#define SQL_BS_SELECT_PROC                                      0x00000004L
#define SQL_BS_ROW_COUNT_PROC                           0x00000008L

/* Values for SQL_PARAM_ARRAY_ROW_COUNTS getinfo */
#define SQL_PARC_BATCH          1
#define SQL_PARC_NO_BATCH       2

/* values for SQL_PARAM_ARRAY_SELECTS */
#define SQL_PAS_BATCH                           1
#define SQL_PAS_NO_BATCH                        2
#define SQL_PAS_NO_SELECT                       3

/* Bitmasks for SQL_INDEX_KEYWORDS */
#define SQL_IK_NONE                                                     0x00000000L
#define SQL_IK_ASC                                                      0x00000001L
#define SQL_IK_DESC                                                     0x00000002L
#define SQL_IK_ALL                                                      (SQL_IK_ASC | SQL_IK_DESC)

/* Bitmasks for SQL_INFO_SCHEMA_VIEWS */

#define SQL_ISV_ASSERTIONS                                      0x00000001L
#define SQL_ISV_CHARACTER_SETS                          0x00000002L
#define SQL_ISV_CHECK_CONSTRAINTS                       0x00000004L
#define SQL_ISV_COLLATIONS                                      0x00000008L
#define SQL_ISV_COLUMN_DOMAIN_USAGE                     0x00000010L
#define SQL_ISV_COLUMN_PRIVILEGES                       0x00000020L
#define SQL_ISV_COLUMNS                                         0x00000040L
#define SQL_ISV_CONSTRAINT_COLUMN_USAGE         0x00000080L
#define SQL_ISV_CONSTRAINT_TABLE_USAGE          0x00000100L
#define SQL_ISV_DOMAIN_CONSTRAINTS                      0x00000200L
#define SQL_ISV_DOMAINS                                         0x00000400L
#define SQL_ISV_KEY_COLUMN_USAGE                        0x00000800L
#define SQL_ISV_REFERENTIAL_CONSTRAINTS         0x00001000L
#define SQL_ISV_SCHEMATA                                        0x00002000L
#define SQL_ISV_SQL_LANGUAGES                           0x00004000L
#define SQL_ISV_TABLE_CONSTRAINTS                       0x00008000L
#define SQL_ISV_TABLE_PRIVILEGES                        0x00010000L
#define SQL_ISV_TABLES                                          0x00020000L
#define SQL_ISV_TRANSLATIONS                            0x00040000L
#define SQL_ISV_USAGE_PRIVILEGES                        0x00080000L
#define SQL_ISV_VIEW_COLUMN_USAGE                       0x00100000L
#define SQL_ISV_VIEW_TABLE_USAGE                        0x00200000L
#define SQL_ISV_VIEWS                                           0x00400000L

/* Bitmasks for SQL_ASYNC_MODE */

#define SQL_AM_NONE                     0
#define SQL_AM_CONNECTION       1
#define SQL_AM_STATEMENT        2

/* Bitmasks for SQL_ALTER_DOMAIN */
#define SQL_AD_CONSTRAINT_NAME_DEFINITION                       0x00000001L
#define SQL_AD_ADD_DOMAIN_CONSTRAINT                            0x00000002L
#define SQL_AD_DROP_DOMAIN_CONSTRAINT                           0x00000004L
#define SQL_AD_ADD_DOMAIN_DEFAULT                               0x00000008L
#define SQL_AD_DROP_DOMAIN_DEFAULT                              0x00000010L
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_DEFERRED        0x00000020L
#define SQL_AD_ADD_CONSTRAINT_INITIALLY_IMMEDIATE       0x00000040L
#define SQL_AD_ADD_CONSTRAINT_DEFERRABLE                        0x00000080L
#define SQL_AD_ADD_CONSTRAINT_NON_DEFERRABLE            0x00000100L


/* SQL_CREATE_SCHEMA bitmasks */
#define SQL_CS_CREATE_SCHEMA                            0x00000001L
#define SQL_CS_AUTHORIZATION