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 - Best for Microfocus ExtFH C-ISAM File Conversions 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 Advanced FairCom RTG Techniques 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 Appendix A - 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