View source for Database Characteristics (API Guide)

{{Parent|Request Buffer Items and Result Buffer Values (API Guide)}}

Several items are available for determining database characteristics, such as its size and major and minor ODS version numbers. 

The following table lists the request buffer items that can be passed, and the information returned in the result buffer for each item type
{|class="wikitable"
|- valign="top"
! Request buffer item
! Result buffer contents
|- valign="top"
|
{{Code|allocation}}
|
Number of database pages allocated
|- valign="top"
|
{{Code|base_level}}
|
Database version (level) number:

* 1 byte containing the number 1
* 1 byte containing the version number
|- valign="top"
|
{{Code|db_id}}
|
* Database file name and site name:
* 1 byte containing the number 2 for a local connection or 4 for a remote connection
* 1 byte containing the length, d, of the database file name in bytes
* A string of d bytes, containing the database file name
* 1 byte containing the length, l, of the site name in bytes
* A string of l bytes, containing the site name
|- valign="top"
|
{{Code|implementation}}
|
Database implementation number:

* 1 byte containing a 1
* 1 byte containing the implementation number
* 1 byte containing a “class” number, either 1 or 12
|- valign="top"
|
{{Code|no_reserve}}
|
0 or 1

* 0 indicates space is reserved on each database page for holding backup versions of modified records [Default]
* 1 indicates no space is reserved for such records
|- valign="top"
|
{{Code|ods_minor_version}}
|
On-disk structure (ODS) minor version number; an increase in a minor version number indicates a non-structural change, which does not affect database access
|- valign="top"
|
{{Code|ods_version}}
|
* ODS major version number
|- valign="top"
|
{{Code|page_size}}
|
Number of bytes per page of the attached database; use with {{Code|isc_info_allocation}} to determine the size of the database
|- valign="top"
|
{{Code|sql_dialect}}
|
The SQL dialect supported by the database software
|- valign="top"
|
{{Code|version}}
|
Version identification string of the database implementation:

* 1 byte containing the number 1
* 1 byte specifying the length, {{Code|n}}, of the following string
* {{Placeholder|n}} bytes containing the version identification string

The version string is for display only. Use the base level or version to identify versions functionally.
|}

== Advance To: ==
* [[Environmental Characteristics (API Guide)]]
[[Category: API Guide]]