c-treeRTG COBOL Edition User's Guide

c-treeRTG Ready-to-Go Products Documentation Overview Key Benefits of c-treeRTG COBOL Edition c-treeRTG Server Advantages c-treeRTG SQL Access for Advanced Data Query Extensive Alternative APIs and Drivers c-treeRTG COBOL Edition Quick Start c-treeRTG Setup and Installation c-treeRTG File System Overview c-treeRTG Server Set-up c-treeRTG for Windows c-treeRTG for Unix/Linux Shared Memory for c-treeRTG Shared Memory Resource Considerations Runtime Configuration Configure the c-treeRTG Server Connecting to the c-treeRTG Server - RM/COBOL Secure SSL Communication c-treeRTG Runtime Drivers COBOL Compilers Supported by c-treeRTG COBOL Edition ACUCOBOL-GT Recompiling the Runtime Recompiling the Windows Runtime Recompiling the Unix Runtime Adding Support for --setenv Command-Line Argument to Runtime ACUCOBOL-GT Environment Variables CTREE_LIB DEFAULT_HOST filename_HOST SET ENVIRONMENT ACUCOBOL-GT Verb AIX 32-bit Server Shared Memory Requires EXTSHM ON Enabling XDDOPEN, XDDCHECK, and XDDCLOSE for Programmatic SQL Conversion Error Checking Error message: "libctclient.so: cannot open shared object file" Micro Focus and ExtFH Compatible Interfaces Dynamic Redirection Recompiling Your Application (Optional) Using the CALLFH Compiler Directive Specifying c-tree as Indexed File Handler at Link Time Configuration Note for Micro Focus on 64-bit AIX Library Unloading Enhancement isCOBOL Configuring isCOBOL Runtime Troubleshooting RM/COBOL Adjusting the RM/COBOL Configuration File Include RM Library with Local Runtime Environment Adjusting Paths Multiple File Systems with RM/COBOL Additional Documentation c-treeRTG Configuration and Management c-treeRTG COBOL Edition Directories Data Conversion RTG Migrate Converting COBOL Vision Data to c-treeRTG COBOL Edition ctmigra Using the ctmigra utility Micro Focus COBOL Migration Example New Standalone Support for ctmigra <localinstance> bufs, dbufs, sect Value Check c-treeRTG Configuration c-treeRTG Configuration Tool - RTG Config Creating a New File (Basic) Creating a New File (Advanced) Editing a Configuration File COBOL Configuration Note Encrypting the Configuration File CTREE_CONF Environment Variable - COBOL CTREE_CONF_DUMP environment variable to specify configuration dump file isCOBOL Note Configuration File Elements c-treeRTG Configuration File Structure Elements <config> <instance> <localinstance> <redirinstance> <file> Wildcard File Matching Rules File Matching Precedence Settings Elements <automkdir> <batchaddition> <bulkaddition> <ctfixed> <datacompress> <datafilesuffix> <delcurrent> <detectlock> <encrypt> <exfthexit> <filecopy> <filepool> <forcedelete> <hugefile> <ignorelock> <indexfilesuffix> <inpool> <keycheck> <keycompress> <rle> <leading> <padding> <log> <debug> <error> <info> <profile> <warning> <locktimeout> <locktype> <maxlencheck> <map> <name> <dir> <memoryfile> <normalize> <optimisticadd> <permission> <prefetch> <recordcheck> <retrylock> <rowid> <runitlockdetect> <scancache> <skiplock> <smartcopy> <sqlize> <startonread> <temporary> <transaction> <trxholdslocks> <writethru> Substitution Specifiers Checking the Configuration Using CTREE_LOG and ctutil CTREE_LOG c-treeRTG SQL Access The c-treeRTG SQL Challenge Common SQL Limitations with c-treeRTG Data REDEFINES: Multiple Record Types Index Compatibility c-treeRTG Extended Data Definitions - XDD Type Mapping Table Variable-length fields mapped into LONGVAR* SQL field COBOL to SQL Type Mapping COBOL Date Baseline Can Be Set to Julian Starting Date of Dec 31, 1600 Create an XDD Manually Create an XDD from an XFD Create an XDD from Your COBOL Source Automatic sqlize Logic Allows an XFD and/or XDD to Be Specified Sqlize: Persist XDD to Data File and Link to SQL Dictionary Step-by-Step Sqlizing Instructions Viewing Sqlized Tables in FairCom DB SQL Explorer Adding SQL Indexes to Sqlized Files Preserve Imported Data Files upon SQL DROP Data Conversion Between COBOL and SQL COBOL to SQL SQL to COBOL Troubleshooting Data Conversion Errors Rules for SQL Conversion Exception Handling <XFDrules> root element <rule> XFDRules element <when> rule element <[Condition]> when elements <do> rule element <[Action]> do elements <[Target]> action element Rule Examples xddgen Techniques Using Group Names Splitting an OCCURR Combining Multiple XDD Directives Name Conflicts HIDDEN Directive Multi-Record Example XDD Schema Structure <table> root element <key> table element <part> key element <segment> key element <filters> table element <field> filters element <filter> filters element <[Operator]> filter elements <field> operator element <value> operator element <schema> table element <field> schema element c-treeRTG Utilities ctutil ctutil Notes ctutil Commands -alter -augment -check -clone -compact -compress -conv -copy -cryptconf -exist -filecopy -fileid -info -make -load -partition -profile -rebuild -remove -rename -run -segment -setowner -setpath -sign -sqlcheck -sqlinfo convention_ID values -sqllink -sqlunlink -sqlize -sqlrefresh -test -tron -uncompress -unload -upgrade -xfd2xdd ctcbtran ctaddrtgi - Add SQL indexes over existing COBOL tables xddgen XDD Directives Handling DATE Fields in Your XFD Syntax for WITH DUPLICATES on RECORD KEY Suppress Dash or Replace with Underscore xddgen Configuration File Configuration Files Directory xddgen - New Configuration Option max-fixed-record-len xddgen - New Record Size Checks and Warnings ctclosefile - Close Open Memory and ctKEEPOPEN files ctclntrn and cthghtrn - Manage Transaction Mark Numbers ctcmpcif - IFIL-based Compact Utility Included ctfileid - Update File IDs ctfixdupscan - Detect and Fix Files that Suffer from File Definition Errors ctstat - Display Log Save Time Delta Values cttrnmod - Change Transaction Mode Utility ct_tpc and cttpca TPC A Test startserver and stopserver Scripts Additional c-treeRTG Command-Line Tools Programing with COBOL The Samples Directory isCOBOL Samples Source Code SQLIZEEXAMPLE.CBL CARDFILE.FD CARDFILE.SL rules.xml Performance Tuning Performance Tips Performance Monitoring with ctstat Additional Monitoring Tools Replication, Clusters, HA, and DR c-treeRTG Failover Configuration Changes to Your COBOL Program ACUCOBOL API for SQL Conversion Error Checking SQL Conversion for ACUCOBOL Users ct_XDDOpen ct_XDDCheck ct_XDDClose XDDCHECK Errors Logging, Error Codes, and Troubleshooting Listing connections with a particular file open Copying Server-Controlled Files Configurable Log Output c-treeRTG SQL Access Errors C$ Not Supported in c-treeRTG Troubleshooting Error 456 Error 407 Error 408 / 438 Client/Server Incompatibility File Matching Rules in ctree.conf isCOBOL Fails to Run cobol_Tutorial1 READ NEXT at End of File Driver Error Codes c-treeRTG Error Codes FairCom Typographical Conventions Copyright Notice Index