Software AG CONNX Data Integration Suite Help
Document Conventions
Online Information and Support
Data Protection
Release Notes
Software AG CONNX Data Integration Suite Help
Version 14.8 October 2024
Critical Changes for 14.8
Known Issues for 14.8
Version 14.8
Version 14.7
Critical Changes for 14.7
Known Issues for 14.7
Concepts
Features
Benefits
Components
CONNX For Mainframe
CONNX for Linux/UNIX
How CONNX Works
How CONNX JDBC Works
Enterprise Server Service
Advanced Features of CONNX
General Features
Connecting to Multiple Servers
Migrating to the New CONNX CDD Format
Fast Tuning Logic
SQL View Clause Text Box
CONNX Views
What is CONNX Views
Creating CONNX View in the CONNX Data Dictionary Manually
Adding Security to a CONNX View
Rotated Arrays
Overview
Configuring a Rotated Array
Using the Rotated Array Assistant
SCT Plus2000-Specific Non-Standard Rotated Arrays
Using Non-Standard Uncompressed Format within SCT Plus2000-Specific Rotated Arrays
SCT Plus2000-Specific Unusable Non-Rotated Records
Excluding Unusable Non-Rotated Records within SCT Plus2000-Specific Rotated Arrays
Clone Table Assistant
Hot Connection to a Server
CONNX and Orancle Advanced Features
Using Oracle Stored Procedures with CONNX
SQL Functionality and Oracle Native Functions
Performing Queries in Passthrough Mode in Oracle Rdb Databases
CONNX and DB2 Advanced Features
How CONNX Transparently Maps Dynamic SQL to Static SQL for DB2
Building a Static SQL Package Using the CONNX CDD Import Utility
Defining Static SQL Statements for the Static DB2 Package
Verifying a Successful Package Build at the Target Host
Importing Stored Procedures
CONNX and SQL Server Advanced Features
Adabas SQL Gateway Advanced Features
How CONNX Handles Adabas Periodic Groups and Multi-Value Fields
Inserting Data into MU and PE Fields
Updating Data in Existing MU and PE Fields
Deleting Data from Existing MU and PE Fields
User Exits
Comparing Data Dictionaries
Data Dictionary Comparison Tool
Using the Data Dictionary Comparison Tool
Category Definitions
CONNX Excel Add-In
What is the CONNX Excel Add-In
Using the CONNX Excel Add-In
CONNX Excel Add-In FAQ
Troubleshooting
SSL/TLS Support
SSL Support with CONNX
SSL on the Mainframe
SSL on VMS
SSL on DB2
SSL on UNIX-Based CONNX Servers
SSL on the CONNX Enterprise Server Service
SSL with JDBC
Performance Tips and Application Notes
CONNX with Microsoft Access and Visual Basic
Using CONNX with Microsoft Access
Using CONNX with Microsoft Visual Basic
New Users and Microsoft Access Database Links
OLE DB, Microsoft Access 97 Queries, and CONNX
OLE DB, Access 97, Access 2000, and CONNX
Microsoft SQL Server
ODBC, Microsoft Access 97 for SQL Server 7.0, and CONNX
OLE DB Non-Indexed Tables and SQL Server 7.0
Troubleshooting
CONNX ODBC Driver
Adabas Performance Tuning
Record Locking and Transactions
Transaction Support
Adabas
DataFlex
POWERFlex
RMS
Oracle Rdb
DBMS
DB2
Oracle
VSAM
C-ISAM, DISAM, and Micro Focus
Installation Guide
Installation Overview
Supported Platforms
System Requirements
Installation Steps
Installing CONNX Administrator and CONNX Client
Installation on Windows
Installation on UNIX
Installation on UNIX
Creating Docker Images for CONNX Components on Linux
Completing CONNX Installation for UNIX ODBC Drivers
Completing CONNX Installation for UNIX JDBC Servers
Creating CONNX Sample Database Tables
Creating Oracle Sample Database Tables
Building CONNX for DB2 Sample Tables on Target Host via TCP/IP
Building CONNX for DB2 Sample Database Tables on Target Host via SNA APPC LU 6.2
Building Enterprise OLE DB Sample Database Tables
Building Enterprise ODBC Sample Database Tables
Building Desktop OLE DB Sample Database Tables
Installing Desktop ODBC Sample Database Tables
Building SQL Server OLE DB Sample Database Tables
Building SQL Server ODBC Sample Database Tables
Building Desktop Informix Sample Database Tables
Building Desktop Sybase Sample Database Tables
Building C-ISAM Sample Database Tables
Installing CONNX JDBC Server and Client
CONNX JDBC Overview
Starting and Stopping the CONNX JDBC Server on Windows
Activating the CONNX JDBC Router
Connecting to the CONNX JDBC Server
Starting and Stopping the CONNX JDBC Server on UNIX
Editing the JDBC Server Startup Procedure in UNIX
Moving a Client to a Non-Windows Platform By Transferring the .jar File
Installing CONNX OpenVMS
Overview
Installing CONNX OpenVMS Server
Running Multiple Versions of CONNX on an OpenVMS Server
Testing the OpenVMS Server Installation
Testing User Account Privileges
Using Your Telnet Utility - TCP/IP
Installing Mainframe-Compatible Server
About Installing CONNX on Mainframe-Compatible Server
Adabas SQL Gateway - z/OS
Prerequsites
Installation
Installing Adabas SQL Gateway Components
Introduction
Verifying the Installation and Starting the CONNX Listener
Enabling RACF Security
Testing User ID and Password Verification
Stopping the Batch Job/Started Task TCP/IP Listener
SAS/C Network Administration
Determining the TCP/IP Stack
Uninstalling Adabas SQL Gateway Components
Host/Client Security
CONNX for IMS
Prerequisites
Installing CONNX Components on the Target IMS System
Required and Optional Entry Fields for IMS Server Setup
IMS DSN Prefix Data Sets
IMS Installation JCL
Uninstalling the CONNEX IMS Components
CONNX for VSAM and QSAM
CONNX for VSAM - Started Task/Batch
CONNX for VSAM/QSAM/PDS Prerequisites
Installation
Installing CONNX Components on Target z/OS System
Required and Optional Entry Fields for VSAM TCP/IP Server Setup
DSN Prefix Data Sets
VSAM Objects for CONNX.STASK.SAMPLES
Installing Started Tasks
Installation Verification of CONNX Started Task Components
Overview
Verifying the CONNX Started Task Components Installation
Importing Metadata from COBOL Copybooks
Importing Metadata for the CONNX Sample QSAM Customer Physical Sequential File
Importing Metadata for the CONNX Sample Customer Partitioned Data Set
Testing CONNX for VSAM Query/Import Functionality against SCT VSAM Master Files
Testing CONNX for VSAM Started Task/Batch Job SCT Metadata Import Functionality
Testing CONNX for VSAM Started Task/Batch Job User ID/Password
CONNX TSO Configuration Utility
Overview
Stopping the CONNX Started Task/Batch Job TCP/IP Listener
Persistent Environment Variables
Setting a Persistent CONNX Environment Variable
Changing a CONNX Persistent Environment Variable
Changing the Number of the CONNX TCP/IP Port Persistent Environment Variable
Converting the Persistent CONNX Port Number to the Default
CONNX Environment Variables
Scope and Precedence
Defining Unique CONNX Environment Variables per Started Task/Batch Job
Environment Variable Security vs. Ease of Use
Starting Multiple Instances of CONNX Started Tasks
Uninstalling CONNX Started Task Components
Overview
Uninstalling the CONNX for VSAM Started Task Components
Dataset Security
CONNX for VSAM - CICS
CONNX for CICS/VSAM-z/OS Prerequisites
Installing the CONNX VSAM Components on a z/OS Server
Installing the CONNX Components on the Target CICS/VSAM z/OS System
Required and Optional Entry Fields for VSAM TCP/IP Server Setup
CONNX DSN Prefix Data Sets
VSAM Objects for CONNX.CICS.SAMPLES
Installing the CONNX Components
Installing the Selected Components on the z/OS Target
Changing the CICS Startup JCL RPL List
Verifying the Installation of CONNX CICS Components
Configuration Utility
Starting the IBM CICS TCP/IP Sockets Interface - IMS
Starting the CONNX CICS/VSAM TCP/IP Listener
Setting a CONNX Environment Variable
Changing a CONNX Environment Variable
Converting the CONNX Port Number to the Default
Displaying the Current CONNX Environment Variables
Uninstalling CONNX for CICS/VSAM-zOS
Installing Adabas SQL Gateway on UNIX
Overview
Installing the Adabas SQL Gateway Component
Building a Docker Image for the Adabas SQL Gateway Server Component on a Linux Machine
UNIX Environment Variables
Stopping and Restarting the Adabas SQL Gateway Server Component
Editing the connxserver Shell Script
Editing the Adabas Server Startup Procedure
Recommended Configurations for Adabas SQL Gateway
Installing UNIX Data Servers
Overview
Installing the Data Server components on a UNIX Machine
Building a Docker image for the C-ISAM and D-ISAM server component on a Linux machine
Editing the C-ISAM, DISAM, RMCobol, Dataflex, or Micro Focus Server Startup Procedure
Stopping and Restarting the C-ISAM, DISAM, RMCobol, Dataflex or Micro Focus server
DB2 Host Configuration
CONNX and Db2
CONNX Db2 Dynamic SQL Packages
Establishing CONNX and DB2 CDD Configuration Options
Host Configuration for Db2 Admins
CONNX and DB2/UDB (Universal Database) - TCP/IP
Establishing TCP/IP Configuration on DB2 UDB
Verifying Server TCP/IP Settings via DB2 CLP
CONNX and DB2/UDB - APPC SNU LU 6.2
Verifying Server APPC/LU 6.2 Settings via Control Center
Verifying Server APPC/LU 6.2 settings via Command Line Processor
Adding APPC/LU 6.2 Support to the Configuration
Verifying Server Settings for AIX Servers
CONNX and DB2/400 Databases
Communication Setup and Scenarios for TCP/IP
Establishing RDBName Configuration
Establishing TCP/IP Configuration
Setting up APPC/LU 6.2 Communications on Target Systems
Setting up MPTN Configuration
Verifying MPTN APPC Controller Configuration
Verifying IEEE 802.2 DLC Configuration
Verifying IBMRDB Mode Description
Communications Setup and Scenarios for 3-Tier Communications Server
Setting up the IBM Com Server as an MPTN Gateway
Defining the Mode Name for DRDA Connections = IBMRDB
Defining or Verifying the DB2 Transaction Program Name
Setting up the IBM Communications Server in an IEEE 802.2 DLC Scenario
Defining the Server Node for a Microsoft SNA Server
Communications Setup and Scenarios for Novell NetWare for SAA 4.0
Setting up the Novell NetWare in an IEEE 802.2 DLC scenario
Configuring the Node in APPN/APPC for Novell NetWare
Configuring Data Link Adapters
Defining a Peer Link
Defining a Partner LU 6.2
Defining a Transaction Program Name
Defining a Mode
Communications Setup and Scenarios for 2-Tier SNA Client Configuration
Setting up 2-tier SNA Client Configuration for Attachmate - MPTN
Setting up 2-tier Client Configuration for Attachmate - IEEE 802.2
Setting up 2-tier SNA Client Configuration for RUMBA MPTN
Setting up 2-tier SNA Client Configuration for RUMBA IEEE 802.2 DLC
CONNX and z/OS Databases
Host Configuration
Db2/Mainframe: Defining the RDBName to Db2 DDF
Configuring VTAM for DRDA via SNU/LU 6.2
Configuring MPTN-Specific VTAM Information on the Host
Creating an SNATCP Macro
Verifying IP Address and Host Name
Db2 Communications Database Setup
APPC Connection Scenarios - 3-tier Communications Server Configuration
Connecting to a Db2 for z/OS
Connecting to the Target DB2 Region via CONNX
Post-Installation Procedures
Overview
C-ISAM, DISAM, Micro Focus
CONNX JDBC Server
CONNX Upgrades
DataFlex
DB2
IBM Mainframe-Compatible Server
Adabas SQL Gateway
Informix Data Sources
Oracle
POWERflex
OLE DB- and ODBC-Compliant Data Sources
OpenVMS Server
Sybase Data Spurces
Troubleshooting Post-Installation Procedures
Modifying the CONNX Registry File Settings for DataFlex Year Digits
Editing the OpenVMS Site-Specific Startup Command Procedure
Testing a Database Connection
Reviewing the Minimum OpenVMS Quotas
Minimum Quota Values for RMS, Rdb, and DBMS Databases
Converting Data Dictionaries
Troubleshooting Connection Issues
Troubleshooting with RMS, Oracle Rdb, and Codasyl DBMS Databases
Troubleshooting with TCP/IP and OpenVMS
Pinging the OpenVMS Server - TCP/IP
Reviewing CNXSETUP.LOG Using FTP - TCP/IP
CONNX JDBC Sample Application
CONNX JDBC Sample Applet
License Management
Overview
Activating Licenses Online
Updating an Existing License
Activating Licenses Offline
Revoking Licenses Offline
Moving Licenses from one License Server to Another
Activating an Emergency License
Frequently Asked Questions about Licenses
Backward and Forward Compatibility
Using Multiple Versions of CONNX Simultaneously
Remote Silent Installation
Creating the CONNX Client Installation Record File
Creating a Shortcut to CONNX Setup
Running the Remote CONNX Client Installation
Enterprise Planning Guide
Introduction
The CONNX Architecture
View from 10,000 Feet
A Typical Architecture Example
CONNX Planning
Component Configuration
Service Configuration
Estimating Troughput Requirements
Estimating Component Requirements
Estimating Server Requirements
Estimating License Requirements
Planning Component Installation
Planning the SQL Catalogue (CONNX CDD)
Scalability
CONNX Administration
Development and Testing
Deployment
CDD Management
Controlling Access
Updating Indexes
CONNX Performance
Query Tuning
CPU
Memory
Input and Output
CONNX Scenarios
Scenario 1: Local and Remote CONNX Servers
Scenario 2: .NET via SQL Server
Scenario 3: NTIER
Scenario 4: JBoss and Hibernate on Linux
Scenario 5: RCI Embedded COBOL
Administration Guide
CONNX Security
CONNX Security Overview
Adding Security to Tables and Columns
Adding Security to a Data Dictionary Entry
Deleting an Existing Security Restriction
Identifying the Server Name
Overriding the Default Server Name (RMS only - for multiple servers)
CONNX Users and Groups
Adding a New User
Changing a User's Password
Adding a New Group
Adding New Users to a Group
Removing Users from a Group
Using the CONNX Embedded Logon
Disabling the Creation of Views
Database Account Management
Accessing Multiple Databases
Modifying Usernames and Passwords
Changing Database Owner Name
Disabling Integrated Security
Application Management
Introduction
Adding an Application
Removing an Application
Removing a Database From Use Within an Application
Maximum CDD Security Option
CONNX and VSAM: CICS Server-Side Security
CICS/VSAM Host / Client Security Overview
CONNX TCP/IP Listener and Server Security
Creating a CICS Surrogate UserID and Logging in CONNX
CONNX Configuration Settings
Introduction
CONNX Configuration Manager (Windows)
Adding New Configuration Settings
Updating Configuration Settings
Removing Configuration Settings
Mainframe Configuration Instructions
CICS Configuration Instructions
Mainframe Started Task Configuration Instructions
CONNX SQLRegistry Program (Unix)
Configuring the CONNX Client and the JDBC Server
Updating UNIX Configuration Settings with the SQLRegistry Program
CONNX Configuration Settings Reference
Configuration Settings with Numbers or Symbols
"A" to "B" Configuration Settings
"C" Configuration Settings
"D" to "F" Configuration Settings
"H" to "J" Configuration Settings
"K" to "M" Configuration Settings
"N" to "P" Configuration Settings
"Q" to "S" Configuration Settings
"T" to "Y" Configuration Settings
General Data Protection Regulation
CONNX REST Server
About the REST Server Functions and Architecture
Securing the CONNX REST Server
Scenario 1 - Continued usage of the self-signed SSL certificates created by the CONNX REST Server
Scenario 2 - Usage of SSL certificate created by an internal corporate or external Trusted Root Authority
REST API Documentation
Managing Users for the Online CONNX Suite
Developer Guide
CONNX ODBC Driver
ODBC Driver Definition
ODBC Driver Architecture
CONNX ODBC Conformance
Features of the ODBC Driver
ODBC Programming Considerations
Linking Programs
Configuring the Data Source
Configuring the ODBC Data Source Using a Provider String
Configuring the Data Source Name for the CONNX ODBC Driver
Configuring the Existing Data Source
Linking to a Data Source Using Microsoft Access 2003
Connecting to the CONNX ODBC Driver
Opening a Connection to the CONNX ODBC Driver
CONNX ODBC Connection String Parameters
CONNX OLE DB Provider - Windows
The CONNX OLE DB Provider
Features of the OLE DB Provider
Configuring the OLE DB Data Source
CONNX JDBC Driver
The CONNX JDBC Driver
CONNX JDBC Configuration Settings
CONNX JDBC Router
JDBC Data Type Conversions
CONNX JDBC Architecture
CONNX JDBC Driver Architecture
CONNX JDBC Java Application Architecture
CONNX JDBC Java Applet Architecture
CONNX JDBC Java Servlet Architecture
Connecting to a JDBC Data Source
CONNX JDBC Connection String Parameters
Starting the CONNX JDBC Server
Removing Out-of-Environment Error Messages
JDBC Interfaces Supported by CONNX
Array
Blob
CallableStatement
Clob
Connection
DatabaseMetaData
Driver
InputStream
PreparedStatement
Ref
ResultSet
ResultSetMetaData
SQLData
SQLInput
SQLOutput
Struct
Statement
CONNX .NET Data Provider
Overview
Adding a Reference to the CONNX .NET Data Provider
Specifying a Name Space for the Added Reference
CONNX .NET Data Provider Object Model
CNXCommand
CNXConnection
CNXDataAdapter
CNXDataReader
CNXDbType
CNXException
CNXParameter
CNXParameterCollection
CNXTransaction
CNXTransactionCapabilities
CONNX Unicode Support
CONNX OLE RPC Server
64-bit Support
Native 64-bit Application Support
Native 64-bit Data Source Support
Configuring 64-bit and 32-bit Components
64-bit to 32-bit ODBC and OLE DB Bridge
Location of DLLs on 64-bit Windows
Limitations of 64bit Data Access on Windows
Demonstrations and Applications
CONNX JDBC Sample Application
Using the CONNX JDBC Sample Application
Running the CONNX JDBC Sample Application
Navigator Bar
CONNX Data Dictionary Viewer
Overview
Opening a Connection to a Data Source Name
Locating a Specific Field
Closing a Database Connection
Operations Guide
Working with Database Objects in CONNX
CONNX Basics
Working with CDDs
CDD Data Dictionary Manager
Creating a CDD
When Importing Existing Table Definitions
Opening an Existing CDD
Using the CONNX Find Feature
Cutting or Copying and Pasting a Record in the CDD
Cloning a Database in the CDD
Using the CONNX Browse button (RMS Only)
Filtering CONNX Data Types
Viewing an Index
Importing from the Command Line
CONNX Catalog Support
Updating Statistics in the CONNX Data Dictionary Manager
Adding a Database Connection
Linking Master CONNX CDDs
LInking Child Dictionaries in the CONNX Data Dictionary Manager
Preventing a CDD From Being Linked as a Child
Viewing Database Information
CONNX Adapter: Enterprise and Database Modules
Introduction
ODBC Data Source Names Used with Multiple Users
Importing OLE DB Data Sources
Importing an Existing Table from an OLE DB-compliant Data Source Using the CONNX Adapter
Importing an Existing Table from an OLE DB-compliant Provider Data Source Using the Desktop OLE DB Adapter
Importing ODBC Data Sources
Importing an Existing Table from an ODBC-compliant Provider Data Source Using the CONNX Adapter - Enterprise Module
Importing an Existing Table from an ODBC-compliant Data Source Object Using the CONNX Adapter - Desktop Module
CONNX and Adabas
Adabas SQL Gateway Import Types
Limitations and Suggestions
Importing from Natural
Prerequisites
Generating a SYSOBJH File on OpenSystems
Generating a SYSOBJH File on Mainframe
Importing a SYSOBJH Generated File to CONNX
Importing from Adabas FDT (read field definitions)
Importing from Dynanmic DDL Files
Adabas ADASCR Security
Using ADASCR with CONNX
Code Pages
Aggregating Identical Adabas Databases
CONNX and C-ISAM, DISAM, and Micro Focus
Introduction
Manual Imports
General Information
Building a C-ISAM, DISAM, or Micro Focus Database Manually
Creating a C-ISAM, DISAM, or Micro Focus Table Entry Manually
Adding Columns to a C-ISAM, DISAM, or Micro Focus File Entry
Importing from C-ISAM, DISAM, and Micro Focus COBOL File Definition Files
Text File Imports
C-ISAM, DISAM, and Micro Focus Table Imports
C-ISAM, DISAM, or Micro Focus VIEW Text File Import Specification
Accessing a Sequential File in Micro Focus
CONNX and DataFlex, RMS, and DBMS Databases
Importing from Different Sources
Performing an RMS SCT DBD (Database Definition) Overlay Import
CONNX and SCT Import Rules
SCT DBD Overlay Conventions
RMS Text Files
Import Specification for RMS Text Files
Import Specification for RMS View Text Files
Creating CDD Entries Manually
Creating an RMS Table Entry
Creating an RMS Database
Adding Columns to an RMS File
Viewing an Index
Importing DataFlex or POWERFlex Table Definitions
Codasyl DBMS Tables
Importing Codasyl DBMS Tables
Including Subschemas with Codasyl DBMS Table Imports
CONNX and DB2
CONNX and DB2 Module
Import and Connect-Time Security Requirements
How the CONNX Db2 Module Maps ODBC to DRDA Isolation Levels
DB2/OS400
OS/400 Remote Commands
Dynamic SQL Package Security
AS/400 Plug-n-Play Mode
Db2 and Db2 for z/OS CDD Import Security Requirements
DB2 UDB for Windows NT 4.0, OS/Warp Server, and Linux
DB2 UDB for Windows and Linux CDD Import Security Requirements
DB2 UDB Dynamic SQL Package Security
CONNX and DB2 CDD Settings
Importing Existing Db2 Tables, Views, and Stored Procedures using TCP/IP
Importing Existing DB2 Tables, Views, and Stored Procedures Using SNA protocol
CONNX Db2 Dynamic SQL Packages
Establishing CONNX and DB2 CDD Configuration Options
Importing from an Informix ODBC Provider Data Source
CONNX and Oracle
Importing an Oracle Database Table
Importing an Oracle RDB Table
Importing PostgreSQL Database Tables
CONNX and SQL Server
CONNX SQL Server Module
Importing an SQL Server Database using an OLE DB Provider
Importing Objects from a SQL Server ODBC Provider Data Source
Importing Tables from a Sybase ODBC Compliant Data Source
CONNX and VSAM
z/OS
Importing from VSAM COBOL FD Files (CICS) - z/OS
Importing from SCT COBOL FD (File Definition) Files - z/OS
Performing a VSAM SCT DBD (Database Definition) Overlay Import - z/OS
Importing Remote VSAM Files
Prerequisites and General Information
Importing Remote VSAM Files With and Without Matching Local Files from COBOL FD Files (CICS) - z/OS
Local and Remote Query Performance
Importing from VSAM COBOL FD files - Started Task (QSAM/PDS)
VSAM File Import Configuration Parameters
Configuration Parameters - IMPORTALTINDEXES and FASTPATHMATCH
Configuring IMPORTALTINDEXES
VSAM Text File Import Specification
VSAM View Text File Import Specification
Importing Tables or Views from a VSAM Text File Import Specification
CONNX and IMS
Importing IMS Files
IMS Index Text File Import Specification
Specifying IMS Packed Decimal Data Fields
Importing Redshift Database Tables
Importing Integration Server - EnitreX
CONNX Remote Procedures and Commands
CONNX Remote Procedures
Building a Remote Procedure
Executing OS/400 Remote Commands via CONNX and DB2
Executing Remote Commands via ODBC-compliant Application and CONNX
Executing a Remote Procedure Call via SQL
Working with the Online CONNX Suite
About the Online CONNX Suite
Requirements for the Online CONNX Suite
Logging on to the Online CONNX Suite
Managing CDDs with the Online CONNX Data Dictionary Manager
About the Online CONNX Data Dictionary Manager
Accessing the Online CONNX Data Dictionary Manager
Working with CDDs
Opening a CDD for Editing
Changing the Default CDD Folder
Creating a New CDD or Folder
Uploading a CDD to the REST Server
Downloading a CDD from the REST Server
Renaming a CDD or a Folder
Deleting a CDD or a Folder
Making a Copy of a CDD
Configuring a CDD's Global Permissions
Restricting CDD Access with a Password
Restricting CDD Access to Defined Users
Disabling CONNX Integrated Security for a CDD
Configuring Additional CDD Options
Adding a Child Link to a CDD
Working with Databases in a CDD
Importing an ADABAS Dynamic DDL
Importing from ADABAS FDT
Importing an ADABAS SYSOBJH Generated File
Importing a Change Data Capture Target
Importing a CISAM COBOL File Definition
Importing a CISAM Powerhouse Definition Language File
Importing a CISAM Text Specification File
Importing from a PostgreSQL Database
Importing DataFlex Files from a Directory
Importing DataFlex Files from a Server
Importing from a DB2 Database
Importing DBMS Codasyl
Importing with the Desktop OLE DB/ODBC Adapter
Importing a DISAM COBOL File Definition
Importing a DISAM Powerhouse Definition Language File
Importing a DISAM Text Specification File
Importing with the Enterprise OLE DB/ODBC Adapter
Importing EntireX
Importing from an IMS Database
Importing from an IMS Text Specification File
Importing from an Informix Database
Importing from Java Message Service
Importing a Microfocus COBOL File Definition
Importing a Microfocus Text Specification File
Importing from a MySQL Database
Importing from an Oracle Database
Importing PowerFlex Files from a Directory
Importing PowerFlex Files from a Server
Importing from an Oracle RDB Database
Importing from a Redshift Database
Importing an RMS COBOL File Definition
Importing an RMS DIBOL File
Importing an RMS Formatted Data Definition Language File
Importing an RMS Powerhouse Definition Language File
Importing an RMS SCT COBOL File Definition
Importing an RMS SCT Datamart COBOL File Definition
Importing from an RMS Text Specification File
Importing an RMS VMS Basic File
Importing an RMS VMS CDD
Importing from SQL Server
Importing from Sybase
Importing a VSAM COBOL File Definition
Importing a VSAM SCT COBOL File Definition
Importing a VSAM SCT Datamart COBOL File Definition
Importing a VSAM Text Specification File
Editing Database Properties post Import
Inputting the Data File Name when Importing from File Definition Files
Configuring a Database to use the Enterprise Server Service for Database Access
Adding a Database Connection to a CDD
Renaming a Database in a CDD
Deleting a Database from a CDD
Working with Tables in a CDD
Editing Table Properties
Editing Column Properties in a Table
Viewing the Indexes of a Table
Adding Table Restrictions
Removing Table Restrictions
Editing Table Restrictions
Renaming a Table in the CDD
Deleting a Table from a CDD
Working with CONNX Views in a CDD
Adding a CONNX View
Editing a CONNX View
Renaming a CONNX View
Deleting a CONNX View
Adding CONNX View Restrictions
Removing CONNX View Restrictions
Editing CONNX View Restrictions
Administering a CDD
Adding a User to a CDD
Removing a User from a CDD
Changing the Password of a User in a CDD
Creating a New User Group
Adding and Removing Users from a User Group
Deleting a User Group
Managing Database Accounts
Application Management - Creating a Subset of Data Sources
Adding or Removing Databases from an Application
Deleting an Application
Administering CONNX with the CONNX Configuration Manager
About the Online CONNX Configuration Manager
Accessing the CONNX Configuration Manager
Adding Settings
Editing Settings
Deleting Settings
Working with the JDBC Data Source Name Creation Tool
Adding a DSN
Editing a DSN
Deleting a DSN
Working with the License Administrator Tool
About the Online License Administrator Tool
Connecting to a License Server
Installing or Updating a License from a File
Updating a License with a License Code
Activating a License Offline
Revoking a License
Revoking a License Offline
Reference Guide
SQL Grammar
Common SQL Grammar Elements
Data Types
SQL Literals
SQL Language Elements
SQL Tokens, Identifiers, Delimiters
Correlation Identifiers
Table Specification
Column Specification
Query Specification
Definitions Exclusive to Adabas
Data Type Syntax
Table Elemenets Exclusive to Adabas
Adabas Column Clause
Table Column Element
Table Constraint Element
Table Index Element
Column Elements Exclusive to Adabas
Column Constraint Element
Column Index Element
Column Physical Element
Privilege Specification
Grantee Specification
Expressions
Expressions Overview
Processing Order of Operators and Parentheses
Query Expression
Data Conversion
Data Type Priority
Numeric Expressions - Dyadic Operators
Aggregate Function Data Conversion
Predicates
Predicates Overview
BETWEEN Predicate
COMPARISON Predicate
EXISTS Predicate
IN Predicate
LIKE Predicate
NULL Predicate
Search Condition
Primary SQL Commands
ALTER DATABASE
ALTER DATABASE (Adabas Only)
ALTER USER
COMMIT
CREATE CLUSTER (Adabas Only)
CREATE CLUSTER DESCRIPTION (Adabas Only)
CREATE DATABASE
CREATE SCHEMA
CREATE TABLE
CREATE TABLE (Adabas Only)
CREATE TABLE DESCRIPTION (Adabas Only)
CREATE INDEX
CREATE USER
CREATE VIEW
DELETE
DROP CLUSTER (Adabas Only)
DROP CLUSTER DESCRIPTION (Adabas Only)
DROP DATABASE
DROP INDEX
DROP SCHEMA
DROP TABLE
DROP TABLE DESCRIPTION
DROP USER
DROP VIEW
GRANT
INSERT
SELECT
REVOKE
ROLLBACK
UPDATE
SQL Aggregate Functions
SQL String Functions
Quick Links to SQL String Functions
List of SQL String Functions
SQL Date Functions
Quick Links to SQL Date and Time Functions
List of SQL Date and Time Functions
SQL Scalar Functions
SQL Conversion Functions
SQL Numeric Functions
Quick Links to SQL Numeric Functions
List of SQL Numeric Functions
SQL Decision Tree Functions
Quick Links to SQL Decision Tree Functions
List of SQL Decision Tree Functions
SQL Join Syntax
SQL Extended Functions
Quick Links to SQL Extended Functions
List of SQL Extended Functions in {}
List of SQL Extended Functions "A" to "S"
SQL Statistical Functions
Quick Links to SQL Statistical Functions
AVEDEVMEAN(numeric_exp) and AVEDEVMEDIAN(numeric_exp)
COEFVARPCT(numeric_exp) and COEFVARPCTP(numeric_exp)
List of F-V SQL Statistical Functions
SQL Relational Operators
Quick Links to SQL Relational Operators
List of SQL Relational Operators
Special Features of CONNX for DBMS
CONNX Catalog Structure
Schemas
View Description Tables
Table Notation
Base_Tables View
Clusters View
Databases View
Server_Info View
Information_Schema_Catalog_Name View
Schemata View
Tables View
Views View
Columns View
Table_Privileges View
Column_Privileges View
Table_Constraints View
Table_Indexes View
Key_Column_Usage View
Not_Null_Constraints View
View_Table_Usage View
View_Column_Usage View
Constraint_Table_Usage View
Constraint_Column_Usage View
Referential_Constraints View
Users View
Data Types
Relational Databases
OLE DB Data Types
Oracle Data Types
Db2 Data Types
Oracle Rdb Data Types
PostgreSQL Data Types
Non-Relational Databases
Adabas Data Types
DataFlex/PowerFlex Data Types
C-ISAM, DISAM, Micro Focus Data Types
Codasyl DBMS Data Types
IBM Mainframe Data Types
CONNX Data Types
TXT to Longword - Double
Marc BIB Decimal to Timestamp14
TNRD to ZZ
CONNX Data Type Import Codes
Data Type Length Information
Import Codes 1-42
Import Codes 43-79
Import Codes 80-118
Import Codes 119-225
Import Codes 226-265
Import Codes 266-356
Import Codes 357-406
Import Codes 407-443
Import Codes 444-500
CONNX Reserved Keywords and Symbols Reference
Reserved Symbols and Reserved Keywords Beginning with Symbols
"A" to "B" Reserved Keywords
"C" Reserved Keywords
"D" to "J" Reserved Keywords
"K" to "N" Reserved Keywords
"O" to "R" Reserved Keywords
"SA" to "SP" Reserved Keywords
"SQL_" Reserved Keywords
"SQ" to "SZ" Reserved Keywords
"T" to "Z" Reserved Keywords
Error Messages
TCP/IP Codes/States
C-ISAM and DISAM Error Messages
Adabas Error Messages
DB2 Error Messages
SQL States
Distributed Data Management
APPC Primary Return Codes
APPC Secondary Return Codes
ODBC States
VSAM Error Messages
File Open Error Messages
File Read Error Messages
File Write/Rewrite/Delete Error Messages
File Transaction Error Messages
CICS Response2 Error Messages
Started Task VSAM/QSAM/PDS: File Open Error Messages
Started Task VSAM/QSAM/PDS: File Read Error Messages
Started Task VSAM/QSAM/PDS: File Update Error Messages
Started Task VSAM/QSAM/PDS: File Delete Error Messages
Started Task VSAM/QSAM/PDS: File Insert Error Messages
Started Task VSAM/QSAM/PDS: File Close Error Messages
Started Task VSAM/QSAM/PDS: File Locking Error Messages
Started Task VSAM/QSAM/PDS: Memory Allocation Error Messages
Started Task VSAM/QSAM/PDS: Transaction Error Messages
Started Task VSAM/QSAM/PDS: Error Message Diagnostics
InfoNaut - The Query Tool
Introduction to InfoNaut®
Using InfoNaut
Starting InfoNaut
Opening a Connection without a Data Source Name or by Using the CONNX OLE DB Provider
Viewing a List of Previous Connections
Enabling Read/Write Access to Data
Tracing ODBC Calls
Toggling Benchmark Mode
Modifying a CDD through InfoNaut
Opening the CONNX Data Dictionary Viewer
Creating a View
Enabling Text Wrap
Tabbing through Columns
Showing System Tables
Changing the Way DateTime is Shown in the Results Grid
Displaying the Version Number of InfoNaut
Viewing a Uniform SQL Statement
Viewing Relational Database SQL Statements
Refreshing a CDD when Executing a Query
Working with Transactions
Starting and Committing Transactions in InfoNaut
Rolling back a Transaction in InfoNaut
Query Builder
Getting Started
Adding and Removing Objects in Queries
Editing Object Properties
Joining Tables
Selecting Output Fields
Sorting Output Fields
Defining Expression Criteria
Grouping Output Fields
Adding a Sub-query
Adding a Derived Table
Working with Unions
Navigating the Query Tree
Working with Queries
Opening Queries in InfoNaut
Opening SQL Statements in InfoNaut
Saving Queries
Viewing a Query Execution Plan in InfoNaut
Assigning a Maximum Number of Rows in a Query
Viewing Recently Executed Queries
Filtering a query from the InfoNaut - More... window
Adjusting Columns
Assigning Grouping to a Query
Adding parameters to a query
Printing a query
CONNX Embedded SQL for Adabas
Introduction to Embedded SQL for Adabas
Installation procedure
Prerequisites
Windows Quick-Start Guide
Installation on z/OS
Installing CONNX Embedded SQL for Adabas - z/OS
Required and Optional Fields and Files
Installing CONNX Embedded SQL for Adabas - UNIX and Linux
Threading SQL Applications
Introduction to Threading SQL Applications
SQL Context
SQL Threading Models in Adabas SQL Gateway Embedded SQL Clients
Implementing the Threading Models
Client/Server Configuration
Client Configuration
Server Configuration
Client/Server Communication
Programming Guide - General Concepts
SQL Programming - General Concepts
SQL Statements
The SQL Communications Area (SQLCA)
Program Structure
Transaction Logic
Static SQL
Manipulating Data
Dynamic SQL
General Aspects
Non-Select Statements
Select Statements
Using Host Variable Markers
SQL Descriptor Area (SQLDA)
Host Variable Specification
Programming Guide - C
SQL Statements in C
Host Variables in C
Embedding SQL Statements in C
General Rules in C
CONNX Embedded SQL C-string Logic
Error Handling in C
SQL Communication Area (SQLCA) in C
SQL Descriptor Area (SQLDA) in C
Encoding and using the SQLLEN field in the SQLDA
Invocation and Precompiler Options - C
On Windows - C
On UNIX - C
On z/OS - C
Programming Guide - COBOL
Host Variables in COBOL
Embedding SQL Statements in COBOL
General Rules in COBOL
Error Handling in Cobol
SQL Communication Area (SQLCA) in COBOL
SQL Descriptor Area (SQLDA) in COBOL
Invocation and Precompiler Options - COBOL
On Windows - COBOL
On UNIX - COBOL
On z/OS - COBOL
Standard SQL Statements
ALLOCATE SQLCONTEXT
BEGIN DECLARE SECTION
CLOSE
COMMIT
CONNECT
DEALLOCATE PREPARE
DEALLOCATE SQLCONTEXT
DECLARE CURSOR
DESCRIBE
DISCONNECT
END DECLARE SECTION
EXECUTE
EXECUTE IMMEDIATE
GET DIAGNOSTICS
FETCH
INCLUDE
OPEN
PREPARE
ROLLBACK
SELECT (SINGLE ROW)
SET
SET AUTOCOMMIT
SET CONNECTION
USING Clause
WHENEVER
ACEINT Utility
Introduction to ACEINT
Server Connection
Direct SQL Statements
Additional Statements
ACEINT Commands
Batch Processing
Precompiler Error Messages
ACEAPI
ACEAPI Argument Functions
SQL_CTR_BLOCK
SAGColumn
SAGContext
SAGPointer
SQLDA
SQLVAR
Decoding and Encoding SQLLEN
SQLDA Data Types
ACEAPI SQL Functions
SAGQACOM
SAGQCLOS
SAGQCONN
SAGQDEAL
SAGQDECH
SAGQDECL
SAGQDESC
SAGQDISC
SAGQEXEC
SAGQEXIM
SAGQFETC
SAGQGERR
SAGQGRCI
SAGQOPEN
SAGQPREP
SAGQSETA
SAGQSETC
SAGQSETS
SAGQSETT
ACEAPI Utility Functions
SAGQDECO
SAGQENCO
ACEAPI Compilation and Linkage Examples
Adabas Event Replicator for LUW
Introduction
Adabas Event Replicator for LUW Basics
Moving Adabas Data into a Relational Database
Understanding Data Replication with Adabas Event Replicator for LUW
Syncing with a Relational Database
Syncing with Adabas
Adabas Event Replicator for LUW Perspectives
Installation
System Requirements
Prerequisites
Installing Adabas Event Replicator for LUW in a Windows Environment
Installing Linux/UNIX Adabas Event Replicator for LUW Components on the Adabas Event Replicator for LUW Administrator
Installing Adabas Event Replicator for LUW in a Linux/UNIX Environment
Installing Adabas Event Replicator for LUW in a Docker Environment
Building and Extending an Adabas Docker Image
Building the Event Server Image
Installation considerations in an Adabas to Adabas environment
Installing the JMS Server
Default Port Numbers and Firewall Considerations
Replication Components
Uninstalling Adabas Event Replicator for LUW
Using Adabas Event Replicator for LUW
Creating a CDD for Event Replication using the CONNX SQL Engine
Enabling a CDD for Event Replication
JMS Queues/Topics as a Replication Target
JMS Data Format (XML format)
Having Integration Server/EntireX as a Replication Target
Adding a Replication to Adabas Event Replicator for LUW
Mapping Columns to a new Target Table
Adding new Column Mappings
Deleting Column Mappings from a New Target Table
Changing the Column Order in a New Target Table
Changing Source Column Mapping
Changing Target Column Mapping
Clearing Source Column Mapping
Clearing Target Column Mapping
Importing and Exporting Column Mappings
Deleting a Replication
Viewing the Source Table Schema
Configuring Replication and Source Database Servers
Viewing Server Status
Building New Target Database Tables
Dropping and Recreating Target Database Tables
Deploying the Event Replication
Performing an Initial State
Suppressing an Initial State
Undeploying All Replications
Undeploying Selected Replications
Stopping Event Replication
Restarting Event Replication
Starting, Stopping, and Getting Status from the Event Server
Specifics when using Adabas Event Replicator for LUW to Adabas Replication
Preparing an Adabas database for Adabas to Adabas Replication
Creating a CDD for Adabas to Adabas Event Replication using the CONNX Data Integration Suite
Enabling a CDD for Adabas to Adabas Event Replication
Adding an Adabas to Adabas File Copy Replication to Adabas Event Replicator for LUW
Renumbering Target Files
Using the ADAOPR Command Line Utility
Adabas Event Replicator for LUW Menus and Tabs
File Menu
Edit Menu
View Menu
Tables Menu
Servers Menu
Help Menu
Replication Design Tab
Deployed Replications Tab
Server Status Tab
Adabas Event Replicator for LUW Functions
Opening the Event Replication CDD
Mapping SQL Expressions to Target Column
Adjusting Display Column Width
Event Replication Registry Settings
Registry Values
Unix/Linux Environment Variables
Adabas to Adabas Specific Unix/Linux Environment Variables
Data Filtering
Validating Active Replications
Switching from Test to Production
Changing Source Tables
Starting/Stopping the UNIX Message Queue
Starting/Stopping the UNIX Replication Controller
REPCMD Utility
Adabas Event Replicator for LUW Tutorials
Performing a Simple Replication - Adabas to Relational Database
Adding a new Replication and Redeploying
Removing a Replication from Deployment
Manipulating Replication Data
Adabas Event Replicator for LUW Troubleshooting Guide
Troubleshooting Suggestions
Error Messages
User Exits
Troubleshooting Do's and Dont's
ACD Replications
Introduction to ACD Replications
Creating ACD Replications
ACD Output
DataSync
Introduction
System Requirements
Migrating from earlier Versions of DataSync
Product Functions
Installation
Default Port Numbers
Accessing DataSync
Managing Connections and CDDs
User Management in DataSync
History and Database Management Features
Synchronization Methods
Icon Glossary
Settings Menu
Sync Behavior
Sync Options
Data Types
Error Handling
Handling Metadata Case
SMTP Mail from Scheduled Syncs
Global Tasks
Overview Page
Summary Tab
Current Syncs Tab
Historical Syncs Tab
Tables Page
Synchronizing Tables to Target Destination
Transformations Page
Transformations Tab
Synchronizing Transformations to Target Destination
Designing a Transform
Before You Begin
Step 1 - Selecting a Source
Creating a Transformation
Designing a Transformation in Query Builder
The Expression Builder
Step 2 - Selecting a Target Destination
Step 3 - Selecting Sync Behavior
Step 4 - Mapping Columns
Introduction to Column Mapping
Column Mapping to a new Target Table
Column Mapping to an Existing Table
Step 5 - Configuring Indexes
Change Data Capture Transformation
Creating and Syncing the Change Data Capture Transformation
Using the change data capture synchronization in SQL Server Integration Services
Groups Page
Groups Tab
Adding and Editing Groups
Synchronizing Groups to Target Destination
Schedules Page
Schedules Tab
Designing a Schedule
Step 1 - Selecting an Item to Schedule
Step 2 - Defining a Schedule
Step 3 - Select Synchronization Type
Step 4 - Defining Synchronization Tasks
Troubleshooting
Duplicate Keys
Error Messages
Quick Reference Cards
Software AG CONNX Data Integration Suite Help
Quick Reference Cards