FairCom RTG BTRV User Guide

FairCom RTG BTRV User Guide Documentation Overview FairCom RTG BTRV Quick Start Now You Can Configure While You Migrate FairCom RTG BTRV Setup FairCom RTG BTRV 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 Convert Microfocus ExtFH C-ISAM Tables with ctmigra ctmigra - Conversion 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 -applyrules -check -clrowner -compact -compress -conv -copy -cryptconf -ddf2xdd -info -load -make -makeidx -maxsize -partition -rebuild -o word -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> <fileversion> <hugefile> <indexfilesuffix> <keycompress> <leading> <padding> <log> <debug> <error> <info> <whoformat> <profile> <warning> <locktimeout> <map> <name> <dir> <maxsize> <memoryfile> <normalize> <optimisticadd> <prefetch> <recordcheck> <rowid> <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 Login/Logout Operation BTRV Extended Index Types Support for Exclusive Transactions in FairCom RTG BTRV 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 Appendix B - Btrieve Compatability Btrieve API functions BTRV File Types Index-Based (Logical) Data Retrieval Operations Data Manipulation Operations Concurrency Control Biases (Add to Op Code) Non-Index-Based (Physical) Data Retrieval Operations File Specific Operations Session Specific Operations File Flags Indices over Data Types FairCom Typographical Conventions Copyright Notice Index