1 |
(*
|
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 |
|
125 |
isc_info_db_last_value = fb_info_page_contents; (* Leave this LAST! *)
|
126 |
|
127 |
|
128 |
isc_info_version = isc_info_isc_version;
|
129 |
|
130 |
|
131 |
(**************************************)
|
132 |
(* Database information return values *)
|
133 |
(**************************************)
|
134 |
|
135 |
|
136 |
isc_info_db_impl_rdb_vms = 1;
|
137 |
isc_info_db_impl_rdb_eln = 2;
|
138 |
isc_info_db_impl_rdb_eln_dev = 3;
|
139 |
isc_info_db_impl_rdb_vms_y = 4;
|
140 |
isc_info_db_impl_rdb_eln_y = 5;
|
141 |
isc_info_db_impl_jri = 6;
|
142 |
isc_info_db_impl_jsv = 7;
|
143 |
|
144 |
isc_info_db_impl_isc_apl_68K = 25;
|
145 |
isc_info_db_impl_isc_vax_ultr = 26;
|
146 |
isc_info_db_impl_isc_vms = 27;
|
147 |
isc_info_db_impl_isc_sun_68k = 28;
|
148 |
isc_info_db_impl_isc_os2 = 29;
|
149 |
isc_info_db_impl_isc_sun4 = 30; (* 30 *)
|
150 |
|
151 |
isc_info_db_impl_isc_hp_ux = 31;
|
152 |
isc_info_db_impl_isc_sun_386i = 32;
|
153 |
isc_info_db_impl_isc_vms_orcl = 33;
|
154 |
isc_info_db_impl_isc_mac_aux = 34;
|
155 |
isc_info_db_impl_isc_rt_aix = 35;
|
156 |
isc_info_db_impl_isc_mips_ult = 36;
|
157 |
isc_info_db_impl_isc_xenix = 37;
|
158 |
isc_info_db_impl_isc_dg = 38;
|
159 |
isc_info_db_impl_isc_hp_mpexl = 39;
|
160 |
isc_info_db_impl_isc_hp_ux68K = 40; (* 40 *)
|
161 |
|
162 |
isc_info_db_impl_isc_sgi = 41;
|
163 |
isc_info_db_impl_isc_sco_unix = 42;
|
164 |
isc_info_db_impl_isc_cray = 43;
|
165 |
isc_info_db_impl_isc_imp = 44;
|
166 |
isc_info_db_impl_isc_delta = 45;
|
167 |
isc_info_db_impl_isc_next = 46;
|
168 |
isc_info_db_impl_isc_dos = 47;
|
169 |
isc_info_db_impl_m88K = 48;
|
170 |
isc_info_db_impl_unixware = 49;
|
171 |
isc_info_db_impl_isc_winnt_x86 = 50;
|
172 |
|
173 |
isc_info_db_impl_isc_epson = 51;
|
174 |
isc_info_db_impl_alpha_osf = 52;
|
175 |
isc_info_db_impl_alpha_vms = 53;
|
176 |
isc_info_db_impl_netware_386 = 54;
|
177 |
isc_info_db_impl_win_only = 55;
|
178 |
isc_info_db_impl_ncr_3000 = 56;
|
179 |
isc_info_db_impl_winnt_ppc = 57;
|
180 |
isc_info_db_impl_dg_x86 = 58;
|
181 |
isc_info_db_impl_sco_ev = 59;
|
182 |
isc_info_db_impl_i386 = 60;
|
183 |
|
184 |
isc_info_db_impl_freebsd = 61;
|
185 |
isc_info_db_impl_netbsd = 62;
|
186 |
isc_info_db_impl_darwin_ppc = 63;
|
187 |
isc_info_db_impl_sinixz = 64;
|
188 |
|
189 |
isc_info_db_impl_linux_sparc = 65;
|
190 |
isc_info_db_impl_linux_amd64 = 66;
|
191 |
|
192 |
isc_info_db_impl_freebsd_amd64 = 67;
|
193 |
|
194 |
isc_info_db_impl_winnt_amd64 = 68;
|
195 |
|
196 |
isc_info_db_impl_linux_ppc = 69;
|
197 |
isc_info_db_impl_darwin_x86 = 70;
|
198 |
isc_info_db_impl_linux_mipsel = 71;
|
199 |
isc_info_db_impl_linux_mips = 72;
|
200 |
isc_info_db_impl_darwin_x64 = 73;
|
201 |
isc_info_db_impl_sun_amd64 = 74;
|
202 |
|
203 |
isc_info_db_impl_linux_arm = 75;
|
204 |
isc_info_db_impl_linux_ia64 = 76;
|
205 |
|
206 |
isc_info_db_impl_darwin_ppc64 = 77;
|
207 |
isc_info_db_impl_linux_s390x = 78;
|
208 |
isc_info_db_impl_linux_s390 = 79;
|
209 |
|
210 |
isc_info_db_impl_linux_sh = 80;
|
211 |
isc_info_db_impl_linux_sheb = 81;
|
212 |
isc_info_db_impl_linux_hppa = 82;
|
213 |
isc_info_db_impl_linux_alpha = 83;
|
214 |
|
215 |
isc_info_db_impl_last_value = isc_info_db_impl_linux_alpha; // Leave this LAST!
|
216 |
|
217 |
|
218 |
|
219 |
|
220 |
isc_info_db_class_access = 1;
|
221 |
isc_info_db_class_y_valve = 2;
|
222 |
isc_info_db_class_rem_int = 3;
|
223 |
isc_info_db_class_rem_srvr = 4;
|
224 |
isc_info_db_class_pipe_int = 7;
|
225 |
isc_info_db_class_pipe_srvr = 8;
|
226 |
isc_info_db_class_sam_int = 9;
|
227 |
isc_info_db_class_sam_srvr = 10;
|
228 |
isc_info_db_class_gateway = 11;
|
229 |
isc_info_db_class_cache = 12;
|
230 |
isc_info_db_class_classic_access = 13;
|
231 |
isc_info_db_class_server_access = 14;
|
232 |
|
233 |
isc_info_db_class_last_value = isc_info_db_class_server_access; (* Leave this LAST! *)
|
234 |
|
235 |
|
236 |
|
237 |
isc_info_db_code_rdb_eln = 1;
|
238 |
isc_info_db_code_rdb_vms = 2;
|
239 |
isc_info_db_code_interbase = 3;
|
240 |
isc_info_db_code_firebird = 4;
|
241 |
|
242 |
isc_info_db_code_last_value = isc_info_db_code_firebird; (* Leave this LAST! *)
|
243 |
|
244 |
|
245 |
(*****************************)
|
246 |
(* Request information items *)
|
247 |
(*****************************)
|
248 |
|
249 |
isc_info_number_messages = 4;
|
250 |
isc_info_max_message = 5;
|
251 |
isc_info_max_send = 6;
|
252 |
isc_info_max_receive = 7;
|
253 |
isc_info_state = 8;
|
254 |
isc_info_message_number = 9;
|
255 |
isc_info_message_size = 10;
|
256 |
isc_info_request_cost = 11;
|
257 |
isc_info_access_path = 12;
|
258 |
isc_info_req_select_count = 13;
|
259 |
isc_info_req_insert_count = 14;
|
260 |
isc_info_req_update_count = 15;
|
261 |
isc_info_req_delete_count = 16;
|
262 |
|
263 |
|
264 |
(*********************)
|
265 |
(* Access path items *)
|
266 |
(*********************)
|
267 |
|
268 |
isc_info_rsb_end = 0;
|
269 |
isc_info_rsb_begin = 1;
|
270 |
isc_info_rsb_type = 2;
|
271 |
isc_info_rsb_relation = 3;
|
272 |
isc_info_rsb_plan = 4;
|
273 |
|
274 |
(*************)
|
275 |
(* RecordSource (RSB) types *)
|
276 |
(*************)
|
277 |
|
278 |
isc_info_rsb_unknown = 1;
|
279 |
isc_info_rsb_indexed = 2;
|
280 |
isc_info_rsb_navigate = 3;
|
281 |
isc_info_rsb_sequential = 4;
|
282 |
isc_info_rsb_cross = 5;
|
283 |
isc_info_rsb_sort = 6;
|
284 |
isc_info_rsb_first = 7;
|
285 |
isc_info_rsb_boolean = 8;
|
286 |
isc_info_rsb_union = 9;
|
287 |
isc_info_rsb_aggregate = 10;
|
288 |
isc_info_rsb_merge = 11;
|
289 |
isc_info_rsb_ext_sequential = 12;
|
290 |
isc_info_rsb_ext_indexed = 13;
|
291 |
isc_info_rsb_ext_dbkey = 14;
|
292 |
isc_info_rsb_left_cross = 15;
|
293 |
isc_info_rsb_select = 16;
|
294 |
isc_info_rsb_sql_join = 17;
|
295 |
isc_info_rsb_simulate = 18;
|
296 |
isc_info_rsb_sim_cross = 19;
|
297 |
isc_info_rsb_once = 20;
|
298 |
isc_info_rsb_procedure = 21;
|
299 |
isc_info_rsb_skip = 22;
|
300 |
isc_info_rsb_virt_sequential = 23;
|
301 |
isc_info_rsb_recursive = 24;
|
302 |
|
303 |
(**********************)
|
304 |
(* Bitmap expressions *)
|
305 |
(**********************)
|
306 |
|
307 |
isc_info_rsb_and = 1;
|
308 |
isc_info_rsb_or = 2;
|
309 |
isc_info_rsb_dbkey = 3;
|
310 |
isc_info_rsb_index = 4;
|
311 |
|
312 |
isc_info_req_active = 2;
|
313 |
isc_info_req_inactive = 3;
|
314 |
isc_info_req_send = 4;
|
315 |
isc_info_req_receive = 5;
|
316 |
isc_info_req_select = 6;
|
317 |
isc_info_req_sql_stall = 7;
|
318 |
|
319 |
(**************************)
|
320 |
(* Blob information items *)
|
321 |
(**************************)
|
322 |
|
323 |
isc_info_blob_num_segments = 4;
|
324 |
isc_info_blob_max_segment = 5;
|
325 |
isc_info_blob_total_length = 6;
|
326 |
isc_info_blob_type = 7;
|
327 |
|
328 |
(*********************************)
|
329 |
(* Transaction information items *)
|
330 |
(*********************************)
|
331 |
|
332 |
isc_info_tra_id = 4;
|
333 |
isc_info_tra_oldest_interesting = 5;
|
334 |
isc_info_tra_oldest_snapshot = 6;
|
335 |
isc_info_tra_oldest_active = 7;
|
336 |
isc_info_tra_isolation = 8;
|
337 |
isc_info_tra_access = 9;
|
338 |
isc_info_tra_lock_timeout = 10;
|
339 |
|
340 |
// isc_info_tra_isolation responses
|
341 |
isc_info_tra_consistency = 1;
|
342 |
isc_info_tra_concurrency = 2;
|
343 |
isc_info_tra_read_committed = 3;
|
344 |
|
345 |
// isc_info_tra_read_committed options
|
346 |
isc_info_tra_no_rec_version = 0;
|
347 |
isc_info_tra_rec_version = 1;
|
348 |
|
349 |
// isc_info_tra_access responses
|
350 |
isc_info_tra_readonly = 0;
|
351 |
isc_info_tra_readwrite = 1;
|
352 |
|
353 |
|
354 |
(*************************)
|
355 |
(* SQL information items *)
|
356 |
(*************************)
|
357 |
|
358 |
isc_info_sql_select = 4;
|
359 |
isc_info_sql_bind = 5;
|
360 |
isc_info_sql_num_variables = 6;
|
361 |
isc_info_sql_describe_vars = 7;
|
362 |
isc_info_sql_describe_end = 8;
|
363 |
isc_info_sql_sqlda_seq = 9;
|
364 |
isc_info_sql_message_seq = 10;
|
365 |
isc_info_sql_type = 11;
|
366 |
isc_info_sql_sub_type = 12;
|
367 |
isc_info_sql_scale = 13;
|
368 |
isc_info_sql_length = 14;
|
369 |
isc_info_sql_null_ind = 15;
|
370 |
isc_info_sql_field = 16;
|
371 |
isc_info_sql_relation = 17;
|
372 |
isc_info_sql_owner = 18;
|
373 |
isc_info_sql_alias = 19;
|
374 |
isc_info_sql_sqlda_start = 20;
|
375 |
isc_info_sql_stmt_type = 21;
|
376 |
isc_info_sql_get_plan = 22;
|
377 |
isc_info_sql_records = 23;
|
378 |
isc_info_sql_batch_fetch = 24;
|
379 |
isc_info_sql_relation_alias = 25;
|
380 |
|
381 |
(*********************************)
|
382 |
(* SQL information return values *)
|
383 |
(*********************************)
|
384 |
|
385 |
isc_info_sql_stmt_select = 1;
|
386 |
isc_info_sql_stmt_insert = 2;
|
387 |
isc_info_sql_stmt_update = 3;
|
388 |
isc_info_sql_stmt_delete = 4;
|
389 |
isc_info_sql_stmt_ddl = 5;
|
390 |
isc_info_sql_stmt_get_segment = 6;
|
391 |
isc_info_sql_stmt_put_segment = 7;
|
392 |
isc_info_sql_stmt_exec_procedure = 8;
|
393 |
isc_info_sql_stmt_start_trans = 9;
|
394 |
isc_info_sql_stmt_commit = 10;
|
395 |
isc_info_sql_stmt_rollback = 11;
|
396 |
isc_info_sql_stmt_select_for_upd = 12;
|
397 |
isc_info_sql_stmt_set_generator = 13;
|
398 |
isc_info_sql_stmt_savepoint = 14;
|
399 |
|
400 |
|