BTRV Edition User's Guide

<rowid> - FairCom RTG BTRV Edition

The <rowid> option enables support for creating a ROWID field/index. The ROWID is required for creating a Full-Text Index, so this option is necessary if Full-Text Search is desired.

Accepted Values

Value	Effect	Synonyms
yes	Enable support for ROWID field/index. Default for FairCom RTG BTRV Edition.	y, true, on, 1
no	Disable support for ROWID.	n, false, off, 0

Attributes

Attribute	Values	Description	Default
size	8 and 4	Sets the size of the rowid hidden field in the record header (SRLSEG size internally). The default value is 8, accepted values are 8 and 4.	4

Example

Notes

Full text search requires additional information on each record. A unique ROWID value provides this extended information. The new configuration element <rowid> enables this feature for newly created tables. ROWID is internally supported by the FairCom RTG serial segment feature (SRLSEG), an auto incrementing value transparent to the application.

ROWID support is enabled by including <rowid>yes</rowid> in your FairCom RTG local configuration file (ctree.conf).

Once you have created a table with ROWID, a Full-Text Index (FTI) can be created on the new table without further intervention.
Existing tables require a one-time conversion to support FTI. ctutil -upgrade enables this support.

The "size" attribute for the <rowid> tag can be used to set the size of the rowid hidden field in the record header. The default value is 8 for COBOL (4 for BTRV). Accepted values are 8 and 4.

Compatibility: The size setting of <rowid> is taken into consideration even if <rowid> is set to no, affecting other FairCom RTG features. Setting it to 8 (for COBOL, not setting a value has the same effect) makes new files incompatible with previous FairCom RTG versions.

Therefore, to be sure that files created with V3 are compatible with older versions, it is necessary to include the following in ctree.conf: