Forms System Catalogs

The forms system requires the following extended system catalogs:

ii_encoded_forms
ii_fields
ii_forms
ii_trim

ii_encoded_forms Catalog

The ii_encoded_forms catalog contains encoded versions of forms. The encoding allows forms to be retrieved from the database faster.

The ii_encoded_forms catalog is structured as compressed btree unique on the object_id and cfseq columns:

Column Name	Data Type	Description
object_id	integer	Unique identifier (object ID) for identifying this form in the ii_objects catalog. Other information about this form (such as name, owner, and object class) is stored in the ii_objects catalog.
cfseq	smallint	Sequence number of this record for a particular encoded form. Record sequence numbering starts at zero (0).
cfdatsize	integer	Number of bytes of actual data in column cfdata.
cftotdat	integer	Total number of bytes needed to hold an encoded form.
cfdata	varchar(1960)	Data area used for holding an encoded form.

ii_fields Catalog

The ii_fields catalog contains information on the fields in a form. For every form, there is one row in this catalog for each field, table field and table field column. As used below, the word field refers to a simple field, a table field or a column in a table field. An example of a query that selects information about fields on a form is in Querying the Extended System Catalogs for SQL.

The ii_fields catalog is structured as btree unique on the object_id and flsubseq columns:

Column Name	Data Type	Description
object_id	integer	Unique identifier (object ID) for identifying the form this field belongs to in the ii_objects catalog. Other information about the form (such as name, owner, and object class) is stored in the ii_objects catalog.
flseq	smallint	The sequence number of the field in the form (or column in a table field). This determines the tabbing order among fields and among columns in a table field.
fldname	varchar(32)	The name of the field.
fldatatype	smallint	The field's data type. Possible values are listed below with nullable data types being the negative of the listed value: 3 date 5 money 20 char 21 varchar 30 integer 31 floating point 32 c 37 text
fllength	smallint	The internal data length of the field in bytes. This cannot be the same as the user-defined length. This is the length used by Ingres.
flprec	smallint	Reserved for future use.
flwidth	smallint	The number of characters displayed in the field on the form including wrap characters. For example, if the format for the field is c20.10, flwidth is 20. If the field is a table field, this value is the number of columns in the table field.
flmaxlin	smallint	The number of lines occupied by the field (title and data).
flmaxcol	smallint	The number of columns occupied by the field (title and data).
flposy	smallint	The y coordinate of the upper left corner of the field.
flposx	smallint	The x coordinate of the upper left corner of the field.
fldatawidth	smallint	The width of the data entry area for the field. If field format is c20.10, fldatawidth is 10.
fldatalin	smallint	The y coordinate position of the data entry area relative to the upper left corner of the field.
fldatacol	smallint	The x coordinate position of the data entry area relative to the upper left corner of the field.
fltitle	varchar(50)	The field title.
fltitcol	smallint	The x coordinate position of the title relative to the upper left corner of the field.
fltitlin	smallint	The y coordinate position of the title relative to the upper left corner of the field.
flintrp	smallint	Reserved for future use.
fldflags	integer	The field attributes, such as box and reverse video. Valid (octal) values are: 1 boxed field 04 query-only 10 keep previous values 20 mandatory 40 no row lines (table field) 100 force lowercase 200 force uppercase 400 reverse video 1000 blinking 2000 underline 4000 change intensity 10000 no autotab 20000 no echo 40000 no column title (table field only)
fldflags (cont'd.)		200000 foreground color 1 400000 foreground color 2 1000000 foreground color 3 2000000 foreground color 4 4000000 foreground color 5 10000000 foreground color 6 20000000 foreground color 7 100000000 invisible 10000000000 row highlight (table field)
fld2flags	integer	More attributes for the field, including scrolling: 0100 scrollable 01000 display-only 04000 derived field
fldfont	smallint	Reserved for future use.
fldptsz	smallint	Reserved for future use.
fldefault	varchar(50)	The default value for the field.
flformat	varchar(50)	The display format for the field (for example, c10 or f10.2).
flvalmsg	varchar(100)	The message to be displayed if the validation check fails.
flvalchk	varchar(240)	The validation check for the field.
fltype	smallint	Indicates if the record describes a regular field, a table field or a column in a table field. Possible values are: 0 simple field; 1 table field; 2 table field column;
flsubseq	smallint	A unique identifying record number with respect to the set of records that describe all the fields in a form.

ii_forms Catalog

The ii_forms catalog contains one row for each form in a database.

The ii_forms catalog is structured as btree unique, keyed on the object_id column:

Column Name	Data Type	Description
object_id	integer	Unique identifier (object ID) for identifying this form in the ii_objects catalog. Other information about the form (such as name, owner, and object class) is stored in the ii_objects catalog.
frmaxcol	smallint	The number of columns the form occupies.
frmaxlin	smallint	The number of lines the form occupies.
frposx	smallint	The x coordinate for the upper left corner of the form.
frposy	smallint	The y coordinate for the upper left corner of the form.
frfldno	smallint	For forms saved before release 6.3/01, contains the number of updatable regular and table fields in the form. For forms saved with or after release 6.3/01, contains the number of regular and table fields in the form.
frnsno	smallint	For forms saved before release 6.3/01, the number of display-only regular fields in the form.
frtrimno	smallint	The number of trim and box graphic trim strings in the form.
frversion	smallint	Version number of the form.
frscrtype	smallint	Reserved for future use.
frscrmaxx	smallint	Reserved for future use.
frscrmaxy	smallint	Reserved for future use.
frscrdpix	smallint	Reserved for future use.
frscrdpiy	smallint	Reserved for future use.
frflags	integer	The attributes of the form, such as whether this a pop-up or normal form. Valid (octal) values are: 1 Display form with singleline border 200 Display form as pop-up 4000 Display form in narrow screen mode 10000 Display form in widescreen mode
fr2flags	integer	More attributes for the form. Currently unused.
frtotflds	integer	The total number of records in the ii_fields catalog for the form.

ii_trim Catalog

The ii_trims catalog contains the trim strings and box graphic trim for a form. There is one row for each trim string and for each box graphic trim.

The ii_trim catalog is structured as compressed btree unique on the object_id, trim_col and trim_lin columns:

Column Name	Data Type	Description
object_id	integer	Unique identifier (object ID) for identifying the form this trim string belongs to in the ii_objects catalog. Other information about the form (such as name, owner, and object class) is stored in the ii_objects catalog.
trim_col	smallint	The x coordinate for the starting position of the trim string or box graphic trim.
trim_lin	smallint	The y coordinate for the starting position of the trim string or box graphic trim.
trim_trim	varchar (150)	The actual trim string or encoding of box graphic trim size (number of rows and columns).
trim_flags	integer	Attributes of the trim string: 01 box graphic trim 0400 reverse video 01000 blinking 02000 underline 04000 change intensity 0200000 foreground color 1 0400000 foreground color 2 01000000 foreground color 3 02000000 foreground color 4 04000000 foreground color 5 010000000 foreground color 6 020000000 foreground color 7
trim2_flags	integer	More attributes for the trim string. Currently unused.
trim_font	smallint	Reserved for future use.
trim_ptsz	smallint	Reserved for future use.