FairCom RTG BTRV User Guide

FairCom ISAM User Guide Documentation Overview FairCom DB ISAM Quick Start Now You Can Configure While You Migrate 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 Server FairCom RTG/ISAM Configuration 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 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 ISAM Conversion Example Micro Focus COBOL Migration Example Converting ISAM Data to FairCom RTG/ISAM with butil/ctutil FairCom RTG/ISAM 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/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 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/ISAM Command-Line Tools FPUTFGET Library Details about the File System and SQL FairCom RTG/ISAM File Handler Overview The FairCom RTG/ISAM SQL Challenge 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> <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 XDD <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 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 - 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