Product Documentation

c-treeRTG 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 c-treeRTG 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 c-treeRTG serial segment feature (SRLSEG), an auto incrementing value transparent to the application.

ROWID support is enabled by including <rowid>yes</rowid> in your c-treeRTG 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 c-treeRTG features. Setting it to 8 (for COBOL, not setting a value has the same effect) makes new files incompatible with previous c-treeRTG 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