Product Documentation

FairCom RTG COBOL Edition User's Guide

Previous Topic

Next Topic

<rowid>

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

Accepted Values

Value

Effect

Synonyms

yes

Enable support for ROWID field/index.

y, true, on, 1

no

Disable support for ROWID. Default for FairCom RTG COBOL Edition.

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.

8

Example

<rowid>yes</rowid>

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

  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