FairCom RTG BTRV User Guide

FairCom ISAM User Guide Documentation Overview FairCom DB ISAM Quick Start Migration and Configuration in One Pass FairCom DB ISAM Setup FairCom DB ISAM Installation FairCom RTG/ISAM Server Setup Installing & Configuring the FairCom DB Server FairCom RTG/ISAM for Windows FairCom RTG/ISAM for Unix/Linux Configure the FairCom RTG/ISAM Server FairCom ISAM Driver Installation FairCom RTG/ISAM File Handler Overview FairCom RTG/ISAM Configuration FairCom RTG Configuration and Management CTREE_CONF Environment Variable FairCom RTG/ISAM Configuration Tool - RTG Config Creating a New File (Basic) Creating a New File (Advanced) Editing a Configuration File Encrypting the Configuration File Checking the Configuration Using CTREE_LOG and ctutil CTREE_LOG CTREE_CONF_DUMP environment variable to specify configuration dump file Configuration File Elements FairCom RTG/ISAM 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> <forcedelete> <hugefile> <indexfilesuffix> <keycompress> <leading> <padding> <log> <debug> <error> <info> <whoformat> <profile> <warning> <locktimeout> <map> <name> <dir> <maxsize> <memoryfile> <normalize> <sep> <drive> <relative> <trim> <optimisticadd> <prefetch> <recordcheck> <rowid> <smartcopy> <temporary> <transaction> <writethru> Substitution Specifiers Data Conversion RTG Migrate Convert Microfocus ExtFH C-ISAM Tables with ctmigra ctmigra - Conversion Utility ISAM Conversion Example Micro Focus COBOL Migration Example Converting ISAM Data to FairCom RTG/ISAM with butil/ctutil FairCom RTG/ISAM SQL Access The FairCom RTG/ISAM SQL Challenge 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 Preserve Imported Data Files upon SQL DROP Background Information about Sqlizing Btrieve Data FairCom RTG/ISAM 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/ISAM Data FairCom RTG/ISAM SQL Support Modern RTG Data Management File Maintenance Concerns with RTG FairCom RTG backup management FairCom RTG Hot Alter Table Hot Alter Table step-by-step examples Partitioned Files with FairCom RTG UTF-8 Data Stored in FairCom RTG Replication, Clusters, High Availability, and Disaster Recovery FairCom RTG Failover Configuration Changes to Your COBOL Program Replicating RTG File Operations 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 ctmigra - Conversion Utility Standalone Support for ctmigra ctstat - Statistics Utility cttrnmod - Change Transaction Mode Utility 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/ISAM Command-Line Tools FPUTFGET Library startserver and stopserver Scripts Additional FairCom RTG/ISAM Command-Line Tools Advanced FairCom RTG Techniques Sample Program: ISAM_tutorial1 FairCom DB ISAM Login/Logout Operation ISAM Extended Index Types Support for Exclusive Transactions in FairCom DB ISAM Support for ISAM Create Index Operation Appendix A - Logging, Error Codes, and Troubleshooting Configurable Log Output Driver Error Codes FairCom RTG/ISAM Error Codes FairCom RTG/ISAM SQL Access Errors Troubleshooting Error 407 Error 408 / 438 Client/Server Incompatibility File Matching Rules in ctree.conf Troubleshooting Performance Appendix B - XDD Schema Structure <table> root element <key> table element <part> key element <segment> key element <filters> table element ISAM Note - <filters> table element <filter> filters element ISAM Note - <filters> filters element <field> filters element <[Operator]> filter elements <field> operator element <value> operator element <schema> table element <field> schema element Appendix C - Btrieve Compatability Btrieve API functions ISAM 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