FairCom RTG BTRV User Guide
Documentation OverviewFairCom RTG BTRV Quick StartNow You Can Configure While You MigrateFairCom RTG BTRV SetupFairCom RTG BTRV InstallationFairCom RTG Server SetupInstalling & Configuring the FairCom DB ServerFairCom RTG for WindowsFairCom RTG for Unix/LinuxConfigure the FairCom RTG ServerFairCom RTG ConfigurationFairCom RTG Configuration Tool - RTG ConfigCreating a New File (Basic)Creating a New File (Advanced)Editing a Configuration FileEncrypting the Configuration FileCTREE_CONF Environment VariableCTREE_CONF_DUMP environment variable to specify configuration dump fileRelinking Your ApplicationData ConversionRTG Migratectmigra - Best for Microfocus ExtFH C-ISAM File ConversionsUsing the ctmigra utilityBTRV Conversion ExampleMicro Focus COBOL Migration ExampleConverting BTRV Data to FairCom RTG with butil/ctutilFairCom RTG SQL AccessCreating an XDD from a DDFCreate an XDD ManuallyStoring the XDD in the Data File and Linking to the SQL DictionaryType Mapping TableVariable-length fields mapped into LONGVAR* SQL fieldTroubleshooting Data Conversion ErrorsViewing Sqlized Tables in FairCom DB SQL ExplorerAdding SQL Indexes to Sqlized FilesACUCOBOL API for SQL Conversion Error Checkingct_XDDOpenct_XDDCheckct_XDDCloseXDDCHECK ErrorsBackground Information about Sqlizing Btrieve DataFairCom RTG Extended Data Definitions - XDDWhen a DDF is AvailableMerging the XDD with the Data FileIndex CompatibilityREDEFINES: Multiple Record TypesSQL ConsiderationsCommon SQL Limitations with FairCom RTG DataFairCom RTG SQL SupportUtilities: ctutil, cttrnmod, ctmigra, ctfileidctutilctutil Notesctunload407 to unload data of files affected by error 407ctutil 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-upgradectcbtrancttrnmod - Change Transaction Mode Utilityctfileid - Update File IDsCopying Server-Controlled Filesctclntrn and cthghtrn - Manage Transaction Mark Numbersct_tpc and cttpca TPC A TestAdditional FairCom RTG Command-Line ToolsFPUTFGET LibraryDetails about the File System and SQLFairCom RTG File Handler OverviewThe FairCom RTG SQL ChallengeConfiguration File ElementsFairCom RTG Configuration FileStructure Elements<config><instance><redirinstance>Btrieve Examples<file>Wildcard File Matching RulesFile Matching PrecedenceSettings Elements<automkdir><ctfixed><datacompress><datafilesuffix><encrypt><fileversion><hugefile><indexfilesuffix><keycompress><leading><padding><log><debug><error><info><log whoformat><profile><warning><locktimeout><map><name><dir><maxsize><memoryfile><normalize><optimisticadd><prefetch> - FairCom RTG BTRV<recordcheck><rowid> - FairCom RTG BTRV<smartcopy><temporary><transaction><writethru>Substitution SpecifiersXDD<table> root element<key> table element<part> key element<segment> key element<filters> table elementBTRV Note - <filters> table element<filter> filters elementBTRV Note - <filters> filters element<field> filters element<[Operator]> filter elements<field> operator element<value> operator element<schema> table element<field> schema elementAdvanced FairCom RTG TechniquesSample Program: btrv_tutorial1FairCom RTG BTRV Login/Logout OperationBTRV Extended Index TypesSupport for Exclusive Transactions in FairCom RTG BTRVSupport for BTRV Create Index OperationAppendix A - Logging, Error Codes, and TroubleshootingConfigurable Log OutputDriver Error CodesFairCom RTG Error CodesFairCom RTG SQL Access ErrorsTroubleshootingError 407Error 408 / 438Client/Server IncompatibilityFile Matching Rules in ctree.confTroubleshooting PerformanceFairCom Typographical ConventionsCopyright NoticeIndex