BTRV Edition User's Guide

 
FairCom RTG Products
Documentation Overview
FairCom RTG BTRV Edition Quick Start
Now You Can Configure While You Migrate
FairCom RTG BTRV Edition Setup
FairCom RTG BTRV Edition Installation
FairCom RTG Server Setup
Installing & Configuring the FairCom DB Server
FairCom RTG for Windows
FairCom RTG for Unix/Linux
Configure the FairCom RTG Server
FairCom RTG Configuration
FairCom RTG 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
ctmigra
Using the ctmigra utility
BTRV Conversion Example
Micro Focus COBOL Migration Example
Converting BTRV Data to FairCom RTG with butil/ctutil
FairCom RTG 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
ct_XDDOpen
ct_XDDCheck
ct_XDDClose
XDDCHECK Errors
Background Information about Sqlizing Btrieve Data
FairCom RTG 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 FairCom RTG Data
FairCom RTG SQL Support
Utilities: ctutil, cttrnmod, ctmigra, ctfileid
ctutil
ctutil Notes
ctunload407 to unload data of files affected by error 407
ctutil Commands
-alter
-augment
-check
-clrowner
-compact
-compress
-copy
-cryptconf
-ddf2xdd
-info
-load
-make
-makeidx
-partition
-rebuild
-remove
-rename
-run
-segment
-setowner
-setpath
-sqlcheck
-sqlinfo
-sqllink
-sqlunlink
-sqlize
-test
-tron
-uncompress
-unload
-upgrade
ctcbtran
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 FairCom RTG Command-Line Tools
FPUTFGET Library
Details about the File System and SQL
FairCom RTG File Handler Overview
The FairCom RTG SQL Challenge
Configuration File Elements
FairCom RTG Configuration File
Structure Elements
<config>
<instance>
<redirinstance>
Btrieve Examples
<file>
Wildcard File Matching Rules
File Matching Precedence
Settings Elements
<automkdir>
<ctfixed>
<datacompress>
<datafilesuffix>
<encrypt>
<hugefile>
<indexfilesuffix>
<keycompress>
<leading>
<padding>
<log>
<debug>
<error>
<info>
<profile>
<warning>
<locktimeout>
<map>
<name>
<dir>
<memoryfile>
<normalize>
<optimisticadd>
<prefetch> - FairCom RTG BTRV Edition
<recordcheck>
<rowid> - FairCom RTG BTRV Edition
<smartcopy>
<temporary>
<transaction>
<writethru>
Substitution Specifiers
XDD
<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
Programming with Btrieve
Sample Program: btrv_tutorial1
FairCom RTG BTRV Edition Login/Logout Operation
BTRV Extended Index Types
Support for Exclusive Transactions in FairCom RTG BTRV Edition
Support for BTRV Create Index Operation
Logging, Error Codes, and Troubleshooting
Configurable Log Output
Driver Error Codes
FairCom RTG Error Codes
FairCom RTG SQL Access Errors
Troubleshooting
Error 407
Error 408 / 438
Client/Server Incompatibility
File Matching Rules in ctree.conf
Troubleshooting Performance
FairCom Typographical Conventions
Copyright Notice
Index