Users Guide

 
Copyright Notice
FairCom Typographical Conventions
c-treeRTG Ready-to-Go Products
Documentation Overview
Key Benefits of c-treeRTG COBOL Edition
c-treeRTG COBOL Edition Quick Start
ACUCOBOL-GT Setup
Recompiling the Runtime
Recompiling the Windows Runtime
Recompiling the Unix Runtime
Adding Support for --setenv Command-Line Argument to Runtime
Troubleshooting
Error message: "libctclient.so: cannot open shared object file"
Configuring the Runtime for ACUCOBOL-GT
CTREE_LIB Environment Variable
ACUCOBOL-GT Environment Variables
DEFAULT_HOST
filename_HOST
SET ENVIRONMENT ACUCOBOL-GT Verb
Enabling XDDOPEN, XDDCHECK, and XDDCLOSE for Programmatic SQL Conversion Error Checking
Converting ACUCOBOL Data to c-treeRTG COBOL Edition Data
Micro Focus COBOL Setup
Configuring the Runtime for Micro Focus
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
isCOBOL Setup
Configuring the Runtime for isCOBOL
Troubleshooting
RM/COBOL Setup
Installing the RM/COBOL Driver
Installing the RM/COBOL Driver on Windows
Installing the RM/COBOL Driver on Linux
Adjusting the RM/COBOL Configuration File
Copying the RM Library to the Local Folder
Adjusting the Paths
Multiple File Systems with RM/COBOL
Additional Documentation
c-treeRTG Server Setup
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
c-treeRTG Configuration
c-treeRTG Configuration Tool - RTG Config
Creating a New File (Basic)
Creating a New File (Advanced)
Editing a Configuration File
Support for Encrypting the Configuration File
CTREE_CONF Environment Variable - COBOL
CTREE_CONF_DUMP environment variable to specify configuration dump file
Data Conversion
RTG Migrate
ctmigra
Using the ctmigra utility
Micro Focus COBOL / BTRV Migration Example
c-treeRTG SQL Access
Creating an XDD from an XFD
Creating an XDD from the COBOL Source
Creating an XDD Manually
Storing the XDD in the Data File and Linking to the SQL Dictionary - COBOL
Defining External Rules
<XFDrules> root element
<rule> XFDRules element
<when> rule element
<[Condition]> when elements
<do> rule element
<[Action]> do elements
<[Target]> action element
Rule Examples
Type Mapping Table
Variable-length fields mapped into LONGVAR* SQL field
Troubleshooting Data Conversion Errors
Viewing Sqlized Tables in c-treeACE SQL Explorer
Adding SQL Indices to Sqlized Files
API for SQL Conversion Error Checking
SQL Conversion for ACUCOBOL Users
ct_XDDOpen
ct_XDDCheck
ct_XDDClose
XDDCHECK Errors
Background Information about Sqlizing
Record Structure Definition: The XDD
When an XFD is Available
When an XFD is Not Available: xddgen
Merging the XDD with the Data File
Indices
Multiple Record Types
Data Conversion Considerations
SQL to COBOL
COBOL to SQL
SQL Considerations
Common Issues
c-treeRTG SQL Support
COBOL to SQL Type Mapping
Tips for Advanced Sqlizing
Step-by-Step Sqlizing Instructions
xddgen Techniques
Using Group Names
Splitting an OCCURR
Combining Multiple XDD Directives
Name Conflicts
HIDDEN Directive
Multi-Record Example
Source Code
SQLIZEEXAMPLE.CBL
CARDFILE.FD
CARDFILE.SL
rules.xml
Utilities: ctutil, ctcbtran, xddgen, cttrnmod, ctmigra, ctfileid
ctutil
ctutil Notes
ctutil Commands
-addimg
-check
-checkimg
-clone
-compact
-compress
-conv
-copy
-cryptconf
-filecopy
-fileid
-getimg
-info
-make
-makeimg
-load
-loadtext
-profile
-rblimg
-rebuild
-remove
-rename
-run
-segment
-setpath
-sign
-sqlcheck
-sqlinfo
-sqllink
-sqlunlink
-sqlize
-sqlrefresh
ctutil configuration and connection -test option
-tron
-uncompress
-unload
-unloadtext
-upgrade
-xfd2xdd
ctcbtran
ctaddrtgi - Add SQL indices 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
cttrnmod - Change Transaction Mode Utility
ctfileid - Update File IDs
Copying Server-Controlled Files
ctclntrn and cthghtrn utilities for managing transaction mark numbers
ct_tpc and cttpca TPC A Test
Additional Command-Line Tools Added to c-treeRTG
Details about the File System and SQL
c-treeRTG File System Details
The SQL Challenge
Configuration File Elements
c-treeRTG Configuration File
Structure Elements
<config>
<instance>
<redirinstance>
COBOL Example
<file>
Wildcard File Matching Rules
File Matching Precedence
Settings Elements
<automkdir>
<batchaddition>
<bulkaddition>
<ctfixed>
<datacompress>
<datafilesuffix>
<detectlock>
<encrypt>
<filecopy>
<filepool>
<hugefile>
<ignorelock>
<indexfilesuffix>
<keycheck>
<keycompress>
<leading>
<padding>
<log>
<debug>
<error>
New <log><error> types: <locked>, <missingfile>, and <undefined>
<info>
<profile>
<warning>
<locktimeout>
<locktype>
<maxlencheck>
<map>
<name>
<dir>
<memoryfile>
<normalize>
<optimisticadd>
<prefetch>
<retrylock>
<runitlockdetect>
<skiplock>
<smartcopy>
<sqlize>
<temporary>
<transaction>
<trxholdslocks>
<writethru>
Substitution Specifiers
XDD File Schema
<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 COBOL Edition Directories
Sample Programs
The Samples Directory
isCOBOL Samples
Connecting to the c-treeRTG Server
Transaction Processing Notes
Performance Tuning
Performance Monitoring with ctstat
Additional Monitoring Tools
Performance Tips
Logging, Error Codes, and Troubleshooting
Improved log output with file names on ERROR entries
Driver Error Codes
Error Codes
c-treeRTG SQL Access Errors
Troubleshooting
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
Index