BTRV Edition User's Guide

c-treeRTG Products
Documentation Overview
c-treeRTG BTRV Edition Quick Start
Now You Can Configure While You Migrate
c-treeRTG BTRV Edition Setup
c-treeRTG BTRV Edition Installation
c-treeRTG Server Setup
Installing & Configuring the FairCom DB Server
c-treeRTG for Windows
c-treeRTG for Unix/Linux
Configure the c-treeRTG Server
c-treeRTG Configuration
c-treeRTG Configuration Tool - RTG Config
Creating a New File (Basic)
Creating a New File (Advanced)
Editing a Configuration File
Encrypting the Configuration File
CTREE_CONF Environment Variable
CTREE_CONF_DUMP environment variable to specify configuration dump file
Relinking Your Application
Data Conversion
RTG Migrate
Using the ctmigra utility
BTRV Conversion Example
Micro Focus COBOL Migration Example
Converting BTRV Data to c-treeRTG with butil/ctutil
c-treeRTG SQL Access
Creating an XDD from a DDF
Create an XDD Manually
Storing the XDD in the Data File and Linking to the SQL Dictionary
Type Mapping Table
Variable-length fields mapped into LONGVAR* SQL field
Troubleshooting Data Conversion Errors
Viewing Sqlized Tables in FairCom DB SQL Explorer
Adding SQL Indexes to Sqlized Files
ACUCOBOL API for SQL Conversion Error Checking
Background Information about Sqlizing Btrieve Data
c-treeRTG Extended Data Definitions - XDD
When a DDF is Available
Merging the XDD with the Data File
Index Compatibility
REDEFINES: Multiple Record Types
SQL Considerations
Common SQL Limitations with c-treeRTG Data
c-treeRTG SQL Support
Utilities: ctutil, cttrnmod, ctmigra, ctfileid
ctutil Notes
ctunload407 to unload data of files affected by error 407
ctutil Commands
cttrnmod - Change Transaction Mode Utility
ctfileid - Update File IDs
Copying Server-Controlled Files
ctclntrn and cthghtrn - Manage Transaction Mark Numbers
ct_tpc and cttpca TPC A Test
Additional c-treeRTG Command-Line Tools
Details about the File System and SQL
c-treeRTG File System Overview
The c-treeRTG SQL Challenge
Configuration File Elements
c-treeRTG Configuration File
Structure Elements
Btrieve Examples
Wildcard File Matching Rules
File Matching Precedence
Settings Elements
<prefetch> - c-treeRTG BTRV Edition
<rowid> - c-treeRTG BTRV Edition
Substitution Specifiers
<table> root element
<key> table element
<part> key element
<segment> key element
<filters> table element
BTRV Note - <filters> table element
<filter> filters element
BTRV Note - <filters> filters element
<field> filters element
<[Operator]> filter elements
<field> operator element
<value> operator element
<schema> table element
<field> schema element
Programing with Btrieve
Sample Program: btrv_tutorial1
c-treeRTG BTRV Edition Login/Logout Operation
BTRV Extended Index Types
Support for Exclusive Transactions in c-treeRTG BTRV Edition
Support for BTRV Create Index Operation
Logging, Error Codes, and Troubleshooting
Configurable Log Output
Driver Error Codes
c-treeRTG Error Codes
c-treeRTG SQL Access Errors
Error 407
Error 408 / 438
Client/Server Incompatibility
File Matching Rules in ctree.conf
Troubleshooting Performance
FairCom Typographical Conventions
Copyright Notice