|
|
|
c-treeRTG V2 introduced support for adding SQL indexes over existing COBOL tables, as discussed here: SQL Indexes on COBOL Files
For existing tables created prior to c-treeRTG V2 (for tables created with FairCom DB versions prior to V11), an internal RTGI resource must be added to the table. This RTGI resource is automatically added with c-treeRTG V2 and newer (with FairCom DB V11 and newer).
The ctutil utility can be renamed to ctaddrtgi and used to add new c-treeRTG indexes. When renamed, it functions as an ad-hoc utility that can be run over old data files to give them the necessary information to add indexes through c-treeRTG.
The utility requires one parameter, which is the file name (without the file extension).
Note: It is safe to run this utility on a file that already has an RTGI resource (e.g., it is safe to run this utility on a file that does not need it). In this case the utility will simply return success and do nothing.
Once the ctaddrtgi utility has been executed over a data file, the process discussed here can be followed to add new SQL indexes: SQL Indexes on COBOL Files
Usage:
ctaddrtgi filename
where:
