]>
git.saurik.com Git - wxWidgets.git/blob - src/iodbc/odbc_types.h
1 #define SQL_MAX_USER_NAME_LEN 107
2 #define SQL_SPEC_STRING "02.50" /* String constant for version */
3 #define SQL_ACTIVE_CONNECTIONS 0
4 #define SQL_ACTIVE_STATEMENTS 1
5 #define SQL_DATA_SOURCE_NAME 2
6 #define SQL_DATABASE_NAME 16 /* Use SQLGetConnectOption/SQL_CURRENT_QUALIFIER */
7 #define SQL_DBMS_VER 18
8 #define SQL_FETCH_DIRECTION 8
9 #define SQL_ROW_UPDATES 11
10 #define SQL_ODBC_SAG_CLI_CONFORMANCE 12
11 #define SQL_DRIVER_VER 7
12 #define SQL_SERVER_NAME 13
13 #define SQL_SEARCH_PATTERN_ESCAPE 14
14 #define SQL_ODBC_API_CONFORMANCE 9
15 #define SQL_ODBC_SQL_CONFORMANCE 15
16 #define SQL_OAC_LEVEL1 0x0001
17 #define SQL_DBMS_NAME 17
18 #define SQL_ACCESSIBLE_PROCEDURES 20
19 #define SQL_OUTER_JOINS 38
20 #define SQL_NEED_LONG_DATA_LEN 111
21 #define SQL_EXPRESSIONS_IN_ORDERBY 27
22 #define SQL_PROCEDURES 21
23 #define SQL_COLUMN_ALIAS 87
24 #define SQL_CONCAT_NULL_BEHAVIOR 22
25 #define SQL_DATA_SOURCE_READ_ONLY 25
26 #define SQL_ACCESSIBLE_TABLES 19
27 #define SQL_IDENTIFIER_QUOTE_CHAR 29
28 #define SQL_MAX_COLUMN_NAME_LEN 30
29 #define SQL_MAX_CURSOR_NAME_LEN 31
30 #define SQL_MAX_OWNER_NAME_LEN 32
31 #define SQL_MAX_PROCEDURE_NAME_LEN 33
32 #define SQL_MAX_QUALIFIER_NAME_LEN 34
33 #define SQL_MAX_TABLE_NAME_LEN 35
34 #define SQL_MULT_RESULT_SETS 36
35 #define SQL_MULTIPLE_ACTIVE_TXN 37
36 #define SQL_MAX_ROW_SIZE_INCLUDES_LONG 103
37 #define SQL_OWNER_TERM 39
38 #define SQL_PROCEDURE_TERM 40
39 #define SQL_QUALIFIER_NAME_SEPARATOR 41
40 #define SQL_QUALIFIER_TERM 42
41 #define SQL_SCROLL_CONCURRENCY 43
42 #define SQL_SCROLL_OPTIONS 44
43 #define SQL_TABLE_TERM 45
44 #define SQL_TXN_CAPABLE 46
45 #define SQL_USER_NAME 47
46 #define SQL_CONVERT_FUNCTIONS 48
47 #define SQL_SYSTEM_FUNCTIONS 51
48 #define SQL_NUMERIC_FUNCTIONS 49
49 #define SQL_STRING_FUNCTIONS 50
50 #define SQL_TIMEDATE_FUNCTIONS 52
52 #define SQL_CONVERT_BIGINT 53
53 #define SQL_CONVERT_BIT 55
54 #define SQL_CONVERT_CHAR 56
55 #define SQL_CONVERT_DATE 57
56 #define SQL_CONVERT_DECIMAL 58
57 #define SQL_CONVERT_DOUBLE 59
58 #define SQL_CONVERT_FLOAT 60
59 #define SQL_CONVERT_INTEGER 61
60 #define SQL_CONVERT_LONGVARCHAR 62
61 #define SQL_CONVERT_NUMERIC 63
62 #define SQL_CONVERT_REAL 64
63 #define SQL_CONVERT_SMALLINT 65
64 #define SQL_CONVERT_TIME 66
65 #define SQL_CONVERT_TIMESTAMP 67
66 #define SQL_CONVERT_TIMESTAMP 67
67 #define SQL_CONVERT_TINYINT 68
68 #define SQL_CONVERT_VARCHAR 70
69 #define SQL_CVT_CHAR 0x00000001L
70 #define SQL_CVT_NUMERIC 0x00000002L
71 #define SQL_CVT_DECIMAL 0x00000004L
72 #define SQL_CVT_INTEGER 0x00000008L
73 #define SQL_CVT_SMALLINT 0x00000010L
74 #define SQL_CVT_FLOAT 0x00000020L
75 #define SQL_CVT_REAL 0x00000040L
76 #define SQL_CVT_DOUBLE 0x00000080L
77 #define SQL_CVT_VARCHAR 0x00000100L
78 #define SQL_CVT_LONGVARCHAR 0x00000200L
79 #define SQL_CVT_BIT 0x00001000L
80 #define SQL_CVT_TINYINT 0x00002000L
81 #define SQL_CVT_BIGINT 0x00004000L
82 #define SQL_CVT_DATE 0x00008000L
83 #define SQL_CVT_TIME 0x00010000L
84 #define SQL_CVT_TIMESTAMP 0x00020000L
85 #define SQL_CVT_TIMESTAMP 0x00020000L
86 #define SQL_CONVERT_BINARY 54
87 #define SQL_CONVERT_VARBINARY 69
88 #define SQL_CONVERT_LONGVARBINARY 71
89 #define SQL_CORRELATION_NAME 74
90 #define SQL_CN_DIFFERENT 0x0001
91 #define SQL_NNC_NON_NULL 0x0001
92 #define SQL_NULL_COLLATION 85
93 #define SQL_NC_START 0x0002
94 #define SQL_MAX_COLUMNS_IN_GROUP_BY 97
95 #define SQL_MAX_COLUMNS_IN_ORDER_BY 99
96 #define SQL_MAX_COLUMNS_IN_SELECT 100
97 #define SQL_MAX_COLUMNS_IN_TABLE 101
98 #define SQL_MAX_TABLES_IN_SELECT 106
99 #define SQL_MAX_ROW_SIZE_INCLUDES_LONG 103
100 #define SQL_MAX_ROW_SIZE 104
101 #define SQL_MAX_BINARY_LITERAL_LEN 112
102 #define SQL_MAX_CHAR_LITERAL_LEN 108
103 #define SQL_MAX_COLUMNS_IN_INDEX 98
104 #define SQL_MAX_INDEX_SIZE 102
105 #define SQL_MAX_STATEMENT_LEN 105
106 #define SQL_MAX_OPTION_STRING_LENGTH 256
108 #define SQL_QL_START 0x0001L
109 #define SQL_SEARCHABLE 3
110 #define SQL_IDENTIFIER_CASE 28
111 #define SQL_COLUMN_NAME 1
112 #define SQL_COLUMN_TYPE 2
113 #define SQL_COLUMN_TYPE_NAME 14
114 #define SQL_COLUMN_PRECISION 4
115 #define SQL_COLUMN_DISPLAY_SIZE 6
116 #define SQL_COLUMN_LENGTH 3
117 #define SQL_COLUMN_SCALE 5
118 #define SQL_COLUMN_NULLABLE 7
119 #define SQL_COLUMN_SEARCHABLE 13
120 #define SQL_COLUMN_UNSIGNED 8
121 #define SQL_COLUMN_MONEY 9
122 #define SQL_COLUMN_AUTO_INCREMENT 11
123 #define SQL_COLUMN_CASE_SENSITIVE 12
124 #define SQL_COLUMN_UPDATABLE 10
125 #define SQL_COLUMN_OWNER_NAME 16
126 #define SQL_COLUMN_QUALIFIER_NAME 17
127 #define SQL_OSCC_COMPLIANT 0x0001
128 #define SQL_ODBC_SQL_OPT_IEF 73
129 #define SQL_LIKE_ESCAPE_CLAUSE 113
130 #define SQL_ORDER_BY_COLUMNS_IN_SELECT 90
131 #define SQL_POS_OPERATIONS 79
132 #define SQL_POSITIONED_STATEMENTS 80
133 #define SQL_LOCK_TYPES 78
134 #define SQL_BOOKMARK_PERSISTENCE 82
135 #define SQL_ALTER_TABLE 86
136 #define SQL_OWNER_USAGE 91
137 #define SQL_QUALIFIER_USAGE 92
138 #define SQL_QUOTED_IDENTIFIER_CASE 93
139 #define SQL_SUBQUERIES 95
141 #define SQL_TIMEDATE_DIFF_INTERVALS 110
142 #define SQL_GETDATA_EXTENSIONS 81
143 #define SQL_GD_ANY_COLUMN 0x00000001L
144 #define SQL_GD_ANY_ORDER 0x00000002L
145 #define SQL_GD_BOUND 0x00000008L
146 #define SQL_STATIC_SENSITIVITY 83
147 #define SQL_SS_DELETIONS 0x00000002L
148 #define SQL_SS_UPDATES 0x00000004L
149 #define SQL_FILE_USAGE 84
150 #define SQL_FILE_NOT_SUPPORTED 0x0000
151 #define SQL_GROUP_BY 88
152 #define SQL_GB_GROUP_BY_EQUALS_SELECT 0x0001
153 #define SQL_KEYWORDS 89
154 #define SQL_SPECIAL_CHARACTERS 94
155 #define SQL_TIMEDATE_ADD_INTERVALS 109
156 #define SQL_IC_MIXED 0x0004
157 #define SQL_FN_SYS_DBNAME 0x00000002L
158 #define SQL_FN_SYS_IFNULL 0x00000004L
159 #define SQL_FN_SYS_USERNAME 0x00000001L
160 #define SQL_FN_STR_INSERT 0x00000002L
161 #define SQL_FN_STR_LTRIM 0x00000008L
162 #define SQL_FN_STR_RTRIM 0x00000400L
164 #define SQL_BLOB_LOCATOR 22
166 #define SQL_CLOB_LOCATOR 24
167 #define SQL_DBCLOB 25
168 #define SQL_DBCLOB_LOCATOR 26
169 #define SQL_GRAPHIC 27
170 #define SQL_LONGVARGRAPHIC 30
171 #define SQL_VARGRAPHIC 32
172 #define SQL_SQLSTATE_SIZE 8
173 #define SQL_COLUMN_DISTINCT_TYPE 1250
174 #define SQL_COLUMN_TABLE_NAME 15
175 #define SQL_LEN_DATA_AT_EXEC_OFFSET (-100)
176 #define SQL_CB_NULL 0x0000
177 #define SQL_TC_NONE 0x0000
178 #define SQL_NOSCAN_OFF 0UL
179 #define SQL_ASYNC_ENABLE_OFF 0UL
180 #define SQL_SC_NON_UNIQUE 0UL
181 #define SQL_UB_OFF 0UL
182 #define SQL_PC_NOT_PSEUDO 1
183 #define SQL_PC_NON_PSEUDO SQL_PC_NOT_PSEUDO
184 #define SQL_UNSEARCHABLE 0
185 #define SQL_FD_FETCH_NEXT 0x00000001L
186 #define SQL_FD_FETCH_FIRST 0x00000002L
187 #define SQL_FD_FETCH_LAST 0x00000004L
188 #define SQL_FD_FETCH_PRIOR 0x00000008L
189 #define SQL_FD_FETCH_PREV SQL_FD_FETCH_PRIOR
190 #define SQL_FD_FETCH_ABSOLUTE 0x00000010L
191 #define SQL_FD_FETCH_RELATIVE 0x00000020L
193 #define SQL_FN_NUM_ABS 0x00000001L
194 #define SQL_FN_NUM_ACOS 0x00000002L
195 #define SQL_FN_NUM_ASIN 0x00000004L
196 #define SQL_FN_NUM_ATAN 0x00000008L
197 #define SQL_FN_NUM_ATAN2 0x00000010L
198 #define SQL_FN_NUM_CEILING 0x00000020L
199 #define SQL_FN_NUM_COS 0x00000040L
200 #define SQL_FN_NUM_COT 0x00000080L
201 #define SQL_FN_NUM_EXP 0x00000100L
202 #define SQL_FN_NUM_FLOOR 0x00000200L
203 #define SQL_FN_NUM_LOG 0x00000400L
204 #define SQL_FN_NUM_MOD 0x00000800L
205 #define SQL_FN_NUM_SIGN 0x00001000L
206 #define SQL_FN_NUM_SIN 0x00002000L
207 #define SQL_FN_NUM_SQRT 0x00004000L
208 #define SQL_FN_NUM_TAN 0x00008000L
209 #define SQL_FN_NUM_PI 0x00010000L
210 #define SQL_FN_NUM_RAND 0x00020000L
211 #define SQL_FN_NUM_DEGREES 0x00040000L
212 #define SQL_FN_NUM_LOG10 0x00080000L
213 #define SQL_FN_NUM_POWER 0x00100000L
214 #define SQL_FN_NUM_RADIANS 0x00200000L
215 #define SQL_FN_NUM_ROUND 0x00400000L
216 #define SQL_FN_NUM_TRUNCATE 0x00800000L
218 #define SQL_FN_STR_CONCAT 0x00000001L
219 #define SQL_FN_STR_INSERT 0x00000002L
220 #define SQL_FN_STR_LEFT 0x00000004L
221 #define SQL_FN_STR_LTRIM 0x00000008L
222 #define SQL_FN_STR_LENGTH 0x00000010L
223 #define SQL_FN_STR_LOCATE 0x00000020L
224 #define SQL_FN_STR_LCASE 0x00000040L
225 #define SQL_FN_STR_REPEAT 0x00000080L
226 #define SQL_FN_STR_REPLACE 0x00000100L
227 #define SQL_FN_STR_RIGHT 0x00000200L
228 #define SQL_FN_STR_RTRIM 0x00000400L
229 #define SQL_FN_STR_SUBSTRING 0x00000800L
230 #define SQL_FN_STR_UCASE 0x00001000L
231 #define SQL_FN_STR_ASCII 0x00002000L
232 #define SQL_FN_STR_CHAR 0x00004000L
233 #define SQL_FN_STR_DIFFERENCE 0x00008000L
234 #define SQL_FN_STR_LOCATE_2 0x00010000L
235 #define SQL_FN_STR_SOUNDEX 0x00020000L
236 #define SQL_FN_STR_SPACE 0x00040000L
237 #define SQL_FN_STR_BIT_LENGTH 0x00080000L
238 #define SQL_FN_STR_CHAR_LENGTH 0x00100000L
239 #define SQL_FN_STR_CHARACTER_LENGTH 0x00200000L
240 #define SQL_FN_STR_OCTET_LENGTH 0x00400000L
241 #define SQL_FN_STR_POSITION 0x00800000L
243 #define SQL_FN_TD_NOW 0x00000001L
244 #define SQL_FN_TD_CURDATE 0x00000002L
245 #define SQL_FN_TD_DAYOFMONTH 0x00000004L
246 #define SQL_FN_TD_DAYOFWEEK 0x00000008L
247 #define SQL_FN_TD_DAYOFYEAR 0x00000010L
248 #define SQL_FN_TD_MONTH 0x00000020L
249 #define SQL_FN_TD_QUARTER 0x00000040L
250 #define SQL_FN_TD_WEEK 0x00000080L
251 #define SQL_FN_TD_YEAR 0x00000100L
252 #define SQL_FN_TD_CURTIME 0x00000200L
253 #define SQL_FN_TD_HOUR 0x00000400L
254 #define SQL_FN_TD_MINUTE 0x00000800L
255 #define SQL_FN_TD_SECOND 0x00001000L
256 #define SQL_FN_TD_TIMESTAMPADD 0x00002000L
257 #define SQL_FN_TD_TIMESTAMPDIFF 0x00004000L
258 #define SQL_FN_TD_DAYNAME 0x00008000L
259 #define SQL_FN_TD_MONTHNAME 0x00010000L
260 #define SQL_FN_TD_CURRENT_DATE 0x00020000L
261 #define SQL_FN_TD_CURRENT_TIME 0x00040000L
262 #define SQL_FN_TD_CURRENT_TIMESTAMP 0x00080000L
263 #define SQL_FN_TD_EXTRACT 0x00100000L
265 #define SQL_POS_POSITION 0x00000001L
266 #define SQL_AT_ADD_COLUMN 0x00000001L
267 #define SQL_AT_DROP_COLUMN 0x00000002L
268 #define SQL_GB_NO_RELATION 0x0003
269 #define SQL_BIND_BY_COLUMN 0UL
270 #define SQL_BIND_TYPE_DEFAULT SQL_BIND_BY_COLUMN /* Default value */
271 #define SQL_ATTR_READONLY 0
272 #define SQL_FETCH_PREV SQL_FETCH_PRIOR
273 #define SQL_ROW_SUCCESS 0
274 #define SQL_ROW_NOROW 3
277 #define SQL_RD_OFF 0UL
278 #define SQL_RD_ON 1UL
279 #define SQL_RD_DEFAULT SQL_RD_ON
281 #define SQL_NOSCAN_OFF 0UL
282 #define SQL_NOSCAN_ON 1UL
283 #define SQL_NOSCAN_DEFAULT SQL_NOSCAN_OFF