1 |
tony |
45 |
(* |
2 |
|
|
* PROGRAM: JRD Access Method |
3 |
|
|
* MODULE: inf.h |
4 |
|
|
* DESCRIPTION: Information call declarations. |
5 |
|
|
* |
6 |
|
|
* The contents of this file are subject to the Interbase Public |
7 |
|
|
* License Version 1.0 (the "License"); you may not use this file |
8 |
|
|
* except in compliance with the License. You may obtain a copy |
9 |
|
|
* of the License at http://www.Inprise.com/IPL.html |
10 |
|
|
* |
11 |
|
|
* Software distributed under the License is distributed on an |
12 |
|
|
* "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express |
13 |
|
|
* or implied. See the License for the specific language governing |
14 |
|
|
* rights and limitations under the License. |
15 |
|
|
* |
16 |
|
|
* The Original Code was created by Inprise Corporation |
17 |
|
|
* and its predecessors. Portions created by Inprise Corporation are |
18 |
|
|
* Copyright (C) Inprise Corporation. |
19 |
|
|
* |
20 |
|
|
* All Rights Reserved. |
21 |
|
|
* Contributor(s): ______________________________________. |
22 |
|
|
* |
23 |
|
|
* 2001.07.28: John Bellardo: Added isc_info_rsb_skip to support LIMIT. |
24 |
|
|
*) |
25 |
|
|
|
26 |
|
|
const |
27 |
|
|
(* Common; structural codes *) |
28 |
|
|
(****************************) |
29 |
|
|
|
30 |
|
|
isc_info_end = 1; |
31 |
|
|
isc_info_truncated = 2; |
32 |
|
|
isc_info_error = 3; |
33 |
|
|
isc_info_data_not_ready = 4; |
34 |
|
|
isc_info_length = 126; |
35 |
|
|
isc_info_flag_end = 127; |
36 |
|
|
|
37 |
|
|
(******************************) |
38 |
|
|
(* Database information items *) |
39 |
|
|
(******************************) |
40 |
|
|
|
41 |
|
|
|
42 |
|
|
isc_info_db_id = 4; |
43 |
|
|
isc_info_reads = 5; |
44 |
|
|
isc_info_writes = 6; |
45 |
|
|
isc_info_fetches = 7; |
46 |
|
|
isc_info_marks = 8; |
47 |
|
|
|
48 |
|
|
isc_info_implementation = 11; |
49 |
|
|
isc_info_isc_version = 12; |
50 |
|
|
isc_info_base_level = 13; |
51 |
|
|
isc_info_page_size = 14; |
52 |
|
|
isc_info_num_buffers = 15; |
53 |
|
|
isc_info_limbo = 16; |
54 |
|
|
isc_info_current_memory = 17; |
55 |
|
|
isc_info_max_memory = 18; |
56 |
|
|
isc_info_window_turns = 19; |
57 |
|
|
isc_info_license = 20; |
58 |
|
|
|
59 |
|
|
isc_info_allocation = 21; |
60 |
|
|
isc_info_attachment_id = 22; |
61 |
|
|
isc_info_read_seq_count = 23; |
62 |
|
|
isc_info_read_idx_count = 24; |
63 |
|
|
isc_info_insert_count = 25; |
64 |
|
|
isc_info_update_count = 26; |
65 |
|
|
isc_info_delete_count = 27; |
66 |
|
|
isc_info_backout_count = 28; |
67 |
|
|
isc_info_purge_count = 29; |
68 |
|
|
isc_info_expunge_count = 30; |
69 |
|
|
|
70 |
|
|
isc_info_sweep_interval = 31; |
71 |
|
|
isc_info_ods_version = 32; |
72 |
|
|
isc_info_ods_minor_version = 33; |
73 |
|
|
isc_info_no_reserve = 34; |
74 |
|
|
(* Begin deprecated WAL and JOURNAL items. *) |
75 |
|
|
isc_info_logfile = 35; |
76 |
|
|
isc_info_cur_logfile_name = 36; |
77 |
|
|
isc_info_cur_log_part_offset = 37; |
78 |
|
|
isc_info_num_wal_buffers = 38; |
79 |
|
|
isc_info_wal_buffer_size = 39; |
80 |
|
|
isc_info_wal_ckpt_length = 40; |
81 |
|
|
|
82 |
|
|
isc_info_wal_cur_ckpt_interval = 41; |
83 |
|
|
isc_info_wal_prv_ckpt_fname = 42; |
84 |
|
|
isc_info_wal_prv_ckpt_poffset = 43; |
85 |
|
|
isc_info_wal_recv_ckpt_fname = 44; |
86 |
|
|
isc_info_wal_recv_ckpt_poffset = 45; |
87 |
|
|
isc_info_wal_grpc_wait_usecs = 47; |
88 |
|
|
isc_info_wal_num_io = 48; |
89 |
|
|
isc_info_wal_avg_io_size = 49; |
90 |
|
|
isc_info_wal_num_commits = 50; |
91 |
|
|
isc_info_wal_avg_grpc_size = 51; |
92 |
|
|
(* End deprecated WAL and JOURNAL items. *) |
93 |
|
|
|
94 |
|
|
isc_info_forced_writes = 52; |
95 |
|
|
isc_info_user_names = 53; |
96 |
|
|
isc_info_page_errors = 54; |
97 |
|
|
isc_info_record_errors = 55; |
98 |
|
|
isc_info_bpage_errors = 56; |
99 |
|
|
isc_info_dpage_errors = 57; |
100 |
|
|
isc_info_ipage_errors = 58; |
101 |
|
|
isc_info_ppage_errors = 59; |
102 |
|
|
isc_info_tpage_errors = 60; |
103 |
|
|
|
104 |
|
|
isc_info_set_page_buffers = 61; |
105 |
|
|
isc_info_db_sql_dialect = 62; |
106 |
|
|
isc_info_db_read_only = 63; |
107 |
|
|
isc_info_db_size_in_pages = 64; |
108 |
|
|
|
109 |
|
|
(* Values 65 -100 unused to avoid conflict with InterBase *) |
110 |
|
|
|
111 |
|
|
frb_info_att_charset = 101; |
112 |
|
|
isc_info_db_class = 102; |
113 |
|
|
isc_info_firebird_version = 103; |
114 |
|
|
isc_info_oldest_transaction = 104; |
115 |
|
|
isc_info_oldest_active = 105; |
116 |
|
|
isc_info_oldest_snapshot = 106; |
117 |
|
|
isc_info_next_transaction = 107; |
118 |
|
|
isc_info_db_provider = 108; |
119 |
|
|
isc_info_active_transactions = 109; |
120 |
|
|
isc_info_active_tran_count = 110; |
121 |
|
|
isc_info_creation_date = 111; |
122 |
|
|
isc_info_db_file_size = 112; |
123 |
|
|
fb_info_page_contents = 113; |
124 |
tony |
143 |
fb_info_implementation = 114; |
125 |
|
|
fb_info_page_warns = 115; |
126 |
|
|
fb_info_record_warns = 116; |
127 |
|
|
fb_info_bpage_warns = 117; |
128 |
|
|
fb_info_dpage_warns = 118; |
129 |
|
|
fb_info_ipage_warns = 119; |
130 |
|
|
fb_info_ppage_warns = 120; |
131 |
|
|
fb_info_tpage_warns = 121; |
132 |
|
|
fb_info_pip_errors = 122; |
133 |
|
|
fb_info_pip_warns = 123; |
134 |
tony |
45 |
|
135 |
tony |
143 |
fb_info_pages_used = 124; |
136 |
|
|
fb_info_pages_free = 125; |
137 |
tony |
45 |
|
138 |
tony |
143 |
fb_info_conn_flags = 132; |
139 |
tony |
45 |
|
140 |
tony |
143 |
fb_info_crypt_key = 133; |
141 |
|
|
fb_info_crypt_state = 134; |
142 |
|
|
|
143 |
|
|
isc_info_db_last_value = fb_info_crypt_state; (* Leave this LAST! *) |
144 |
|
|
|
145 |
|
|
|
146 |
tony |
45 |
isc_info_version = isc_info_isc_version; |
147 |
|
|
|
148 |
tony |
143 |
{ flags set in fb_info_crypt_state } |
149 |
tony |
45 |
|
150 |
tony |
143 |
fb_info_crypt_encrypted = $01; |
151 |
|
|
fb_info_crypt_process = $02; |
152 |
|
|
|
153 |
|
|
|
154 |
tony |
45 |
(**************************************) |
155 |
|
|
(* Database information return values *) |
156 |
|
|
(**************************************) |
157 |
|
|
|
158 |
|
|
|
159 |
|
|
isc_info_db_impl_rdb_vms = 1; |
160 |
|
|
isc_info_db_impl_rdb_eln = 2; |
161 |
|
|
isc_info_db_impl_rdb_eln_dev = 3; |
162 |
|
|
isc_info_db_impl_rdb_vms_y = 4; |
163 |
|
|
isc_info_db_impl_rdb_eln_y = 5; |
164 |
|
|
isc_info_db_impl_jri = 6; |
165 |
|
|
isc_info_db_impl_jsv = 7; |
166 |
|
|
|
167 |
|
|
isc_info_db_impl_isc_apl_68K = 25; |
168 |
|
|
isc_info_db_impl_isc_vax_ultr = 26; |
169 |
|
|
isc_info_db_impl_isc_vms = 27; |
170 |
|
|
isc_info_db_impl_isc_sun_68k = 28; |
171 |
|
|
isc_info_db_impl_isc_os2 = 29; |
172 |
|
|
isc_info_db_impl_isc_sun4 = 30; (* 30 *) |
173 |
|
|
|
174 |
|
|
isc_info_db_impl_isc_hp_ux = 31; |
175 |
|
|
isc_info_db_impl_isc_sun_386i = 32; |
176 |
|
|
isc_info_db_impl_isc_vms_orcl = 33; |
177 |
|
|
isc_info_db_impl_isc_mac_aux = 34; |
178 |
|
|
isc_info_db_impl_isc_rt_aix = 35; |
179 |
|
|
isc_info_db_impl_isc_mips_ult = 36; |
180 |
|
|
isc_info_db_impl_isc_xenix = 37; |
181 |
|
|
isc_info_db_impl_isc_dg = 38; |
182 |
|
|
isc_info_db_impl_isc_hp_mpexl = 39; |
183 |
|
|
isc_info_db_impl_isc_hp_ux68K = 40; (* 40 *) |
184 |
|
|
|
185 |
|
|
isc_info_db_impl_isc_sgi = 41; |
186 |
|
|
isc_info_db_impl_isc_sco_unix = 42; |
187 |
|
|
isc_info_db_impl_isc_cray = 43; |
188 |
|
|
isc_info_db_impl_isc_imp = 44; |
189 |
|
|
isc_info_db_impl_isc_delta = 45; |
190 |
|
|
isc_info_db_impl_isc_next = 46; |
191 |
|
|
isc_info_db_impl_isc_dos = 47; |
192 |
|
|
isc_info_db_impl_m88K = 48; |
193 |
|
|
isc_info_db_impl_unixware = 49; |
194 |
|
|
isc_info_db_impl_isc_winnt_x86 = 50; |
195 |
|
|
|
196 |
|
|
isc_info_db_impl_isc_epson = 51; |
197 |
|
|
isc_info_db_impl_alpha_osf = 52; |
198 |
|
|
isc_info_db_impl_alpha_vms = 53; |
199 |
|
|
isc_info_db_impl_netware_386 = 54; |
200 |
|
|
isc_info_db_impl_win_only = 55; |
201 |
|
|
isc_info_db_impl_ncr_3000 = 56; |
202 |
|
|
isc_info_db_impl_winnt_ppc = 57; |
203 |
|
|
isc_info_db_impl_dg_x86 = 58; |
204 |
|
|
isc_info_db_impl_sco_ev = 59; |
205 |
|
|
isc_info_db_impl_i386 = 60; |
206 |
|
|
|
207 |
|
|
isc_info_db_impl_freebsd = 61; |
208 |
|
|
isc_info_db_impl_netbsd = 62; |
209 |
|
|
isc_info_db_impl_darwin_ppc = 63; |
210 |
|
|
isc_info_db_impl_sinixz = 64; |
211 |
|
|
|
212 |
|
|
isc_info_db_impl_linux_sparc = 65; |
213 |
|
|
isc_info_db_impl_linux_amd64 = 66; |
214 |
|
|
|
215 |
|
|
isc_info_db_impl_freebsd_amd64 = 67; |
216 |
|
|
|
217 |
|
|
isc_info_db_impl_winnt_amd64 = 68; |
218 |
|
|
|
219 |
|
|
isc_info_db_impl_linux_ppc = 69; |
220 |
|
|
isc_info_db_impl_darwin_x86 = 70; |
221 |
|
|
isc_info_db_impl_linux_mipsel = 71; |
222 |
|
|
isc_info_db_impl_linux_mips = 72; |
223 |
|
|
isc_info_db_impl_darwin_x64 = 73; |
224 |
|
|
isc_info_db_impl_sun_amd64 = 74; |
225 |
|
|
|
226 |
|
|
isc_info_db_impl_linux_arm = 75; |
227 |
|
|
isc_info_db_impl_linux_ia64 = 76; |
228 |
|
|
|
229 |
|
|
isc_info_db_impl_darwin_ppc64 = 77; |
230 |
|
|
isc_info_db_impl_linux_s390x = 78; |
231 |
|
|
isc_info_db_impl_linux_s390 = 79; |
232 |
|
|
|
233 |
|
|
isc_info_db_impl_linux_sh = 80; |
234 |
|
|
isc_info_db_impl_linux_sheb = 81; |
235 |
|
|
isc_info_db_impl_linux_hppa = 82; |
236 |
|
|
isc_info_db_impl_linux_alpha = 83; |
237 |
|
|
|
238 |
|
|
isc_info_db_impl_last_value = isc_info_db_impl_linux_alpha; // Leave this LAST! |
239 |
|
|
|
240 |
|
|
|
241 |
|
|
|
242 |
|
|
|
243 |
|
|
isc_info_db_class_access = 1; |
244 |
|
|
isc_info_db_class_y_valve = 2; |
245 |
|
|
isc_info_db_class_rem_int = 3; |
246 |
|
|
isc_info_db_class_rem_srvr = 4; |
247 |
|
|
isc_info_db_class_pipe_int = 7; |
248 |
|
|
isc_info_db_class_pipe_srvr = 8; |
249 |
|
|
isc_info_db_class_sam_int = 9; |
250 |
|
|
isc_info_db_class_sam_srvr = 10; |
251 |
|
|
isc_info_db_class_gateway = 11; |
252 |
|
|
isc_info_db_class_cache = 12; |
253 |
|
|
isc_info_db_class_classic_access = 13; |
254 |
|
|
isc_info_db_class_server_access = 14; |
255 |
|
|
|
256 |
|
|
isc_info_db_class_last_value = isc_info_db_class_server_access; (* Leave this LAST! *) |
257 |
|
|
|
258 |
|
|
|
259 |
|
|
|
260 |
|
|
isc_info_db_code_rdb_eln = 1; |
261 |
|
|
isc_info_db_code_rdb_vms = 2; |
262 |
|
|
isc_info_db_code_interbase = 3; |
263 |
|
|
isc_info_db_code_firebird = 4; |
264 |
|
|
|
265 |
|
|
isc_info_db_code_last_value = isc_info_db_code_firebird; (* Leave this LAST! *) |
266 |
|
|
|
267 |
|
|
|
268 |
|
|
(*****************************) |
269 |
|
|
(* Request information items *) |
270 |
|
|
(*****************************) |
271 |
|
|
|
272 |
|
|
isc_info_number_messages = 4; |
273 |
|
|
isc_info_max_message = 5; |
274 |
|
|
isc_info_max_send = 6; |
275 |
|
|
isc_info_max_receive = 7; |
276 |
|
|
isc_info_state = 8; |
277 |
|
|
isc_info_message_number = 9; |
278 |
|
|
isc_info_message_size = 10; |
279 |
|
|
isc_info_request_cost = 11; |
280 |
|
|
isc_info_access_path = 12; |
281 |
|
|
isc_info_req_select_count = 13; |
282 |
|
|
isc_info_req_insert_count = 14; |
283 |
|
|
isc_info_req_update_count = 15; |
284 |
|
|
isc_info_req_delete_count = 16; |
285 |
|
|
|
286 |
|
|
|
287 |
|
|
(*********************) |
288 |
|
|
(* Access path items *) |
289 |
|
|
(*********************) |
290 |
|
|
|
291 |
|
|
isc_info_rsb_end = 0; |
292 |
|
|
isc_info_rsb_begin = 1; |
293 |
|
|
isc_info_rsb_type = 2; |
294 |
|
|
isc_info_rsb_relation = 3; |
295 |
|
|
isc_info_rsb_plan = 4; |
296 |
|
|
|
297 |
|
|
(*************) |
298 |
|
|
(* RecordSource (RSB) types *) |
299 |
|
|
(*************) |
300 |
|
|
|
301 |
|
|
isc_info_rsb_unknown = 1; |
302 |
|
|
isc_info_rsb_indexed = 2; |
303 |
|
|
isc_info_rsb_navigate = 3; |
304 |
|
|
isc_info_rsb_sequential = 4; |
305 |
|
|
isc_info_rsb_cross = 5; |
306 |
|
|
isc_info_rsb_sort = 6; |
307 |
|
|
isc_info_rsb_first = 7; |
308 |
|
|
isc_info_rsb_boolean = 8; |
309 |
|
|
isc_info_rsb_union = 9; |
310 |
|
|
isc_info_rsb_aggregate = 10; |
311 |
|
|
isc_info_rsb_merge = 11; |
312 |
|
|
isc_info_rsb_ext_sequential = 12; |
313 |
|
|
isc_info_rsb_ext_indexed = 13; |
314 |
|
|
isc_info_rsb_ext_dbkey = 14; |
315 |
|
|
isc_info_rsb_left_cross = 15; |
316 |
|
|
isc_info_rsb_select = 16; |
317 |
|
|
isc_info_rsb_sql_join = 17; |
318 |
|
|
isc_info_rsb_simulate = 18; |
319 |
|
|
isc_info_rsb_sim_cross = 19; |
320 |
|
|
isc_info_rsb_once = 20; |
321 |
|
|
isc_info_rsb_procedure = 21; |
322 |
|
|
isc_info_rsb_skip = 22; |
323 |
|
|
isc_info_rsb_virt_sequential = 23; |
324 |
|
|
isc_info_rsb_recursive = 24; |
325 |
|
|
|
326 |
|
|
(**********************) |
327 |
|
|
(* Bitmap expressions *) |
328 |
|
|
(**********************) |
329 |
|
|
|
330 |
|
|
isc_info_rsb_and = 1; |
331 |
|
|
isc_info_rsb_or = 2; |
332 |
|
|
isc_info_rsb_dbkey = 3; |
333 |
|
|
isc_info_rsb_index = 4; |
334 |
|
|
|
335 |
|
|
isc_info_req_active = 2; |
336 |
|
|
isc_info_req_inactive = 3; |
337 |
|
|
isc_info_req_send = 4; |
338 |
|
|
isc_info_req_receive = 5; |
339 |
|
|
isc_info_req_select = 6; |
340 |
|
|
isc_info_req_sql_stall = 7; |
341 |
|
|
|
342 |
|
|
(**************************) |
343 |
|
|
(* Blob information items *) |
344 |
|
|
(**************************) |
345 |
|
|
|
346 |
|
|
isc_info_blob_num_segments = 4; |
347 |
|
|
isc_info_blob_max_segment = 5; |
348 |
|
|
isc_info_blob_total_length = 6; |
349 |
|
|
isc_info_blob_type = 7; |
350 |
|
|
|
351 |
|
|
(*********************************) |
352 |
|
|
(* Transaction information items *) |
353 |
|
|
(*********************************) |
354 |
|
|
|
355 |
|
|
isc_info_tra_id = 4; |
356 |
|
|
isc_info_tra_oldest_interesting = 5; |
357 |
|
|
isc_info_tra_oldest_snapshot = 6; |
358 |
|
|
isc_info_tra_oldest_active = 7; |
359 |
|
|
isc_info_tra_isolation = 8; |
360 |
|
|
isc_info_tra_access = 9; |
361 |
|
|
isc_info_tra_lock_timeout = 10; |
362 |
|
|
|
363 |
|
|
// isc_info_tra_isolation responses |
364 |
|
|
isc_info_tra_consistency = 1; |
365 |
|
|
isc_info_tra_concurrency = 2; |
366 |
|
|
isc_info_tra_read_committed = 3; |
367 |
|
|
|
368 |
|
|
// isc_info_tra_read_committed options |
369 |
|
|
isc_info_tra_no_rec_version = 0; |
370 |
|
|
isc_info_tra_rec_version = 1; |
371 |
|
|
|
372 |
|
|
// isc_info_tra_access responses |
373 |
|
|
isc_info_tra_readonly = 0; |
374 |
|
|
isc_info_tra_readwrite = 1; |
375 |
|
|
|
376 |
|
|
|
377 |
|
|
(*************************) |
378 |
|
|
(* SQL information items *) |
379 |
|
|
(*************************) |
380 |
|
|
|
381 |
|
|
isc_info_sql_select = 4; |
382 |
|
|
isc_info_sql_bind = 5; |
383 |
|
|
isc_info_sql_num_variables = 6; |
384 |
|
|
isc_info_sql_describe_vars = 7; |
385 |
|
|
isc_info_sql_describe_end = 8; |
386 |
|
|
isc_info_sql_sqlda_seq = 9; |
387 |
|
|
isc_info_sql_message_seq = 10; |
388 |
|
|
isc_info_sql_type = 11; |
389 |
|
|
isc_info_sql_sub_type = 12; |
390 |
|
|
isc_info_sql_scale = 13; |
391 |
|
|
isc_info_sql_length = 14; |
392 |
|
|
isc_info_sql_null_ind = 15; |
393 |
|
|
isc_info_sql_field = 16; |
394 |
|
|
isc_info_sql_relation = 17; |
395 |
|
|
isc_info_sql_owner = 18; |
396 |
|
|
isc_info_sql_alias = 19; |
397 |
|
|
isc_info_sql_sqlda_start = 20; |
398 |
|
|
isc_info_sql_stmt_type = 21; |
399 |
|
|
isc_info_sql_get_plan = 22; |
400 |
|
|
isc_info_sql_records = 23; |
401 |
|
|
isc_info_sql_batch_fetch = 24; |
402 |
|
|
isc_info_sql_relation_alias = 25; |
403 |
|
|
|
404 |
|
|
(*********************************) |
405 |
|
|
(* SQL information return values *) |
406 |
|
|
(*********************************) |
407 |
|
|
|
408 |
|
|
isc_info_sql_stmt_select = 1; |
409 |
|
|
isc_info_sql_stmt_insert = 2; |
410 |
|
|
isc_info_sql_stmt_update = 3; |
411 |
|
|
isc_info_sql_stmt_delete = 4; |
412 |
|
|
isc_info_sql_stmt_ddl = 5; |
413 |
|
|
isc_info_sql_stmt_get_segment = 6; |
414 |
|
|
isc_info_sql_stmt_put_segment = 7; |
415 |
|
|
isc_info_sql_stmt_exec_procedure = 8; |
416 |
|
|
isc_info_sql_stmt_start_trans = 9; |
417 |
|
|
isc_info_sql_stmt_commit = 10; |
418 |
|
|
isc_info_sql_stmt_rollback = 11; |
419 |
|
|
isc_info_sql_stmt_select_for_upd = 12; |
420 |
|
|
isc_info_sql_stmt_set_generator = 13; |
421 |
|
|
isc_info_sql_stmt_savepoint = 14; |
422 |
|
|
|
423 |
|
|
|