Software AG CONNX Data Integration Suite Help
Document Conventions
Online Information and Support
Data Protection
Release Notes
Software AG CONNX Data Integration Suite Help
Critical Changes
Known Issues
Version 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
CONNX for Adabas 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
Overview
Adabas SQL Gateway - z/OS
CONNX for Adabas - z/OS
Prerequsites
Installation
Installing CONNX for Adabas 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 CONNX for Adabas Components
Host/Client Security
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
VSAM
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 an MVS-OS/390 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 OS/390 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
CONNX for VSAM - VSE
Prerequisites
Creating the CONNX Library in a VSAM-Managed Space
Installing the CONNX VSAM Components on a VSE System
Installing the CONNX for VSAM-VSE Components
Required and Optional Entry Fields for VSAM TCP/IP Server Setup
VSAM Objects for CONNX.CICS.SAMPLES
Installing the CONNX CICS Components
Installing the Selected Components on the VSE Target
Installing CONNX for VSAM-VSE
ICS/VSE 2.3 External Security Interface: Prerequisites and Setup
Completing the CICS Customization
Defining the SAS/C 7.00 CICS Extrapartition Data Queues in the CICS DCT
Adding SAS/C Transient Data Queue Definitions to the CICS Startup JCL
Verifying the Installation of CONNX CICS Components
List of Installed Components on the CICS/VSE Partition
Configuration Utility
Overview
Starting the CONNX CICS/VSAM TCP/IP Listener
Stopping the CONNX CICS/VSAM TCP/IP Listener
Setting a CONNX Environment Variable
Changing a CONNX Environment Variable
Changing the Number of the CONNX TCP/IP Port
Converting the CONNX Port Number to the Default
Controling File ENABLE and OPEN Requests
Enabling the Barnard TCP/IP Stack
Displaying the Current CONNX Environment Variables
Uninstalling CONNX for VSAM - VSE
Uninstalling CONNX for VSAM - VSE
Uninstalling CONNX for VSAM - VSE Manually
Uninstalling CONNX for VSE without Shutting Down CICS
CONNX for Adabas - VSE
Overview
Prerequisites
Creating the CONNX Library in an Adabas-Managed Space
Installing the CONNX for Adabas Components on a VSE System
Installing the CONNX for Adabas - VSE Components
Required and Optional Entry Fields for Adabas TCP/IP Server Setup - VSE
Installing the CONNX CICS Components
Installing the Selected Components on the VSE Target
Installing CONNX for Adabas-VSE
Completing the CICS Customization - Adabas
Adding SAS/C Transient Data Queue Definitions to the CICS Startup JCL
Verifying the Installation of CONNX CICS Components
List of Installed Components on the CICS/VSE Partition
Configuration Utility
Overview
Starting the CONNX CICS/Adabas TCP/IP Listener
Stopping the CONNX CICS/Adabas TCP/IP Listener
Setting a CONNX Environment Variable
Changing a CONNX Environment Variable
Changing the Number of the CONNX TCP/IP Port
Converting the CONNX Port Number to the Default
Enabling the Barnard TCP/IP Stack
Displaying the Current CONNX Environment Variables
Uninstalling CONNX for Adabas - VSE
Uninstalling CONNX for Adabas - VSE
Uninstalling CONNX for Adabas - VSE Manually
Uninstalling CONNX for Adabas without Shutting Down CICS
Installing CONNX for Adabas on UNIX
Overview
Installing the CONNX for Adabas Component
Building a Docker Image for the CONNX for Adabas Server Component on a Linux Machine
UNIX Environment Variables
Stopping and Restarting the CONNX for Adabas Server Component
Editing the connxserver Shell Script
Editing the Adabas Server Startup Procedure
Recommended Configurations for CONNX for Adabas
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 OS/390 and MVS/ESA Databases
Host Configuration
DB2/mainframe: Defining the RDBName to DB2 DDF
Configuring VTAM for DRDA via SNU/LU 6.2
Configuring MPTN-specifics 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/MVS or DB2 for OS/390
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
CONNX for Adabas
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: Unix Client
Scenario 4: Oracle and Java
Scenario 5: ASP .NET
Scenario 6: NTIER
Scenario 7: JBOSS and Hibernate on Linux
Scenario 8: JDBC Servlet and Websphere
Scenario 9: JDBC Web Services and Tomcat
Scenario 10: RCI Embedded COBOL
Scenario 11: RCI Embedded C
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
CONNX for Adabas 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
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 MVS 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
MVS-OS/390
Importing from VSAM COBOL FD Files (CICS) - MVS z/OS
Importing from SCT COBOL FD (File Definition) Files - MVS-OS/390
Performing a VSAM SCT DBD (Database Definition) Overlay Import - MVS-OS/390
Importing Remote VSAM Files
Prerequisites and General Information
Importing Remote VSAM Files With and Without Matching Local Files from COBOL FD Files (CICS) - MVS-OS/390
Local and Remote Query Performance
Importing from VSAM COBOL FD files - Started Task (QSAM/PDS)
VSE
Importing from VSAM COBOL FD files (CICS) - VSE
Importing from SCT COBOL FD (File Definition) Files (CICS) - VSE
Performing a VSAM SCT DBD (Database Definition) Overlay Import - VSE
Adding a CONNX VSAM Database CDD Entry Manually
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 - MVS-OS/390 or VSE
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 in to the CONNX REST Server
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
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
Configuring a Database to use the Enterprise Server Service for Database Access
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
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, and RM Cobol 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
InfoNaut Report Writer
Introduction
Opening the InfoNaut Report Writer
Viewing a Preview of a Report in InfoNaut Report Writer
The Basics of the InfoNaut Report Writer Formatting Tools
Working with Field Objects in InfoNaut Report Writer
Introduction to Field Objects
The Summary (Aggregate) Fields Property
Including a SummaryDistinctField in a Report
Including a SummaryFunc in a Report
Including a SummaryGroup in a Report
Including a SummaryRunning in a Report
Including a SummaryType in a Report
Formatting Report Headers
Changing the Name of a Report Header
Changing the Font Size of a Report Header
Changing Font, Back or Line Color
Changing Text Alignment
Rotating Text in a Report Header
Adding an Image
Adding Graphical Lines
Adding and Customizing Borders
The Group Headers Section
Inserting a Group Header
The Detail Section
Page Headers
Changing the Labels in a Page Header
Changing the Font, Font Size, and Font Color in a Page Header
Relocating and Aligning Fields
Resizing Labels in a Page Header
Setting a Default Font
Changing a Field
Adding Rich Text
The Group Footer Section
Creating a Group Footer that Includes an Aggregate Function
The Page Footer Section
Changing the Default Page Format
Adding the Time to a Page Footer
Adding Page Numbers to a Report
Adding a Page Total to a Footer
The Report Footer Section
Adding a Grand Total to the Report Footer
Adding a Check Box to the Report Footer
The Report Preview Tab
Removing the Ruler from the Report Preview Tab
Navigating in a Report Preview
Saving a Report to a File
Using the Find Tool
Toggling between Single and Multiple Page View
Using the Zoom Tool
Printing the Report
Resetting the Report Layout
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
InstantdbSync for Adabas
Introduction
InstantdbSync Basics
Moving Adabas Data into a Relational Database
Understanding Data Replication with InstantdbSync
Syncing with a Relational Database
Syncing with Adabas
InstantdbSync Perspectives
Installation
System Requirements
Prerequisites
Installing InstantdbSync in a Windows Environment
Installing Linux/UNIX InstantdbSync Components on the InstantdbSync Administrator
Installing InstantdbSync in a Linux/UNIX Environment
Installing InstantdbSync in a Docker Environment
Building and Extending an Adabas Docker Image
Building the Event Server Image
Instalation considerations in an Adabas to Adabas environment
Installing the JMS Server
Default Port Numbers and Firewall Considerations
Replication Components
Uninstalling InstantdbSync
Using InstantdbSync
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 InstantdbSync
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 InstantdbSync for Adabas 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 InstantdbSync
Renumbering Target Files
Using the ADAOPR Command Line Utility
InstantdbSync Menus and Tabs
File Menu
Edit Menu
View Menu
Tables Menu
Servers Menu
Help Menu
Replication Design Tab
Deployed Replications Tab
Server Status Tab
InstantdbSync 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
InstantdbSync Tutorials
Performing a Simple Replication - Adabas to Relational Database
Adding a new Replication and Redeploying
Removing a Replication from Deployment
Manipulating Replication Data
InstantdbSync 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
CDD Management
Managing Connections
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