Product Documentation

FairCom RTG V3 Update Guide

Previous Topic

Next Topic

ROWID Record Header Required for Full Text Search

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).

  1. Once you have created a table with ROWID, a Full-Text Index (FTI) can be created on the new table without further intervention.
  2. 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.

<rowid size="8">yes</rowid>

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:

<rowid size="4">no</rowid>

TOCIndex