iiaccess

iialt_columns

iiaudittables

iicolumns

iiconstraint_indexes

iiconstraints

iidb_comments

iidb_subcomments

iidbcapabilities

iidbconstants

iidistcols

iidistschemes

iievents

iifile_info

iihistograms

iiindex_columns

iiindexes

iiingres_tables

iiintegrities

iikeys

iikey_columns

iilog_help

iilpartitions

iimulti_locations

iipermits

iiphysical_tables

iiprocedures

iiproc_access

iiproc_params

iirange

iiref_constraints

iiregistrations

iirules

iisecurity_alrams

iisession_privileges

iisequences

iistats

iisynonyms

iitables

iiviews

table_name

char(32)

Name of the database object.

table_owner

char(32)

Owner of the object.

table_type

char(1)

T—Object is a base table.

V—Object is a view.

I—Object is an index.

system_use

char(1)

S—System catalog object.

U—User object.

permit_user

char(32)

Name of grantee.

permit_type

char(64)

Privilege granted.

table_name

char(32)

The table to which column_name belongs.

table_owner

char(32)

The table owner.

key_id

integer

The number of the alternate key for this table.

column_name

char(32)

The name of the column.

key_sequence

smallint

Sequence of column in the key, numbered from 1.

table_name

char(32)

The name of the virtual security audit table

table_owner

char(32)

The registered name of the table owner, as determined by the register table statement

audit_log

char(256)

The full file name specification of the underlying security audit log

register_date

date

The date and time the audit table was registered

table_name

char(32)

The name of the table. Must be a valid object name.

table_owner

char(32)

The owner of the table. Must be a valid user name.

column_collid

integer

The column's collation ID. Valid values are 1 for unicode, 2 for unicode_case_insensitive, and 3 for sql_character. The background default is 1.

column_name

char(32)

The column's name. Must be a valid object name.

column_datatype

char(32)

The column's data type name returned to users and applications:
INTEGER
SMALLINT
INT
FLOAT
REAL
DECIMAL
DOUBLE PRECISION
CHAR
CHARACTER
VARCHAR
LONG VARCHAR
BYTE
LONG BYTE
C
TEXT
MONEY
INGRESDATE
ANSIDATE
TIME
TIMESTAMP
INTERVAL

column_length

integer

The length of the column returned to users and applications. If a data type contains two length specifiers, this column uses the first length. Set to zero for the data types which are specified without length (money and date). Displays the precision for decimal data. This length is not the actual length of the column's internal storage.

column_scale

integer

The second number in a two-part user length specification; for type name (len1, len2) it is len2.

column_nulls

char(1)

Y if the column can contain null values, N if the column cannot contain null values.

column_defaults

char(1)

Y if the column is given a default value when a row is inserted. N if the column is not given a default value.

column_sequence

integer

The number of this column in the corresponding table's create statement, numbered from 1.

key_sequence

integer

The order of this column in the primary key, numbered from 1. For a table, this indicates the column's order in the primary storage structure key. If 0, this column is not part of the primary key.

sort_direction

char(1)

Defaults to A for ascending when key_sequence is greater than 0. Otherwise, this value is a blank.

column_ingdatatype

integer

Contains the numeric representation of the column's external data type (the data type returned to users and applications). If the installation has user-defined data types (UDTs), this column contains the data type that the UDT is converted to when returned to an Ingres/Tool product. If the value is positive, the column is not nullable; if the value is negative, the column is nullable. The data types and their corresponding values are:
INTEGER 30/-30
FLOAT 31/-31
C 32/-32
TEXT 37/-37
INGRESDATE* 3/-3
DECIMAL 10/-10
MONEY 5-/5
CHAR 20/-20
VARCHAR 21/-21
LONG VARCHAR 22/-22
BYTE 23/-23
LONG BYTE 25/-25
TABLE_KEY 12/-12
OBJECT_KEY 11-/11
ANSIDATE 4/-4
TIME WITHOUT TIMEZONE 6/-6
TIME WITH TIMEZONE 7/-7
TIME 8/-8
TIMESTAMP WITHOUT TIMEZONE 9/-9
TIMESTAMP WITH TIMEZONE 18/-18
TIMESTAMP 19/-19
INTERVAL YEAR TO MONTH 33/-33
INTERVAL DAY TO SECOND 34/-34

* Returned to applications as strings.

column_internal_
datatype

char(32)

The internal data type of the column: char, c, varchar, text, integer, float, date, decimal, money, table_key, object_key. If the installation has user-defined data types, this column contains the user-specified name.

column_internal_
length

integer

The internal length of the column. For example, for data type smallint, this column contains 2. Contains 0 if the data type is fixed-length. The length does not include the null indicator byte for nullable columns, nor the length specifier byte for varchar and text columns.

column_internal_
ingtype

smallint

Contains the numeric representation of the internal data type. See column_ingdatatype for a list of valid values. If the installation has user-defined data types, this column contains the user-specified data type number.

column_system_
maintained

char(1)

Y if the column is system-maintained, N if not system-maintained.

column_updateable

char(1)

Y if the column can be updated, N if not, blank if unknown.

column_has_default

char(1)

Y if the column is defined as with default or default value,
N if the column is defined as not default,
U if the column is defined without a default, (blank) if unknown.

column_default_val

varchar(1501)

The value of the default, if the column has one, which is inserted into the column automatically if no value is specified during an insert. It contains surrounding and embedded quotes for character defaults, per ISO Entry SQL92 semantics.

Null, if the default is not specified, NOT DEFAULT, or Unknown.

security_audit_key

char(1)

Y if the column is a security audit key, N if not.

constraint_name

char(32)

The name of the constraint

schema_name

char(32)

The name of the schema

index_name

char(32)

The name of the index

constraint_name

char(32)

The name of the constraint

schema_name

char(32)

The name of the schema

table_name

char(32)

The name of the table

constraint_type

char(1)

The type of constraint

create_date

char(25)

The date the constraint was created

text_sequence

integer

The text sequence number

text_segment

varchar(240)

The text, or portion, of the constraint definition

system_use

char(1)

Contains U if the object is a user object or G if generated by the system for the user. A status of G is used for constraints or views with check option. Used by utilities to determine which objects need reloading.

object_name

char(32)

The name of the primary object being commented on (table, view or index)

object_owner

char(32)

The name of the object's owner

object_type

char(1)

Always T; the comment is on the table, view or index denoted by object_name.

short_remark

char(60)

The text of the short remark, or blank if none

text_sequence

integer

Always 1; the sequence number of the long_remark.

long_remark

varchar
(1600)

The text of the long remark, or a zero-length string if none

object_name

char(32)

The name of the primary object being commented on (table, view or index)

object_owner

char(32)

The name of the object's owner

subobject_name

char(32)

The name of the secondary object being commented on (table, view or index)

subobject_type

char(1)

Always C; the comment is on a column.

short_remark

char(60)

The text of the short remark, or blank if none

text_sequence

integer

Always 1; the sequence number of the long_remark.

long_remark

varchar(1600)

The text of the long remark, or a zero-length string if none

cap_capability

char(32)

Contains one of the values listed in the Capability column of the table below.

cap_value

char(32)

The contents of this field depend on the capability; see the Value column in the table below.

COMMON/SQL_LEVEL

This is a depreciated column maintained for backward compatibility. Use OPEN/SQL_LEVEL instead.

DB_DELIMITED_CASE

Case mapping semantics of the database with respect to delimited identifiers for database objects:

LOWER for lowercase is the Ingres setting.
MIXED for mixed case is set for an ISO Entry SQL92 compliant installation.

If the value is MIXED, an identifier must be enclosed in double quotes to maintain case as originally defined. Otherwise, it is treated as a regular identifier (converted to uppercase).

DB_NAME_CASE

Case mapping semantics of the database with respect to regular identifiers for database objects:

LOWER for lowercase is the Ingres setting.
UPPER for uppercase is set for an ISO Entry SQL92 compliant installation.

DB_REAL_USER_CASE

Case mapping of user names as retrieved by the operating system.

LOWER for lowercase is the Ingres setting.
MIXED for mixed case or UPPER for uppercase is set as specified during installation.

DBMS_TYPE

The type of DBMS the application is communicating with. Valid values are the same as those accepted by the with DBMS = clause used in queries. Examples: INGRES, STAR, RMS. The default value is INGRES.

DISTRIBUTED

Y if the DBMS is distributed, N if not.

ESCAPE

Contains Y if DBMS supports the ESCAPE clause of the LIKE predicate in the WHERE clause of search statements; contains N if ESCAPE is not supported.

INGRES

Y if the DBMS supports all aspects of Release 6 and Ingres; otherwise N. Default is Y.

INGRES/SQL_LEVEL

Version of SQL supported by the DBMS. Examples:

00600 6.0

00601 6.1

00602 6.2

00603 6.3

00604 6.4

00605 OpenIngres1.x

00800 OpenIngres 2.0 and Ingres II 2.0

00850 Ingres II 2.5

00860 Ingres 2.6

00902 Ingres r3

00904 Ingres 2006

00000 DBMS does not support SQL

INGRES/QUEL_LEVEL

Version of QUEL supported by the DBMS. Examples:

00600 6.0

00601 6.1

00602 6.2

00603 6.3

00604 6.4

00605 OpenIngres1.x

00800 OpenIngres 2.0 and Ingres II 2.0

00850 Ingres II 2.5

00860 Ingres 2.6

00902 Ingres r3

00904 Ingres 2006

00000 DBMS does not support QUEL

INGRES_RULES

Y if the DBMS supports rules; N if it does not.

INGRES_UDT

Y if the DBMS supports user-defined data types; N if the DBMS does not support user-defined data types.

INGRES_AUTH_GROUP

Y if the DBMS supports group identifiers, N if it does not.

INGRES_AUTH_ROLE

Y if the DBMS supports role identifiers, N if it does not

INGRES_LOGICAL_KEY

Y if the DBMS supports logical keys, N if it does not.

MAX_COLUMNS

Maximum number of columns allowed in a table. Current setting is 1024.

MIXEDCASE_NAMES

Y if case is significant in object names. N if ABC, Abc, and abc are all equivalent object names.

NATIONAL_CHARACTER_
SET

Y if the DMBS supports Unicode, N if it does not.

OPEN_SQL_DATES

Contains LEVEL 1 if the Enterprise Access Server supports the OpenSQL date data type. It appears when using Enterprise Access. If absent, OpenSQL date data type is implicitly supported if accessing a standard DBMS server.

OPEN/SQL_LEVEL

Version of OpenSQL supported by the DBMS.

Examples:

00600 6.0

00601 6.1

00602 6.2

00603 6.3

00604 6.4

00605 OpenIngres1.x

00800 OpenIngres 2.0 and Ingres II 2.0

00850 Ingres II 2.5

00860 Ingres 2.6

00902 Ingres r3

00904 Ingres 2006

Current setting is 00904.

Note: Use this name instead of the older and depreciated COMMON/SQL_LEVEL.

OWNER_NAME

Contains N if schema.table table name format is not supported. Contains Y if schema.table format is supported; contains QUOTED if schema.table is supported with optional quotes (schema.table). The default is QUOTED.

PHYSICAL_SOURCE

T indicates that iitables contains physical table information.
P (a depreciated setting) indicates that only iiphysical_tables contains the physical table information.

T is the default and only current usage.

QUEL_LEVEL

Text version of QUEL support level. Currently II9.0.4

SAVEPOINTS

Y if savepoints behave exactly as in Ingres, else N. Default is Y

SLAVE2PC

Indicates if the DBMS supports Ingres 2-phase commit slave protocol:

Y for Release 6.3 and above
N for Star
N usually for Enterprise Access

If not present, Y is assumed.

SQL_LEVEL

Text version of SQL support level. Currently II9.0.4

STANDARD_CATALOG_
LEVEL

Release of the standard catalog interface supported by this database. Valid values:

00602
00604
00605
00800
00850
00860
00902
00904 (the current setting)

This appendix describes the catalogs for release 00904. For catalog formats of other releases, see the appropriate documentation set.

UNIQUE_KEY_REQ

Y if the database service requires that some or all tables have a unique key. N or not present if the database service allows tables without unique keys.

user_name

char(32)

The name of the current user.

dba_name

char(32)

The name of the database's owner.

system_owner

varchar(32)

The name of the catalog owner ($ingres).

table_name

char

The name of the partitioned table.

table_owner

char

The name of the table's owner.

dimension

integer

The dimension being described, counting from 1.

column_name

char

The name of the partitioning column.

column_sequence

integer

The sequence of this column in this dimension's partitioning value, counting from 1.

column_datatype

char

The column's data type:
INTEGER
SMALLINT
INT
FLOAT
REAL
DECIMAL
DOUBLE PRECISION
CHAR
CHARACTER
VARCHAR
LONG VARCHAR
BYTE
LONG BYTE
C
TEXT
DATE
MONEY

table_name

char

The name of the partitioned table.

table_owner

char

The name of the table's owner.

dimension

integer

The dimension being described, counting from 1.

partitioning_columns

integer

The number of columns that make up the partitioning value for a value-based partitioning rule.

logical_partitions

integer

The number of logical partitions in this dimension.

partitioning_rule

varchar

The partitioning rule:
AUTOMATIC
HASH
LIST
RANGE

event_name

char(32)

Name of the event. This name is unique among all events owned by user.

event_owner

char(32)

Owner of the event. This name can be referenced in the different event statements to qualify the event.

text_sequence

integer

Text sequence of create dbevent text.

text_segment

varchar(240)

Text segment of create dbevent text.

table_name

char(32)

Name of the table.

owner_name

char(32)

Owner of the table.

file_name

char(8)

Name of the file that contains the table

file_ext

char(3)

Extension of the file that contains an extent of the table. The first extent bears the extension t00; succeeding extensions are numbered t01, t02, and so on. If a table is comprised of more than one extent, one row is returned for each extent.

location

char(32)

The location of the file.

base_id

integer

First part of the internal relation ID. This value is used to assign the file name, and uniquely identifies a table and its indexes.

index_id

integer

Second part of the internal relation ID; used to distinguish a base table from its indexes, and the indexes from each other.

table_name

char(32)

The table for the histogram. Must be a valid object name.

table_owner

char(32)

The table owner's user name.

column_name

char(32)

The name of the column.

text_sequence

integer

The sequence number for the histogram, numbered from 1. There can be several rows in this table, used to order the text_segment data when histogram is read into memory.

text_segment

char(228)

The encoded histogram data, created by optimizedb.

index_name

char(32)

The index containing column_name. This is an object name.

index_owner

char(32)

The index owner. Must be a valid user name.

column_name

char(32)

The name of the column. Must be a valid object name.

key_sequence

integer

Sequence of column in the key, numbered from 1.

sort_direction

char(1)

Defaults to A for ascending.

index_name

char(32)

The index name. Must be a valid object name.

index_owner

char(32)

The index owner's user name.

create_date

char(25)

Creation date of index.

base_name

char(32)

The base table name. Must be a valid object name.

base_owner

char(32)

The base table owner. Must be a valid user name.

storage_structure

char(16)

The storage structure for the index: heap, hash, isam, or btree.

is_compressed

char(1)

Y if the table is stored in compressed format, N if the table is uncompressed, blank if unknown.

key_is_compressed

char(1)

Contains Y if the table uses key compression, N if no key compression, or blank if unknown.

unique_rule

char(1)

U if the index is unique, D if duplicate key values are allowed, or blank if unknown.

unique_scope

char(1)

R if this object is row-level, S if statement-level, blank if not applicable

system_use

char(1)

Contains S if the object is a system object, U if user object, G if generated by the system for the user, or blank if unknown. Used by utilities to determine which tables need reloading.

persistent

char(1)

Y if the index re-created after a modify of the table,
N if not

index_pagesize

integer

Stores the page size of an index.

table_name

char(32)

Name of the table

table_owner

char(32)

Owner of the table.

expire_date

char(25)

How long to save this table. A value of 1970_01_01 00:00:00 GMT indicates table never expires.

table_integrities

char(1)

Y if integrities exist on this table, N otherwise.

table_permits

char(1)

Y if permits exist on this table, N otherwise.

all_to_all

char(1)

Y if any user can perform any operation on this table, N otherwise.

ret_to_all

char(1)

Y if any user can retrieve data from this table.

row_width

integer

Maximum width of tuple in bytes.

is_journaled

char(1)

N : Is not journaled
Y : Is journaled.
C : Is journaled after next checkpoint.

view_base

char(1)

N if a view never existed on this table, else Y if at least one view existed for this table. This retains a Y value even after all views on this table are dropped.

modify_date

char(25)

Date of last modify performed on the table, or the table creation date if never modified.

table_ifillpct

smallint

Fill factor for B-tree index pages, otherwise unused.

table_dfillpct

smallint

Fill factor for data pages if table does not have HEAP structure.

table_lfillfct

smallint

Fill factor for B-tree leaf pages.

table_minpages

integer

Minimum number of hash buckets to use if modifying to HASH structure.

table_maxpages

integer

Maximum number of hash buckets to use if modifying to HASH structure

location_name

char(32)

Name of first (perhaps only) location for data files.

table_reltid

integer

Unique numeric table identifier.

table_reltidx

integer

Unique numeric index identifier. Is zero if this is a base table.

table_name

char(32)

The table name.

table_owner

char(32)

The table owner's user name.

create_date

char(25)

The integrity's creation date. This is a date field.

integrity_number

smallint

The number of this integrity.

text_sequence

integer

The sequence number for the text, numbered from 1.

text_segment

varchar
(240)

The text of the integrity definition.

constraint_name

char(32)

The name of the constraint.

schema_name

char(32)

The name of the schema.

table_name

char(32)

The name of the table.

column_name

char(32)

The name of the column.

key_position

smallint

A number indicating the key position.

table_name

char(32)

Name of the table key is on.

table_owner

char(32)

Owner of the table.

column_name

char(32)

Name of key component column.

key_sequence

smallint

Position of column in key. 1 being the most significant component.

sort_direction

varchar(1)

A : Ascending sort. (currently only ascending indexes are supported)

table_name

char(32)

Name of the object column is part of.

table_owner

char(32)

Owner of the object.

create_date

char(25)

Date object was created.

table_type

char(8)

T : attribute is part of a table.

V : attribute is part of a view.

I : attribute is part of an index.

table_subtype

char(1)

Currently unused and defaulted to N.

table_version

char(5)

II3.0 for current release of product.

system_use

char(1)

S : Part of a system catalog.

U : part of a user object.

column_name

char(32)

Name of attribute.

column_datatype

char(32)

Long name of datatype for this column.

column_length

integer

Size in bytes of data.

column_nulls

char(1)

N : Not nullable

Y : Column supports nulls.

column_defaults

char(1)

N : No default for this column.

Y : A default value exists for this column.

column_sequence

smallint

Position of this column in table.

key_sequence

smallint

Position in key for this table or zero (0).

table_name

char

The name of the partitioned table.

table_owner

char

The name of the table's owner.

dimension

integer

The dimension being described, counting from 1.

logical_partseq

integer

The logical partition sequence number in its dimension, counting from 1 partition_name.

partition_name

char

The partition's name. If no name is assigned in the partition definition, a name of the form iipartNN is shown, where NN is an arbitrary sequence number.

value_sequence

integer

The partitioning value being described, counting from 1. A logical partition not based on user values (AUTOMATIC, HASH) has one iilpartitions entry with a zero value_sequence.

column_sequence

integer

The column component in the partitioning value, counting from 1. A logical partition not based on user values (AUTOMATIC, HASH) has one iilpartitions entry with a zero column_sequence.

operator

varchar

If the partitioning is based on user values (LIST or RANGE), this is the operator applied to the value: <, <=, =, >=, >, and DEFAULT. The = and DEFAULT operators are for LIST, the others are for RANGE. Logical partition entries for non-user-value partitioning have blanks in the operator column.

value

varchar

If the partitioning is based on user values, this is the column value. The value is meaningless if operator is DEFAULT. The value is NULL if the partitioning is AUTOMATIC or HASH.

table_name

char(32)

The table name.

table_owner

char(32)

The table owner's user name.

loc_sequence

integer

The sequence of this location in the list of locations, as specified in the modify command. This is numbered from 1.

location_name

char(32)

The name of the location.

object_name

char(32)

The table or procedure name. Must be a valid object name.

object_owner

char(32)

The owner of the table or procedure.

permit_grantor

char(32)

The name of the user granting the permit.

object_type

char(1)

The type of the object: T for a table or view; P for a database procedure.

create_date

char(25)

The permit's creation date.

permit_user

char(32)

The user name to which this permit applies.

permit_depth

smallint

Indicates relative ordering distance of the permit holder from the object owner, as established in the grant with grant option statement(s).

permit_number

smallint

The number of this permit.

text_sequence

integer

The sequence number for the text, numbered from 1.

text-segment

varchar(240)

The text of the permission definition.

table_name

char(32)

The table name. This is an object name.

table_owner

char(32)

The table owner's user name

table_stats

char(1)

Y if this object has entries in the iistats table

table_indexes

char(1)

Y if this object has entries in the iiindexes table that see this as a base table

is_readonly

char(1)

Y if updates are physically allowed on this object

concurrent_access

char(1)

Y if concurrent access is allowed

num_rows

integer

The estimated number of rows in the table. Set to -1 if unknown.

storage_structure

char(16)

The storage structure of the table. Possible values are heap, btree, isam, or hash.

is_compressed

char(1)

Indicates if the table is stored in compressed format. Y if it is compressed, N if not compressed, blank if unknown

key_is_compressed

char(1)

Contains Y if the table uses key compression, N if no key compression, or blank if unknown

duplicate_rows

char(1)

U if rows must be unique, D if duplicates are allowed, blank if unknown

unique_rule

char(1)

U if the storage structure is unique, D if duplicates are allowed, blank if unknown or inapplicable

number_pages

integer

The estimated number of physical pages in the table. Set to -1 if unknown.

overflow_pages

integer

The estimated number of overflow pages in the table. Set to -1 if unknown.

row_width

integer

The size (in bytes) of the uncompressed binary value for a row in the object. Set to -1 if this is unknown.

allocation_size

integer

The allocation size, in pages. Set to -1 if unknown.

extend_size

integer

The extend size, in pages. Set to -1 if unknown.

allocated_pages

integer

The total number of pages allocated to the table

row_security_audit

char(1)

Y if per-row security auditing is enabled for this table. If not, N.

table_pagesize

integer

Stores the page size of a table

table_relversion

short int

Table layout version. Starts at zero (0) when table is first created and is incremented whenever column layouts are altered.

table_reltotwid

integer

Width of table record in bytes

procedure_name

char(32)

The database procedure name, as specified in the create procedure statement.

procedure_owner

char(32)

The procedure owner's user name.

create_date

char(25)

The procedure's creation date.

proc_subtype

varchar(1)

Reserved for future use. Currently set to N to indicate native.

text_sequence

integer

The sequence number for the test_segment.

text_segment

varchar(240)

The text of the procedure definition.

system_use

char(1)

Contains U if the object is a user object or G if generated by the system for the user. Used by utilities to determine which objects need reloading.

object_name

char(32)

Name of database procedure.

object_owner

char(32)

Owner of database procedure.

permit_grantor

char(32)

Grantor of privilege to this procedure.

object_type

char(1)

Always P. (Object is of type database procedure).

create_date

char(25)

When procedure was created.

permit_user

char(32)

Name of the grantee.

permit_depth

smallint

Depth of dependencies this procedure permission depends on. Utilities, such as unloaddb, use this number to make sure that statements used to recreate permissions are output in the correct order.

permit_number

smallint

Reserved for future usage.

text_sequence

integer

Sequence number for when definition of procedure spans multiple text segments. Starts with 1.

text_segment

varchar(240)

Procedure definition text.

procedure_name

char(32)

Name of database procedure

procedure_owner

char(32)

Owner of database procedure

param_name

char(32)

Name of parameter

param_sequence

smallint

Which argument to procedure this parameter corresponds to. (1 = first)

param_datatype

char(32)

Datatype of parameter.

param_datatype_code

smallint

Numeric representation of datatype. See column_ing_datatype in iicolumns for these values.

param_length

integer

The length of the column returned to users and applications. If a data type contains two length specifiers, this column uses the first length. Set to zero for the data types that are specified without length (money and date). Displays the precision for decimal data. This length is not the actual length of the column's internal storage.

param_scale

integer

The second number in a two-part user length specification; for type name (len1, len2) it is len2.

param_nulls

char(1)

Y indicates this parameter is NULL.

param_defaults

char(1)

Y indicates that this parameter has a default value.

param_default_val

varchar(1501)

Default value used if default parameter provided.

rng_baseid

integer

Identifier for the base table

rng_indexid

integer

Identifier for the rtree index table

rng_ll1

float

Lower-left coordinate of range box for the first dimension

rng_ll2

float

Lower-left coordinate of range box for the second dimension

rng_ll3

float

Lower-left coordinate of range box for the third dimension. This column is currently not in use.

rng_ll4

float

Lower-left coordinate of range box for the forth dimension. This column is currently not in use.

rng_ur1

float

Upper-right coordinate of range box for the first dimension

rng_ur2

float

Upper-right coordinate of range box for the second dimension

rng_ur3

float

Upper-right coordinate of range box for the third dimension. This column is currently not in use.

rng_ur4

float

Upper-right coordinate of range box for the forth dimension. This column is currently not in use.

rng_dimension

smallint

Dimension of range box. Currently, the value is automatically 2.

rng_hilbertsize

smallint

The size of the hilbert function for the range

rng_datatype

smallint

The data type of the range box, either box or ibox

rng_type

char(1)

The data type of the range box's coordinates:

i = integer
f = float

ref_constraint_name

char(32)

The name of the referential constraint.

ref_schema_name

char(32)

The name of the schema on which the referential constraint applies.

ref_table_name

char(32)

The name of the table on which the referential constraint applies.

unique_constraint_name

char(32)

The name of the unique constraint.

unique_schema_name

char(32)

The name of the schema on which the unique constraint applies.

unique_table_name

char(32)

The name of the schema on which the unique constraint applies.

object_name

char(32)

The name of the registered table, view, or index.

object_owner

char(32)

The name of the owner of the table, view, or index.

object_dml

char(1)

The language used in the registration statement. S for SQL or Q for QUEL.

object_type

char(2)

Describes the object type of object_name. The values are T if the object is a table, V if it is a view, or I if the object is an index.

object_subtype

char(1)

Describes the type of table or view created by the register statement. For Star, this is L for a link. For an Enterprise Access, this is I for an imported object.

text_sequence

integer

The sequence number of the text field, numbered from 1.

text_segment

varchar
(240)

The text of the register statement.

rule_name

char(32)

The name of the rule.

rule_owner

char(32)

The name of the person who defined the rule.

table_name

char(32)

The name of the table that the rule was defined against.

text_sequence

integer

The sequence number for the text segment.

text_segment

varchar(240)

The text of the rule definition.

system_use

char(1)

Contains U if the object is a user object or G if generated by the system for the user. A status of G is used for constraints or views with check option. Used by utilities to determine which objects need reloading.

alarm_name

char(32)

The name of the security alarm.

object_name

char(32)

The name of the table to which the security alarm applies.

object_owner

char(32)

The name of the user who created the security alarm.

object_type

char(1)

The type of object to which the security alarm applies. Currently this field contains T for table.

create_date

char(25)

The date the security alarm was created.

subject_type

char(1)

The values are U if the security_user is a user, G if it is a group, R if it is a role, or P if it is a public identifier.

security_user

char(32)

The user to which the security alarm applies.

security_number

smallint

The security alarm number. This number can be obtained from help security_alarm and is used in the drop security_alarm statement.

dbevent_name

char(32)

Database event associated with the alarm.

dbevent_owner

char(32)

Owner of the database event.

dbevent_text

char(256)

Text of the database event.

text_sequence

integer

The sequence number for the text portion of this row.

text_segment

varchar(240)

The create security_alarm statement (or portion thereof) used to create this security alarm.

priv_name

char(32)

Name of privilege.

priv_access

char(1)

Y if privilege held, N otherwise.

Seq_name

Char(32)

The name of the sequence.

Seq_owner

Char(32)

The sequence owner's user name.

Create_date

Date

The date on which the sequence was defined.

Modify_date

Date

The date on which the sequence was last altered.

Data_type

Varchar(7)

The data type of the sequence (integer or decimal).

Seq_length

Smallint

The size of the sequence value (in bytes)

Seq_precision

Integer

The precision of the sequence value (in decimal digits).

Start_value

Decimal(31)

The start value (or restart value) of the sequence.

Increment_value

Decimal(31)

The increment value of the sequence.

Next_value

Decimal(31)

The next sequence value to be assigned.

Min_value

Decimal(31)

The minimum value of the sequence.

Max_value

Decimal(31)

The maximum value of the sequence.

Cache_size

Integer

The number of cached sequence values.

Start_flag

Char(1)

Y if start value was defined, otherwise N.

Incr_flag

Char(1)

Y if increment value was defined, otherwise N.

Min_flag

Char(1)

Y if minimum value was defined, otherwise N.

Max_flag

Char(1)

Y if maximum value was defined, otherwise N.

Restart_flag

Char(1)

Y if restart value was defined, otherwise N.

Cache_flag

Char(1)

Y if cache value was defined, otherwise N.

Cycle_flag

Char(1)

Y if cycle was defined, otherwise N.

Order_flag

Char(1)

Y if order was defined, otherwise N.

table_name

char(32)

The name of the table.

table_owner

char(32)

The table owner's user name.

column_name

char(32)

The column name to which the statistics apply.

create_date

char(25)

The date on which statistics were gathered.

num_unique

float

The number of unique values in the column.

rept_factor

float

The repetition factor.

has_unique

char(1)

Y if the column has unique values, N otherwise.

pct_nulls

float

The percentage (fraction of 1.0) of the table that contains NULL for the column.

num_cells

integer

The number of cells in the histogram.

column_domain

integer

A user-specified number signifying the domain from which the column draws its values; default is 0.

is_complete

char(1)

Y if the column contains all possible values in the domain, N otherwise.

stat_version

char(8)

The version of the statistics for this column, for example, II3.0.

hist_data_length

integer

The length of the histogram boundary values, either the specified length or optimizedb's computed length.

synonym_name

char(32)

The name of the synonym.

synonym_owner

char(32)

The owner of the synonym.

table_name

char(32)

The name of the table, view or index for which the synonym was created.

table_owner

char(32)

The owner of the table_name.

table_name

char(32)

The object's name. Must be a valid object name.

table_owner

char(32)

The owner's user name. The creator of the object is the owner.

create_date

char(25)

The object's creation date. Blank if unknown.

alter_date

char(25)

The last time this table was altered. This date is updated whenever the logical structure of the table changes, either through changes to the columns in the table or changes to the primary key. Physical changes to the table, such as changes to data, secondary indexes, or physical keys, do not change this date. Blank if unknown.

table_type

char(1)

Type of the query object:

T—Table

V—View

I—Index

P—Physical partition (of a partitioned table)

Further information about views can be found in iiviews.

table_subtype

char(1)

Specifies the type of table or view. Possible values are:

N—(Native) for standard Ingres databases

L—(Links) for Star

I—(Imported tables) for Enterprise Access

(Blank) if unknown

table_version

char(5)

Version of the object; enables the Ingres tools to determine where additional information about this particular object is stored. This reflects the database type, as well as the version of an object in a given database. For Ingres tables, the value for this field is II3.0.

system_use

char(1)

Contains S if the object is a system object, U if user object, G if generated by the system for the user, or blank if unknown. Used by utilities to determine which tables need reloading. If the value is unknown, the utilities use the naming convention of ii for tables to distinguish between system and user catalogs. Also, any table beginning with ii_ is assumed to be a user interface object, rather than a DBMS system object. The standard system catalogs themselves must be included in the iitables catalog and are considered system tables.

tups_per_page

integer

Maximum tuples per data page.

keys_per_page

integer

Maximum keys per index page for ISAM and B-tree tables.

keys_per_leaf

integer

Maximum keys per leaf for B-tree tables.

table_stats

char(1)

Y if this object has entries in the iistats table, N if this object does not have entries. If this field is blank, you must query iistats to determine if statistics exist. This column is used for optimization of databases.

table_indexes

char(1)

Y if this object has entries in the iiindexes table that see this as a base table, or N if this object does not have entries. If the field is blank, you must query iiindexes on the base_table column. This field is used for optimization of databases.

is_readonly

char(1)

N if updates are physically allowed, Y if no updates are allowed, or blank if unknown. Used for tables that are defined to the Enterprise Access only for retrieval, such as tables in hierarchical database systems. If this field is set to Y, no updates work, independent of the permissions that are set. If it is set to N, updates are allowed, depending on whether the permissions allow it or not.

concurrent_access

char(1)

Y if concurrent access is allowed.

num_rows

integer

The estimated number of rows in the table. Set to -1 if unknown. If the iitables row is for a partitioned table, this value reflects the total (rows or pages) in all partitions of the table.

storage_structure

char(16)

The storage structure for the table: heap, hash, btree, or isam.

is_compressed

char(1)

Y if the table is stored in compressed format, N if the table is uncompressed, blank if unknown.

key_is_compressed

char(1)

Contains Y if the table uses key compression, N if no key compression, or blank if unknown.

duplicate_rows

char(1)

D if the table allows duplicate rows, U if the table does not allow duplicate rows, blank if unknown. The table storage structure (unique vs. non-unique keys) can override this setting.

unique_rule

char(1)

D indicates that duplicate physical storage structure keys are allowed. (A unique alternate key exists in iialt_columns and any storage structure keys are listed in iicolumns.)

U if the object is an Ingres object, indicates that the object has unique storage structure keys; if the object is not an Ingres object, it indicates that the object has a unique key, described in either iicolumns or iialt_columns.

Blank indicates that uniqueness is unknown or does not apply.

number_pages

integer

The estimated number of used pages in the table. Set to -1 if unknown. If the iitables row is for a partitioned table, this value reflects the total (rows or pages) in all partitions of the table.

overflow_pages

integer

The estimated number of overflow pages in the table. Set to -1 if unknown.

partition_dimensions

integer

For a partitioned table, this is the number of dimensions (partitioning levels) in the table's partitioning scheme. In all other cases, this is zero.

phys_partitions

integer

For a partitioned table, this is the number of physical partitions. For a physical partition, this is the partition number (counting from zero). In all other cases, this is zero.

row_width

integer

The size, in bytes, of the uncompressed binary value for a row of this query object.

expire_date

integer

Expiration date of table. This is a _bintime date.

modify_date

char(25)

The date when the last physical modification to the storage structure of the table occurred. Blank if unknown or inapplicable.

location_name

char(32)

The first location of the table. If there are additional locations for a table, they are shown in the iimulti_locations table and multi_locations are set to Y.

table_integrities

char(1)

Y if this object has Ingres style integrities. If the value is blank, you must query the iiintegrities table to determine if integrities exist.

table_permits

char(1)

Y if this object has Ingres style permissions.

all_to_all

char(1)

Y if this object has Ingres permit all to all, N if not.

ret_to_all

char(1)

Y if this object has Ingres permit retrieve to all, N if not.

is_journalled

char(1)

Y if journaling is enabled on this object, N if not. C means that journaling on the table is enabled/disabled on the next online checkpoint, depending on the flag specified on the checkpoint.

view_base

char(1)

Y if object is a base for a view definition, N if not, or blank if unknown.

multi_locations

char(1)

Y if the table is in multiple locations, N if not.

table_ifillpct

smallint

Fill factor for the index pages used on the last modify command in the nonleaffill clause, expressed as a percentage (0 to 100). Used for B-tree structures to rerun the last modify command.

table_dfillpct

smallint

Fill factor for the data pages used on the last modify command in the fillfactor clause, expressed as a percentage (0 to 100). Used for B-tree, hash, and ISAM structures to rerun the last modify command.

table_lfillpct

smallint

Fill factor for the leaf pages used on the last modify command in the leaffill clause, expressed as a percentage (0 to 100). Used for B-tree structures to rerun the last modify command.

table_minpages

integer

Minpages parameter from the last execution of the modify command. Used for hash structures only.

table_maxpages

integer

Maxpages parameter from the last execution of the modify command. Used for hash structures only.

table_relstamp1

integer

High part of last create or modify timestamp for the table.

table_relstamp2

integer

Low part of last create or modify timestamp for the table.

table_reltid

integer

The first part of the internal relation ID.

table_reltidx

integer

The second part of the internal relation ID.

* unique_scope

char(1)

R if this object is row-level, S if statement-level, blank if not applicable

* allocation_size

integer

The allocation size, in pages. Set to -1 if unknown.

* extend_size

integer

The extend size, in pages. Set to -1 if unknown.

* allocated_pages

integer

The total number of pages allocated to the table.

row_security_audit

char(1)

Y if row-level security auditing is enabled, N if not.

table_pagesize

integer

Stores the page size of a table.

table_relversion

smallint

Stores version of table.

table_reltotwidth

integer

This width includes all deleted columns.

table_reltcpri

smallint

Indicates a table's priority in the buffer cache. Values can be between 0 - 8. Zero is the default, and 1 - 8 can be specified using the priority clause in create table or modify table.

table_name

char(32)

The view name. Must be a valid object name.

table_owner

char(32)

The view owner's user name.

view_dml

char(1)

The language in which the view was created: S (for SQL) or Q (for QUEL).

check_option

char(1)

Y if the check option was specified in the create view statement, N if not, blank if unknown.

text_sequence

integer

The sequence number for the text field, starting with 1.

text_segment

varchar(240)

The text of the view definition.

audittime

date

The time when the security event occurred.

user_name

char(32)

The effective name of the user that triggered the security event.

real_name

char(32)

The real name of the user.

userprivileges

char(32)

The privileges associated with the user session, with letters denoting the possession of a subject privilege.

objprivileges

char(32)

The privileges granted to the user (for example, when one user is granting privileges to another), with letters denoting the possession of a subject privilege.

database

char(32)

The name of the database in which the event was triggered.

auditstatus

char(1)

Y indicates the attempted operation was successful, N indicates it was not.

auditevent

char(24)

The type of event, which are any of the following: select, insert, delete, update, copy into, copy from, execute, modify, create, destroy or security.

objecttype

char(24)

The type of object being accessed: database, application (role), procedure, table, location, view, security, user, (security) alarm, rule, dbevent.

objectname

char(32)

The name of the object being accessed.

objectowner

char(32)

The owner of the object being accessed.

description

char(80)

The text description of the event.

sessionid

char(16)

The session associated with the event.

detailinfo

char(256)

Detailed information about the event .

detailnum

integer

The sequence number for multiple detail items needed to describe the event.

querytext_sequence

integer

Identifier for associated prepared query.

database_name

char(32)

Name of the database.

database_owner

char(32)

Owner of the database.

data_location

char(32)

Default data location for this database.

work_location

char(32)

Default work location for this database.

ckp_location

char(32)

Checkpoint location for this database.

jnl_location

char(32)

Journal location for this database.

dump_location

char(32)

Dump file location for this database.

compat_level

char(4)

The compatibility level of the Ingres database. Reflects release at the time of last upgrade or when database was created. Currently II/3.0.

compat_level_minor

integer

Minor compatibility level. Currently unused, and defaulted to 0.

database_service

integer

Bitmask of database attributes:

0x00000001 : Database is distributed.

0x00000002 : Is a coordinator database for distributed databases.

0x00010000 : Non-delimiter identifiers are translated to upper case.

0x00040000 : Delimited identifiers are translated to upper case.

0x00080000 : Delimited identifiers are kept in mixed case.

0x00100000 : The login as returned by the OS is not translated. If bit is unset the login name is translated as per the same rules as are non-delimited identifiers.

0x40000000 : Database has been forced consistent.

access

integer

Bitmask of database access attributes:

0x00000001 : Database is globally accessible. If this is cleared database is a private database.

0x00000004 : Transient setting marking that database is in the process of being destroyed.

0x00000008 : Transient setting marking that database is in the process of being created.

0x00000010 : Database is operational. (available for standard DBMS operations).

0x00000020 : Converting. Database was created using a previous release of Ingres, and has not yet been successfully upgraded.

0x00000040 : Database is in the process of being upgraded.

database_id

integer

Unique numeric identifier for this database in the installation.

database_name

char(32)

The name of the database on which the privilege is defined.

grantee_name

char(32)

The name of the grantee for whom the privilege is granted. This can be a user ID, a group identifier, a role identifier, or public.

gr_type

char(1)

Indicates the authorization type of the grantee. Valid entries are U for an individual user ID, G for a group identifier, R for a role identifier, and P for public.

cr_tab

char(1)

Indicates if the grantee has the create table privilege. Values can be U for undefined, Y for yes, and N for no.

cr_proc

char(1)

Indicates if the grantee has the create procedure privilege. Values can be U for undefined, Y for yes, and N for no.

lk_mode

char(1)

Indicates if the grantee has the set lockmode privilege. Values can be U for undefined, Y for yes, and N for no.

db_access

char(1)

Y if grantee has access (connect) privileges to databases.

up_syscat

char(1)

Y if grantee has update_syscat privileges and can update catalog tables.

db_admin

char(1)

Indicates if the grantee has the db_admin privilege. Values can be U for undefined, Y for yes, and N for no.

global_usage

char(1)

Reserved for future use.

qry_io_lim

integer

Indicates the limits on I/O queries defined for the grantee if qry_io is Y.

qry_io

char(1)

Indicates whether the query_io_limit privilege has been defined for the database and authorization type specified in database_name and grantee_name, respectively. Valid values are Y indicating a limit exists, N indicating no limit, and U indicating the privilege is undefined.

qry_row_lim

integer

Indicates the query_row_limit defined for the grantee if qry_row is Y.

qry_row

char(1)

Indicates whether the query_row_limit privilege has been defined for the database and authorization type specified in database_name and grantee_name, respectively. Valid values are Y indicating a limit exists, N indicating no limit, and U indicating the privilege is undefined.

sel_syscats

char(1)

Y if grantee has select_syscat privileges.

tbl_stats

char(1)

Y if grantee has table_statistics privileges.

idle_time

char(1)

Y if grantee has an idle time limit.

idle_time_lim

integer

The idle time limit in seconds.

conn_time

char(1)

Y if grantee has a connect time limit.

conn_time_lim

integer

The connect time limit in seconds.

sess_prio

char(1)

Y if grantee has the session priority privilege and can alter session priorities.

sess_pri_lim

integer

The highest priority to which a session owned by this grantee can be set.

location_name

char(32)

Location name for this extent.

database_name

char(32)

Name of database extended to location_name.

status

integer

Status of this extent as a bitmask of the following values:

0x00000001 : Database has been successfully extended to this location

0x00000002 : Location is used for data storage.

0x00000004 : Location is used as a work location.

location_name

char(32)

The name of the location.

data_usage

char(1)

Y if the location has data file usage, N if not.

jrnl_usage

char(1)

Y if the location has journal file usage, N if not.

ckpt_usage

char(1)

Y if the location has checkpoint file usage, N if not.

work_usage

char(1)

Y if the location has work file usage, N if not.

dump_usage

char(1)

Y if the location has dump file usage, N if not.

awork_usage

char(1)

Y if the location has auxiliary work file usage, N if not.

location_area

char(128)

The name of the area's location.

raw_pct

integer

Percentage of the raw disk area allocated to this location.

status

integer

These numbers are the sum of one or more of these values, which tell what this location is used for:

DATABASE 8 Database data

WORK 16 Temporary sorting

JOURNAL 64 Journals

CHECKPOINT 512 Checkpoints

profile_name

char(32)

Name of this profile.

createdb

char(1)

Y if profile gives by default the right to create databases.

R if this subject privilege is enabled by this profile, but is not part of the default privileges for this profile.

N profile gives no right to create databases.

trace

char(1)

As per createdb, but for enabling usage of tracing and debugging features.

audit_all

char(1)

Y if security audit of all user activity is enabled by this profile. N otherwise.

security

char(1)

As per createdb, but for usage of security-related functions such as the creation or deletion of users.

maintain_locations

char(1)

As per createdb, but for enabling the user to create and change the characteristics of database and file locations.

operator

char(1)

As per createdb, but for enabling the user to perform database maintenance operations.

maintain_users

char(1)

As per createdb, but for enabling the right to create, alter or drop users, profiles, groups, and roles, and to grant or revoke database and installation resource controls.

maintain_audit

char(1)

As per createdb, but for enabling the right to enable, disable, or alter security audit, and to change security audit privileges.

auditor

char(1)

As per createdb, but for registering, removing and querying audit logs.

audit_query_text

char(1)

Y if security audit of query text is enabled by this profile, N otherwise.

expire_date

date

Date when profile expires. Blank if not expiration date was specified.

default_group

char(32)

If specified, group to use if no explicit group was specified when accessing the database (E.g. -G option with tm), and user using this profile does not have an explicit default group, or nogroup specified.

status

integer

Shorthand numeric representation of privileges associated with this profile.

Number is a bitmask as follows:

0x00000001 : createdb

0x00000004 : trace

0x00000200 : operator

0x00000400 : audit_all

0x00000800 : maintain_locations

0x00002000 : auditor

0x00004000 : maintain_audit

0x00008000 : security

0x00010000 : maintain_users

0x01000000 : audit_security_text

roll_name

char(32)

Name of granted role.

grant_type

char(1)

U if a user.

P if to public.

grantee_name

char(32)

Name of grantee.

admin_option

char(1)

Y if grantee can GRANT others this role.

role_name

char(32)

Name of this role.

createdb

char(1)

Y if role provides right to create databases , N otherwise.

trace

char(1)

Y if role enables usage of tracing and debugging features, N otherwise.

audit_all

char(1)

Y if security audit of all user activity is enabled by this role, N otherwise.

security

char(1)

Y if role allows usage of security-related functions such as the creation or deletion of users, N otherwise.

maintain_locations

char(1)

Y if role allows the user to create and change the characteristics of database and file locations, N otherwise.

operator

char(1)

Y if role allows the user to perform database maintenance operations, N otherwise.

maintain_users

char(1)

Y if role enables the right to create, alter or drop users, profiles, groups, and roles, and to grant or revoke database and installation resource controls, N otherwise.

maintain_audit

char(1)

Y if role allows user to enable, disable, or alter security audit, and to change security audit privileges, N otherwise.

auditor

char(1)

Y if role enables the registering, removing, and querying of audit logs, N otherwise.

audit_query_text

char(1)

Y if security audit of query text is enabled by this profile, N otherwise.

internal_status

integer

Shorthand numeric representation of privileges associated with this status.

Number is a bitmask as follows:

0x00000001 : createdb

0x00000004 : trace

0x00000200 : operator

0x00000400 : audit_all

0x00000800 : maintain_locations

0x00002000 : auditor

0x00004000 : maintain_audit

0x00008000 : security

0x00010000 : maintain_users

0x01000000 : audit_security_text

internal_flags

integer

Reserved for future use.

type

char(16)

The type of security audit activity:
event - security-relevant events.

name

char(32)

The name of the security audit class (such as database or security), as specified by the audit_type in the enable security_audit statement.

state

char(1)

E if this security audit class is enabled, D if disabled.

number

integer

A unique identifier for this activitytype/audit class.

user_name

char(32)

The user's name, from iiuser.name

createdb

char(1)

Y if the user has the right, by default, to create databases.

R if the user has the right to create databases, but not by default.

N if the user does not have the right to create a database.

trace

char(1)

As per createdb, but for enabling usage of tracing and debugging features.

audit_all

char(1)

Y if the user has the right to security-audit all user activity, N if not

security

char(1)

As per createdb, but for usage of security-related functions such as the creation or deletion of users.

maintain_locations

char(1)

As per createdb, but for enabling the user to create and change the characteristics of database and file locations.

operator

char(1)

As per createdb, but for enabling the user to perform database maintenance operations.

maintain_users

char(1)

As per createdb, but for enabling the right to create, alter or drop users, profiles, groups, and roles, and to grant or revoke database and installation resource controls.

maintain_audit

char(1)

As per createdb, but for enabling the right to enable, disable, or alter security audit, and to change security audit privileges.

auditor

char(1)

As per createdb, but for registering, removing and querying audit logs.

audit_query_text

char(1)

Y if the user can see query text, N if not. This is enabled if security_audit=(query_text) was specified when creating or altering the user.

expire_date

date

Optional expiration date. After this date, user cannot log on.

profile_name

char(32)

The profile associated with this user, if any.

default-group

char(32)

The user's default group.

internal_status

integer

Shorthand numeric representation of privileges associated with this status.

Number is a bitmask as follows:

0x00000001 : createdb

0x00000004 : trace

0x00000200 : operator

0x00000400 : audit_all

0x00000800 : maintain_locations

0x00002000 : auditor

0x00004000 : maintain_audit

0x00008000 : security

0x00010000 : maintain_users

0x01000000 : audit_security_text

internal_def_priv

integer

Shorthand numberic representation of default privileges using the same weighting scheme as above.

internal_flags

integer

Shorthand numberic representation of Ingres system privileges held by the user.