Was this helpful?
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 Sample Queries for 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 data type of the field. Possible values are listed here 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)
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 pop-up or normal form. Valid (octal) values are:
1 Display form with single‑line border
200 Display form as pop-up
4000 Display form in narrow‑screen mode
10000 Display form in wide‑screen 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.
Last modified date: 11/28/2023