sqlext.h

能够连接各种数据库的API

#define SQL_STANDARD_CLI_CONFORMANCE                    166
#define SQL_STATIC_CURSOR_ATTRIBUTES1                   167
#define SQL_STATIC_CURSOR_ATTRIBUTES2                   168

#define SQL_AGGREGATE_FUNCTIONS                                 169
#define SQL_DDL_INDEX                                                   170
#define SQL_DM_VER                                                              171
#define SQL_INSERT_STATEMENT                                    172
#define SQL_UNION_STATEMENT                                             SQL_UNION
#endif  /* ODBCVER >= 0x0300 */

#define SQL_DTC_TRANSITION_COST                                 1750

/* SQL_ALTER_TABLE bitmasks */
#if (ODBCVER >= 0x0300)
/* the following 5 bitmasks are defined in sql.h
*#define SQL_AT_ADD_COLUMN                      0x00000001L
*#define SQL_AT_DROP_COLUMN                     0x00000002L
*#define SQL_AT_ADD_CONSTRAINT                  0x00000008L
*/
#define SQL_AT_ADD_COLUMN_SINGLE                                0x00000020L
#define SQL_AT_ADD_COLUMN_DEFAULT                               0x00000040L
#define SQL_AT_ADD_COLUMN_COLLATION                             0x00000080L
#define SQL_AT_SET_COLUMN_DEFAULT                               0x00000100L
#define SQL_AT_DROP_COLUMN_DEFAULT                              0x00000200L
#define SQL_AT_DROP_COLUMN_CASCADE                              0x00000400L
#define SQL_AT_DROP_COLUMN_RESTRICT                             0x00000800L
#define SQL_AT_ADD_TABLE_CONSTRAINT                             0x00001000L
#define SQL_AT_DROP_TABLE_CONSTRAINT_CASCADE    0x00002000L
#define SQL_AT_DROP_TABLE_CONSTRAINT_RESTRICT   0x00004000L
#define SQL_AT_CONSTRAINT_NAME_DEFINITION               0x00008000L
#define SQL_AT_CONSTRAINT_INITIALLY_DEFERRED    0x00010000L
#define SQL_AT_CONSTRAINT_INITIALLY_IMMEDIATE   0x00020000L
#define SQL_AT_CONSTRAINT_DEFERRABLE                    0x00040000L
#define SQL_AT_CONSTRAINT_NON_DEFERRABLE                0x00080000L
#endif  /* ODBCVER >= 0x0300 */

/* SQL_CONVERT_*  return value bitmasks */

#define SQL_CVT_CHAR                        0x00000001L
#define SQL_CVT_NUMERIC                     0x00000002L
#define SQL_CVT_DECIMAL                     0x00000004L
#define SQL_CVT_INTEGER                     0x00000008L
#define SQL_CVT_SMALLINT                    0x00000010L
#define SQL_CVT_FLOAT                       0x00000020L
#define SQL_CVT_REAL                        0x00000040L
#define SQL_CVT_DOUBLE                      0x00000080L
#define SQL_CVT_VARCHAR                     0x00000100L
#define SQL_CVT_LONGVARCHAR                 0x00000200L
#define SQL_CVT_BINARY                      0x00000400L
#define SQL_CVT_VARBINARY                   0x00000800L
#define SQL_CVT_BIT                         0x00001000L
#define SQL_CVT_TINYINT                     0x00002000L
#define SQL_CVT_BIGINT                      0x00004000L
#define SQL_CVT_DATE                        0x00008000L
#define SQL_CVT_TIME                        0x00010000L
#define SQL_CVT_TIMESTAMP                   0x00020000L
#define SQL_CVT_LONGVARBINARY               0x00040000L
#if (ODBCVER >= 0x0300)
#define SQL_CVT_INTERVAL_YEAR_MONTH             0x00080000L
#define SQL_CVT_INTERVAL_DAY_TIME               0x00100000L
#define SQL_CVT_WCHAR                                           0x00200000L
#define SQL_CVT_WLONGVARCHAR                            0x00400000L
#define SQL_CVT_WVARCHAR                                        0x00800000L

#endif  /* ODBCVER >= 0x0300 */


/* SQL_CONVERT_FUNCTIONS functions */
#define SQL_FN_CVT_CONVERT                  0x00000001L
#if (ODBCVER >= 0x0300)
#define SQL_FN_CVT_CAST                                         0x00000002L
#endif  /* ODBCVER >= 0x0300 */


/* SQL_STRING_FUNCTIONS functions */

#define SQL_FN_STR_CONCAT                   0x00000001L
#define SQL_FN_STR_INSERT                   0x00000002L
#define SQL_FN_STR_LEFT                     0x00000004L
#define SQL_FN_STR_LTRIM                    0x00000008L
#define SQL_FN_STR_LENGTH                   0x00000010L
#define SQL_FN_STR_LOCATE                   0x00000020L
#define SQL_FN_STR_LCASE                    0x00000040L
#define SQL_FN_STR_REPEAT                   0x00000080L
#define SQL_FN_STR_REPLACE                  0x00000100L
#define SQL_FN_STR_RIGHT                    0x00000200L
#define SQL_FN_STR_RTRIM                    0x00000400L
#define SQL_FN_STR_SUBSTRING                0x00000800L
#define SQL_FN_STR_UCASE                    0x00001000L
#define SQL_FN_STR_ASCII                    0x00002000L
#define SQL_FN_STR_CHAR                     0x00004000L
#define SQL_FN_STR_DIFFERENCE               0x00008000L
#define SQL_FN_STR_LOCATE_2                 0x00010000L
#define SQL_FN_STR_SOUNDEX                  0x00020000L
#define SQL_FN_STR_SPACE                    0x00040000L
#if (ODBCVER >= 0x0300)
#define SQL_FN_STR_BIT_LENGTH                           0x00080000L
#define SQL_FN_STR_CHAR_LENGTH                          0x00100000L
#define SQL_FN_STR_CHARACTER_LENGTH                     0x00200000L
#define SQL_FN_STR_OCTET_LENGTH                         0x00400000L
#define SQL_FN_STR_POSITION                                     0x00800000L
#endif  /* ODBCVER >= 0x0300 */

/* SQL_SQL92_STRING_FUNCTIONS */
#if (ODBCVER >= 0x0300)
#define SQL_SSF_CONVERT                                         0x00000001L
#define SQL_SSF_LOWER                                           0x00000002L
#define SQL_SSF_UPPER                                           0x00000004L
#define SQL_SSF_SUBSTRING                                       0x00000008L
#define SQL_SSF_TRANSLATE                                       0x00000010L
#define SQL_SSF_TRIM_BOTH                                       0x00000020L
#define SQL_SSF_TRIM_LEADING                            0x00000040L
#define SQL_SSF_TRIM_TRAILING                           0x00000080L
#endif /* ODBCVER >= 0x0300 */

/* SQL_NUMERIC_FUNCTIONS functions */

#define SQL_FN_NUM_ABS                      0x00000001L
#define SQL_FN_NUM_ACOS                     0x00000002L
#define SQL_FN_NUM_ASIN                     0x00000004L
#define SQL_FN_NUM_ATAN                     0x00000008L
#define SQL_FN_NUM_ATAN2                    0x00000010L
#define SQL_FN_NUM_CEILING                  0x00000020L
#define SQL_FN_NUM_COS                      0x00000040L
#define SQL_FN_NUM_COT                      0x00000080L
#define SQL_FN_NUM_EXP                      0x00000100L
#define SQL_FN_NUM_FLOOR                    0x00000200L
#define SQL_FN_NUM_LOG                      0x00000400L
#define SQL_FN_NUM_MOD                      0x00000800L
#define SQL_FN_NUM_SIGN                     0x00001000L
#define SQL_FN_NUM_SIN                      0x00002000L
#define SQL_FN_NUM_SQRT                     0x00004000L
#define SQL_FN_NUM_TAN                      0x00008000L
#define SQL_FN_NUM_PI                       0x00010000L
#define SQL_FN_NUM_RAND                     0x00020000L
#define SQL_FN_NUM_DEGREES                  0x00040000L
#define SQL_FN_NUM_LOG10                    0x00080000L
#define SQL_FN_NUM_POWER                    0x00100000L
#define SQL_FN_NUM_RADIANS                  0x00200000L
#define SQL_FN_NUM_ROUND                    0x00400000L
#define SQL_FN_NUM_TRUNCATE                 0x00800000L

/* SQL_SQL92_NUMERIC_VALUE_FUNCTIONS */
#if (ODBCVER >= 0x0300)
#define SQL_SNVF_BIT_LENGTH                                     0x00000001L
#define SQL_SNVF_CHAR_LENGTH                            0x00000002L
#define SQL_SNVF_CHARACTER_LENGTH                       0x00000004L
#define SQL_SNVF_EXTRACT                                        0x00000008L
#define SQL_SNVF_OCTET_LENGTH                           0x00000010L
#define SQL_SNVF_POSITION                                       0x00000020L
#endif  /* ODBCVER >= 0x0300 */

/* SQL_TIMEDATE_FUNCTIONS functions */

#define SQL_FN_TD_NOW                       0x00000001L
#define SQL_FN_TD_CURDATE                   0x00000002L
#define SQL_FN_TD_DAYOFMONTH                0x00000004L
#define SQL_FN_TD_DAYOFWEEK                 0x00000008L
#define SQL_FN_TD_DAYOFYEAR                 0x00000010L
#define SQL_FN_TD_MONTH                     0x00000020L
#define SQL_FN_TD_QUARTER                   0x00000040L
#define SQL_FN_TD_WEEK                      0x00000080L
#define SQL_FN_TD_YEAR                      0x00000100L
#define SQL_FN_TD_CURTIME                   0x00000200L
#define SQL_FN_TD_HOUR                      0x00000400L
#define SQL_FN_TD_MINUTE                    0x00000800L
#define SQL_FN_TD_SECOND                    0x00001000L
#define SQL_FN_TD_TIMESTAMPADD              0x00002000L
#define SQL_FN_TD_TIMESTAMPDIFF             0x00004000L
#define SQL_FN_TD_DAYNAME                   0x00008000L
#define SQL_FN_TD_MONTHNAME                 0x00010000L
#if (ODBCVER >= 0x0300)
#define SQL_FN_TD_CURRENT_DATE                          0x00020000L
#define SQL_FN_TD_CURRENT_TIME                          0x00040000L
#define SQL_FN_TD_CURRENT_TIMESTAMP                     0x00080000L
#define SQL_FN_TD_EXTRACT                                       0x00100000L
#endif  /* ODBCVER >= 0x0300 */

/* SQL_SQL92_DATETIME_FUNCTIONS */
#if (ODBCVER >= 0x0300)
#define SQL_SDF_CURRENT_DATE                            0x00000001L
#define SQL_SDF_CURRENT_TIME                            0x00000002L
#define SQL_SDF_CURRENT_TIMESTAMP                       0x00000004L
#endif /* ODBCVER >= 0x0300 */

/* SQL_SYSTEM_FUNCTIONS functions */

#define SQL_FN_SYS_USERNAME                 0x00000001L
#define SQL_FN_SYS_DBNAME                   0x00000002L
#define SQL_FN_SYS_IFNULL                   0x00000004L

/* SQL_TIMEDATE_ADD_INTERVALS and SQL_TIMEDATE_DIFF_INTERVALS functions */

#define SQL_FN_TSI_FRAC_SECOND              0x00000001L
#define SQL_FN_TSI_SECOND                   0x00000002L
#define SQL_FN_TSI_MINUTE                   0x00000004L
#define SQL_FN_TSI_HOUR                     0x00000008L
#define SQL_FN_TSI_DAY                      0x00000010L
#define SQL_FN_TSI_WEEK                     0x00000020L
#define SQL_FN_TSI_MONTH                    0x00000040L
#define SQL_FN_TSI_QUARTER                  0x00000080L
#define SQL_FN_TSI_YEAR                     0x00000100L

/* bitmasks for SQL_DYNAMIC_CURSOR_ATTRIBUTES1,
 * SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES1,
 * SQL_KEYSET_CURSOR_ATTRIBUTES1, and SQL_STATIC_CURSOR_ATTRIBUTES1
 */
#if (ODBCVER >= 0x0300)
/* supported SQLFetchScroll FetchOrientation's */
#define SQL_CA1_NEXT                                            0x00000001L
#define SQL_CA1_ABSOLUTE                                        0x00000002L
#define SQL_CA1_RELATIVE                                        0x00000004L
#define SQL_CA1_BOOKMARK                                        0x00000008L

/* supported SQLSetPos LockType's */
#define SQL_CA1_LOCK_NO_CHANGE                          0x00000040L
#define SQL_CA1_LOCK_EXCLUSIVE                          0x00000080L
#define SQL_CA1_LOCK_UNLOCK                                     0x00000100L

/* supported SQLSetPos Operations */
#define SQL_CA1_POS_POSITION                            0x00000200L
#define SQL_CA1_POS_UPDATE                                      0x00000400L
#define SQL_CA1_POS_DELETE                                      0x00000800L
#define SQL_CA1_POS_REFRESH                                     0x00001000L

/* positioned updates and deletes */
#define SQL_CA1_POSITIONED_UPDATE                       0x00002000L
#define SQL_CA1_POSITIONED_DELETE                       0x00004000L
#define SQL_CA1_SELECT_FOR_UPDATE                       0x00008000L

/* supported SQLBulkOperations operations */
#define SQL_CA1_BULK_ADD                                        0x00010000L
#define SQL_CA1_BULK_UPDATE_BY_BOOKMARK         0x00020000L
#define SQL_CA1_BULK_DELETE_BY_BOOKMARK         0x00040000L
#define SQL_CA1_BULK_FETCH_BY_BOOKMARK          0x00080000L
#endif  /* ODBCVER >= 0x0300 */

/* bitmasks for SQL_DYNAMIC_CURSOR_ATTRIBUTES2,
 * SQL_FORWARD_ONLY_CURSOR_ATTRIBUTES2,
 * SQL_KEYSET_CURSOR_ATTRIBUTES2, and SQL_STATIC_CURSOR_ATTRIBUTES2
 */
#if (ODBCVER >= 0x0300)
/* supported values for SQL_ATTR_SCROLL_CONCURRENCY */
#define SQL_CA2_READ_ONLY_CONCURRENCY           0x00000001L
#define SQL_CA2_LOCK_CONCURRENCY                        0x00000002L
#define SQL_CA2_OPT_ROWVER_CONCURRENCY          0x00000004L
#define SQL_CA2_OPT_VALUES_CONCURRENCY          0x00000008L

/* sensitivity of the cursor to its own inserts, deletes, and updates */
#define SQL_CA2_SENSITIVITY_ADDITIONS           0x00000010L
#define SQL_CA2_SENSITIVITY_DELETIONS           0x00000020L
#define SQL_CA2_SENSITIVITY_UPDATES                     0x00000040L

/* semantics of SQL_ATTR_MAX_ROWS */
#define SQL_CA2_MAX_ROWS_SELECT                         0x00000080L
#define SQL_CA2_MAX_ROWS_INSERT                         0x00000100L
#define SQL_CA2_MAX_ROWS_DELETE                         0x00000200L
#define SQL_CA2_MAX_ROWS_UPDATE                         0x00000400L
#define SQL_CA2_MAX_ROWS_CATALOG                        0x00000800L
#define SQL_CA2_MAX_ROWS_AFFECTS_ALL            (SQL_CA2_MAX_ROWS_SELECT | \
                                        SQL_CA2_MAX_ROWS_INSERT | SQL_CA2_MAX_ROWS_DELETE | \
                                        SQL_CA2_MAX_ROWS_UPDATE | SQL_CA2_MAX_ROWS_CATALOG)

/* semantics of SQL_DIAG_CURSOR_ROW_COUNT */
#define SQL_CA2_CRC_EXACT                                       0x00001000L
#define SQL_CA2_CRC_APPROXIMATE                         0x00002000L

/* the kinds of positioned statements that can be simulated */
#define SQL_CA2_SIMULATE_NON_UNIQUE                     0x00004000L
#define SQL_CA2_SIMULATE_TRY_UNIQUE                     0x00008000L
#define SQL_CA2_SIMULATE_UNIQUE                         0x00010000L
#endif  /* ODBCVER >= 0x0300 */

/* SQL_ODBC_API_CONFORMANCE values */

#define SQL_OAC_NONE                        0x0000
#define SQL_OAC_LEVEL1                      0x0001
#define SQL_OAC_LEVEL2                      0x0002

/* SQL_ODBC_SAG_CLI_CONFORMANCE values */