FairCom RTG COBOL Edition User's Guide

 
FairCom RTG Ready-to-Go Products
Documentation Overview
Key Benefits of FairCom RTG COBOL Edition
FairCom RTG Server Advantages
FairCom RTG SQL Access for Advanced Data Query
Extensive Alternative APIs and Drivers
FairCom RTG COBOL Edition Quick Start
FairCom RTG Setup and Installation
FairCom RTG File Handler Overview
FairCom RTG Server Set-up
FairCom RTG for Windows
FairCom RTG for Unix/Linux
Shared Memory for FairCom RTG
Shared Memory Resource Considerations
Runtime Configuration
Configure the FairCom RTG Server
Connecting to the FairCom RTG Server - RM/COBOL
Secure SSL Communication
FairCom RTG Runtime Drivers
COBOL Compilers Supported by FairCom RTG COBOL Edition
ACUCOBOL-GT
Recompiling the Runtime
Recompiling the Windows Runtime
Recompiling the Unix Runtime
Adding Support for --setenv Command-Line Argument to Runtime
Appending Indices to Existing Files from the RTG FSI Interface (ACUCOBOL)
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
FairCom RTG Configuration and Management
FairCom RTG COBOL Edition Directories
Data Conversion
RTG Migrate
Converting COBOL Vision Data to FairCom RTG COBOL Edition
ctmigra
Using the ctmigra utility
Micro Focus COBOL Migration Example
New Standalone Support for ctmigra
<localinstance> bufs, dbufs, sect Value Check
FairCom RTG Configuration
FairCom RTG 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
FairCom RTG Configuration File
Structure Elements
<config>
<instance>
<localinstance>
<redirinstance>
<file>
Wildcard File Matching Rules
File Matching Precedence
Settings Elements
<automkdir>
<batchaddition>
<bulkaddition>
<ctfixed>
<ctfixed>
<datacompress>
<datafilesuffix>
<delcurrent>
<detectlock>
<encrypt>
<extfhexit>
<extfhreindexoncreate>
<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
FairCom RTG SQL Access
The FairCom RTG SQL Challenge
Common SQL Limitations with FairCom RTG Data
REDEFINES: Multiple Record Types
Index Compatibility
FairCom RTG 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
FairCom RTG Transaction Support
Transaction Control - Why you should want it
Enabling RTG transaction control
Switching transaction modes
Automatic Recovery
Transaction control and performance
Transaction log files and best practices
FairCom RTG backup management
FairCom RTG Utilities
ctutil
ctutil Notes
ctutil Commands
Replicating RTG File Operations
-alter
-augment
-check
-clone
-compact
-compress
-conv
-copy
-cryptconf
-exist
-filecopy
-fileid
-info
-make
-makeidx
-load
-partition
-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 FairCom RTG Command-Line Tools
Programming 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
FairCom RTG Failover Configuration
Changes to Your COBOL Program
FairCom RTG Transaction Support
New Topic (6)
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
FairCom RTG SQL Access Errors
C$ Not Supported in FairCom RTG
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
FairCom RTG Error Codes
FairCom RTG COBOL Tutorials
cobol_Tutorial1
Compile cobol_Tutorial1 with ACUCOBOL
Compile cobol_Tutorial1 with isCOBOL
Run cobol_Tutorial1 with ACUBOBOL
Run cobol_Tutorial1 with isCOBOL
Open cobol_Tutorial1 data through SQL (optional)
cobol_Tutorial1 Source Code
Sqlize Tutorial
FairCom Typographical Conventions
Copyright Notice
Index