]>
Commit | Line | Data |
---|---|---|
7e616b10 RR |
1 | #define SQL_MAX_USER_NAME_LEN 107 |
2 | #define SQL_SPEC_STRING "02.50" /* String constant for version */ | |
1a6944fd RR |
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 | |
1a6944fd | 49 | #define SQL_STRING_FUNCTIONS 50 |
1a6944fd | 50 | #define SQL_TIMEDATE_FUNCTIONS 52 |
7e616b10 | 51 | |
1a6944fd RR |
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 | |
7e616b10 RR |
106 | #define SQL_MAX_OPTION_STRING_LENGTH 256 |
107 | ||
1a6944fd RR |
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 | |
140 | #define SQL_UNION 96 | |
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 | |
7e616b10 | 156 | #define SQL_IC_MIXED 0x0004 |
1a6944fd RR |
157 | #define SQL_FN_SYS_DBNAME 0x00000002L |
158 | #define SQL_FN_SYS_IFNULL 0x00000004L | |
159 | #define SQL_FN_SYS_USERNAME 0x00000001L | |
1a6944fd RR |
160 | #define SQL_FN_STR_INSERT 0x00000002L |
161 | #define SQL_FN_STR_LTRIM 0x00000008L | |
162 | #define SQL_FN_STR_RTRIM 0x00000400L | |
163 | #define SQL_BLOB 21 | |
164 | #define SQL_BLOB_LOCATOR 22 | |
165 | #define SQL_CLOB 23 | |
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 | |
7e616b10 | 177 | #define SQL_TC_NONE 0x0000 |
1a6944fd RR |
178 | #define SQL_NOSCAN_OFF 0UL |
179 | #define SQL_ASYNC_ENABLE_OFF 0UL | |
1a6944fd RR |
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 | |
7e616b10 RR |
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 | |
1a6944fd | 192 | |
7e616b10 RR |
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 | |
1a6944fd | 217 | |
7e616b10 RR |
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 | |
1a6944fd | 242 | |
7e616b10 RR |
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 | |
1a6944fd | 264 | |
7e616b10 RR |
265 | #define SQL_POS_POSITION 0x00000001L |
266 | #define SQL_AT_ADD_COLUMN 0x00000001L | |
267 | #define SQL_AT_DROP_COLUMN 0x00000002L | |
1a6944fd | 268 | #define SQL_GB_NO_RELATION 0x0003 |
7e616b10 RR |
269 | #define SQL_BIND_BY_COLUMN 0UL |
270 | #define SQL_BIND_TYPE_DEFAULT SQL_BIND_BY_COLUMN /* Default value */ | |
1a6944fd | 271 | #define SQL_ATTR_READONLY 0 |
7e616b10 RR |
272 | #define SQL_FETCH_PREV SQL_FETCH_PRIOR |
273 | #define SQL_ROW_SUCCESS 0 | |
274 | #define SQL_ROW_NOROW 3 | |
275 | #define SQL_NOSCAN 2 | |
1a6944fd | 276 | |
7e616b10 RR |
277 | #define SQL_RD_OFF 0UL |
278 | #define SQL_RD_ON 1UL | |
279 | #define SQL_RD_DEFAULT SQL_RD_ON | |
1a6944fd | 280 | |
7e616b10 RR |
281 | #define SQL_NOSCAN_OFF 0UL |
282 | #define SQL_NOSCAN_ON 1UL | |
283 | #define SQL_NOSCAN_DEFAULT SQL_NOSCAN_OFF |