ViewVC Help
View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing
root/public/ibx/trunk/fbintf/include/inf_pub.inc
Revision: 143
Committed: Fri Feb 23 12:11:21 2018 UTC (6 years, 2 months ago) by tony
File size: 11476 byte(s)
Log Message:
Fixes Merged

File Contents

# User Rev Content
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