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