Search
×
Search Results
Search
Search
Filter
Settings will take effect with your next search.
CONNX SQL Engine Documentation
CONNX SQL Gateway Documentation
Toggle navigation
Contents menu
►
CONNX SQL Engine
►
Release Notes
Release Notes for CONNX SQL Engine Version 13.5
Release Notes for Adabas SQL Gateway Version 13.5
Release Notes for Event Replicator for Adabas LUW Version 13.5
ConnecX SQL Engine Introduction
►
Installation Guide
►
Preface
About the Installation Guide
Database Terminology
Installation Overview
CONNX Installation Checklist
Upgrade Installation Checklist
Displaying Your CONNX Version
How CONNX Works
How CONNX JDBC Works
Preparing for Installation
►
Step 1 - Installation Checklist and System Requirements
General Information
Pre-Installation Checklist Procedure
System Requirements Checklist
Verify System Requirements Procedure
CONNX System Requirements
Client and Web Server Requirements
UNIX Client System Requirements
User Application Requirements
CONNX JDBC Client Requirements
CONNX JDBC Server Requirements
Default Port numbers
►
Step 2 - Install CONNX Administrator and CONNX Client
►
Windows Installation
General Information for Installation
CONNX Installation Procedure
►
UNIX Installation
General Information for Installation - UNIX System
CONNX Installation Procedure - UNIX
Completing CONNX Installation for UNIX ODBC Drivers
Completing CONNX Installation for UNIX JDBC Servers
►
CONNX Sample Database Tables
Creating CONNX Sample Database Tables
To create Oracle sample database tables
To build CONNX for DB2 sample tables on the target host via TCP/IP
To build CONNX for DB2 sample database tables on the target host via SNA APPC LU 6.2
To build Enterprise OLE DB sample database tables
To build Enterprise ODBC sample database tables
To build Desktop OLE DB sample database tables
To install Desktop ODBC sample database tables
To build SQL Server OLE DB sample database tables
To build SQL Server ODBC sample database tables
To build Desktop Informix sample database tables
To build Desktop Sybase sample database tables
To build C-ISAM sample database tables
►
Step 3 - Install CONNX JDBC Server and Client
CONNX JDBC General Information
JDBC Resources
CONNX JDBC Server
Starting and Stopping the CONNX JDBC Server on Windows Systems
Activating the CONNX JDBC Router
Connecting to the CONNX JDBC Server
CONNX JDBC Configuration Settings
►
The CONNX JDBC Server on Unix
Starting and Stopping the CONNX JDBC Server on Unix
To edit the JDBC server startup procedure on Unix
►
Step 4 - Install CONNX OpenVMS Server
General Information Regarding the OpenVMS Server
About the OpenVMS User Account and Password
CONNX OpenVMS Installation Procedure
Running Multiple Versions of CONNX on an OpenVMS Server
Testing OpenVMS Server Installation
Testing User Account Privileges
Using Your Telnet Utility - TCP/IP
►
Step 5 - Install IBM Mainframe-Compatible Server
General Information
Outline of Installation Procedures
►
OS/390, z/OS
►
Adabas SQL Gateway (CONNX for Adabas) - z/OS
►
Mainframe Installation
Security
Prerequisites
►
Part 1 - Adabas SQL Gateway (CONNX for Adabas) Installation Procedures
Installation Procedures
►
Part 2 - Installing the Adabas SQL Gateway (CONNX for Adabas) components
Introduction
To verify installation and start the CONNX Listener process
To enable RACF security
To test the user ID/password verification
To stop the CONNX for Adabas Batch Job / Started Task TCP/IP Listener
SAS/C Network Administration
To determine the TCP/IP stack
►
Part 3 - Uninstalling the Adabas SQL Gateway (CONNX for Adabas) components
Uninstalling the components
Manual Steps: Uninstallation
►
Adabas SQL Gateway (CONNX for Adabas) Security
Host / Client Security Overview
►
IMS
Prerequisites for IMS - ODBA
Prerequisites for IMS - DLI
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 CONNX IMS components
►
VSAM
►
CONNX for VSAM - Started Task/Batch
Prerequisites - CONNX for VSAM / QSAM / PDS
►
Part 1: Installation Procedures
To install the CONNX components on the target MVS - OS/390 system
Required and Optional Entry Fields for VSAM TCP/IP Server Setup
DSN Prefix Data Sets
VSAM Objects for CONNX.STASK.SAMPLES
►
Started Task Installation
Started Task installation Procedure
►
Part 2: Installation Verification of CONNX Started Task components
Introduction to installation verification
To verify installation of CONNX Started Task components
To import metadata from COBOL copybooks
To import metadata for the CONNX sample QSAM customer physical sequential file
To import metadata for the CONNX sample customer partitioned data set
To stop the CONNX Started Task/Batch Job TCP/IP Listener
To test CONNX for VSAM query/import functionality against SCT VSAM master files
To test CONNX for VSAM Started Task / Batch Job SCT metadata import functionality
To test the CONNX for VSAM Started Task / Batch Job User ID/Password
►
Part 3: CONNX TSO Configuration Utility
Introduction to the CONNX TSO Configuration Utility
To stop the CONNX Started Task/Batch Job TCP/IP Listener
CONNX TSO Configuration Utility and persistent environment variables
To set a persistent CONNX environment variable
To change a CONNX persistent environment variable
To change the number of the CONNX TCP/IP port persistent environment variable
To convert the persistent CONNX port number to the default
►
CONNX Environment Variables
CONNX Environment Variables: Scope and Precedence
To define unique CONNX environment variables per Started Task/Batch Job
►
CONNX Environment Variable Security
Environment Variable Security vs. Ease of Use
►
Part 4: Starting Multiple Instances of CONNX Started Tasks
Starting multiple instances of CONNX Started Tasks
►
Part 5: Uninstallation Procedures: CONNX Started Task Components
Introduction to uninstallation of CONNX Started Task components
To uninstall the CONNX for VSAM Started Task components
Manual Steps: CONNX for VSAM Started Task Uninstallation
Dataset Security
►
CONNX for VSAM - CICS
Prerequisites - CONNX for CICS/VSAM - OS/390 / z/OS
►
Part 1: Installing the CONNX VSAM Components on an MVS-OS/390 Server
General Information about the CONNX VSAM Server
About the VSAM User Account and Password
To install the CONNX components on the target CICS/VSAM OS/390 / 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
►
Part 2: Installation of the CONNX components
To install the selected components to the OS/390 target
Completing CICS Customization
To change the CICS startup JCL RPL list
Installation Verification of CONNX CICS Components
►
Part 3: CONNX Configuration Utility
To start the IBM CICS TCP/IP sockets interface
To start the CONNX CICS/VSAM TCP/IP Listener
To set a CONNX environment variable
To change a CONNX environment variable
To convert the CONNX port number to the default
To display the current CONNX environment variables
►
Part 5: Uninstallation Procedures for CONNX for CICS/VSAM - OS/390 / z/OS
Running CONNX for VSAM - OS/390 / z/OS Uninstallation Without Shutting Down CICS
VSE
►
CONNX for VSAM - VSE
Prerequisites - CONNX for VSAM - VSE
►
Part 1: Creating the CONNX Library in VSAM-managed Space
Creating the CONNX Library
►
Part 2: Installing the CONNX VSAM Components on a VSE System
General Information about the CONNX VSAM server
To install the CONNX for VSAM-VSE components
Required and Optional Entry Fields for VSAM TCP/IP Server Setup
VSAM Objects for CONNX.CICS.SAMPLES
►
Part 3: Installing the CONNX CICS components
To install the selected components to the VSE target
Summary of the CONNX for VSAM-VSE Installation Procedure
CICS/VSE 2.3 External Security Interface: Prerequisites and Setup
Completing CICS Customization
To define the SAS/C 7.00 CICS extrapartition data queues in the CICS DCT
To add SAS/C transient data queue definitions to the CICS Startup JCL
Installation Verification of CONNX CICS Components
List of Installed Components on the CICS/VSE Partition
►
Part 4: CONNX Configuration Utility
Configuration Utility
To start the CONNX CICS/VSAM TCP/IP Listener
To stop the CONNX CICS/VSAM TCP/IP Listener
To set a CONNX environment variable
To change the number of the CONNX TCP/IP port
To change a CONNX environment variable
To convert the CONNX port number to the default
To control VSAM file Enables/Opens with CONNX Variables SETENABLE and SETOPEN
To enable the Barnard TCP/IP stack
To display the current environment variable(s)
►
Part 5: CONNX for VSAM - VSE: Uninstallation Procedures
Uninstallation Procedures
To uninstall CONNX for VSAM - VSE
Manual Steps: CONNX for VSE Uninstallation
Running CONNX for VSE Uninstallation Without Shutting Down CICS
►
Adabas SQL Gateway (CONNX for Adabas) - VSE
Prerequisites for Adabas SQL Gateway - VSE
►
Part 1: Creating the CONNX Library in Adabas-managed space
Creating the CONNX Library
►
Part 2: Installing the Adabas SQL Gateway Components on a VSE system
General Information about the Adabas SQL Gateway Server
To install the Adabas SQL Gateway - VSE components
Required and Optional Entry Fields for Adabas SQL Gateway TCP/IP Server Setup
►
Part 3: Installing the CONNX CICS components
To install the selected components to the VSE target
Summary of the CONNX for Adabas-VSE Installation Procedure
Completing CICS Customization
To add SAS/C transient data queue definitions to the CICS Startup JCL
Installation Verification of CONNX CICS Components
List of Installed Components on the CICS/VSE Partition
►
Part 4: CONNX Configuration Utility
Configuration Utility
To start the CONNX CICS/Adabas TCP/IP Listener
To stop the CONNX CICS/Adabas TCP/IP Listener
To set a CONNX environment variable
To change the number of the CONNX TCP/IP port
To change a CONNX environment variable
To convert the CONNX port number to the default
To enable the Barnard TCP/IP stack
To display the current environment variable
►
Part 5: Adabas SQL Gateway for VSE: Uninstallation Procedures
Uninstallation Procedures
To uninstall Adabas SQL Gateway - VSE
Manual Steps: Adabas SQL Gateway - VSE Uninstallation
Running Adabas SQL Gateway - VSE Uninstallation Without Shutting Down CICS
►
Step 6 - Install Adabas SQL Gateway
►
Mainframe Installation of Adabas SQL Gateway
Mainframe Installation
►
Unix Installation
General Information
To install the Adabas SQL Gateway server component on a Unix machine
UNIX Environment Variables
To stop and restart the Adabas SQL Gateway
To edit the connxserver shell script
To edit the Adabas server startup procedure in UNIX
►
Installation Tips for the Adabas SQL Gateway (CONNX for Adabas)
Recommended Configurations for the Adabas SQL Gateway (CONNX for Adabas)
Prerequisites - Mainframe
Prerequisites - Windows
Prerequisites - Unix
►
Step 7 - Install C-ISAM, DISAM, RMCobol, Dataflex and Micro Focus Server (for Unix only)
General Information for C-ISAM, DISAM, RMCobol, Dataflex and Micro Focus
To install the CONNX C-ISAM, DISAM, RMCobol, Dataflex or Micro Focus component on a UNIX machine
To edit the C-ISAM, DISAM, RMCobol, Dataflex or Micro Focus server startup procedure
To stop and restart the C-ISAM, DISAM, RMCobol, Dattaflex or Micro Focus server
►
Step 8 - DB2 Host Configuration
►
CONNX and DB2
CONNX DB2 Dynamic SQL Packages
To establish CONNX and DB2 CDD configuration options
►
CONNX DB2 Module Connection Scenarios
Host Configuration for DB2 Admins
►
CONNX and DB2/UDB (Universal Database) - TCP/IP
To establish TCP/IP configuration on DB2 UDB
To verify server TCP/IP settings via DB2 CLP
To verify server TCP/IP settings for Linux
►
CONNX and DB2/UDB - APPC SNA LU 6.2
To verify server APPC/LU 6.2 settings via Control Center
To verify server APPC/LU 6.2 settings via Command Line Processor
To add APPC/LU 6.2 support to the configuration
►
CONNX and DB2/UDB - AIX Servers
To verify server settings for AIX Servers
►
CONNX and DB2/400 Databases
►
Communications Setup and Scenarios for TCP/IP
To establish RDBName configuration
To establish TCP/IP configuration
►
Setting up APPC/LU 6.2 Communications on Target Systems
To set up MPTN configuration
To verify MPTN APPC Controller configuration
To verify IEEE 802.2 DLC configuration
To verify IBMRDB mode description
►
Communications Setup and Scenarios for 3-Tier Communications Server
To set up the IBM Com Server as an MPTN gateway
To define the mode name for DRDA connections
To define or verify the DB2 Transaction Program Name
To set up the IBM Communications Server in an IEEE 802.2 DLC scenario
►
Communications Setup and Scenarios for MS SNA Server
To define the server node
►
Communications Setup and Scenarios for Novell NetWare for SAA 4.0
To set up the Novell NetWare in an IEEE 802.2 DLC scenario
To configure the node in APPN/APPC for Novell NetWare
To configure Data Link Adapters
To define a peer link
To define a Partner LU 6.2
To define a Transaction Program Name
To define a mode
►
Communications Setup and Scenarios for 2-Tier SNA Client Configuration
To set up 2-tier SNA client configuration for Attachmate - MPTN
To set up 2-tier client configuration for Attachmate - IEEE 802.2
To set up 2- tier SNA client configuration for RUMBA MPTN
To set up 2- tier SNA client configuration for RUMBA IEEE 802.2 DLC
►
CONNX and OS/390 and MVS/ESA Databases
►
Host Configuration
To define the RDBName to DB2 DDF
To configure DDF for TCP/IP
To configure VTAM for DRDA via SNA/LU 6.2
►
Configuring MPTN-specific VTAM Information on the Host
To create an SNATCP macro
To verify correct IP address and host name
►
DB2 Communications Database Setup
Setup
►
APPC Connection Scenarios - 3-Tier Communications Server Configuration
To connect to a DB2/MVS or DB2 for OS/390
To connect to the target DB2 region via CONNX
►
DB2 Bibliography and Reference Sources
References and Sources
►
Step 9 - Post-Installation Checklist
General Information Regarding the Post-Installation Checklist
Post-Installation Checklist - C-ISAM, DISAM, Micro Focus
Post-Installation Checklist - CONNX JDBC Server
Post-Installation Checklist - CONNX Upgrades
Post-Installation Checklist - DataFlex
Modifying the CONNX Registry File Settings for DataFlex Year Digits
Post-Installation Checklist - DB2
Post-Installation Checklist - IBM Mainframe-compatible Server
Post-Installation Checklist - Adabas SQL Gateway (CONNX for Adabas)
Post-Installation Checklist - Informix data sources
Post-Installation Checklist - Oracle
Post-Installation Checklist - POWERflex
Post-Installation Checklist - OLE DB and ODBC-compliant Data Sources
Post-Installation Checklist - OpenVMS Server
Editing the OpenVMS Site-Specific Startup Command
Post-Installation Checklist - Sybase data sources
►
Troubleshooting Post-Installation Procedures
Testing a Database Connection
Reviewing the Minimum OpenVMS Quotas Procedure
Minimum Quota Values for RMS, Rdb, and DBMS Databases
Converting Data Dictionaries
Troubleshooting Connection Problems
Troubleshooting with RMS, Oracle Rdb, and Codasyl DBMS Databases
Troubleshooting with TCP/IP and OpenVMS
Pinging the OpenVMS Server - TCP/IP
Reviewing CONNXSETUP.LOG Using FTP - TCP/IP
►
CONNX JDBC Sample Application
CONNX JDBC Sample Application
Using the CONNX JDBC Sample Application in a Microsoft Windows Environment
Using the CONNX JDBC Sample Application in a non-Windows Environment
Running the CONNX JDBC Sample Application
To choose an Output Type
To choose a Query Type
To create a one-parameter query
To create a two-parameter query
Navigator Bar
►
CONNX JDBC Sample Applet
Running the CONNX JDBC Sample Applet
To run the CONNX JDBC Applet
►
Step 10 - License Registration
General Information Regarding License Activation
License Activation
Offline License Activation
Offline License Revoke
Moving Licenses from one License Server to Another
Emergency License Activation
Frequently Asked Questions about Licenses
►
Silent CONNX Client Installation
Introduction to Silent Client Installation
Creating the CONNX Client Installation Record File Procedure
To Create a Shortcut to CONNX Setup
Running the Silent CONNX Client Installation Procedure
►
Glossary
Terms and Abbreviations
►
Technical Support
Technical Support
►
Copyrights and Trademarks
Copyrights and Trademarks
Planning Guide
►
Introduction
►
CONNX Architecture
View from 10,000 Feet
A Typical Architecture Example
►
CONNX Planning
General Planning Concepts
Component Configuration
►
Service Configuration
Estimating Throughput Requirements
Estimating Component Requirements
Estimating Server Requirements
Estimating License Requirements
Planning Component Installation
Planning the SQL Catalog
Scalability Concerns
►
CONNX Administration
General Administration Concepts
Development and Testing
Deployment
►
CDD Management
General CDD Management Concepts
Controlling Access
Updating Indexes
►
CONNX Performance
General Performance Concepts
Query Tuning
CPU
Memory
Input and Output
►
CONNX Scenarios
General Scenario Information
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
Scenario 8: JDBC Servlet and Websphere
Scenario 9: JDBC Web Services and Tomcat
Scenario 10: RCI Embedded COBOL
Scenario 11: RCI Embedded C
►
Appendix A - Technical Support
Technical Support
►
Appendix B - Trademarks and Copyrights
Trademarks and Copyright Page
►
InfoNaut - The Query Tool
►
InfoNaut - The CONNX Query Tool
InfoNaut Basics
To use InfoNaut
To open a connection without a data source name
To open a connection using the CONNX OLE DB Provider
To view a list of previous connections
To change the size of the query text box
To enable read/write access to data
To trace ODBC calls
To enable Benchmark Mode
To modify a CDD through InfoNaut
To open the CONNX Data Dictionary Viewer
To create a view
To enable text wrap
To tab through columns
To show system tables
To change the display format for DateTime results
To display the version number of InfoNaut
To view a uniform SQL statement
To view relational database SQL statements in InfoNaut
To refresh a CDD when executing a query
►
Working with Transactions
To start and commit a transaction in InfoNaut
To rollback a transaction in InfoNaut
►
Query Builder
Getting started
Opening the Query Builder
Adding an object to the query
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
To open queries in InfoNaut
To open CONNX InfoNaut Queries and SQL Script files
To open SQL statements in InfoNaut
To save queries
To view a query execution plan in InfoNaut
To assign a maximum number of rows in a query
To view recently executed queries
To adjust columns
To assign grouping to a query
To add parameters to a query
To filter a query from within the More... pane
►
InfoNaut Report Writer
Introduction
►
Creating a Report with InfoNaut Report Writer
To open the InfoNaut Report Writer
To view a preview of a report in InfoNaut Report Writer
►
Using the InfoNaut Report Writer Formatting Tools
The Basics
►
Working with Field Objects in InfoNaut Report Writer
Introduction to Field Objects
Summary (Aggregate) Fields Property
To include a SummaryDistinctField in a report
To include a SummaryFunc in a report
To include a SummaryGroup in a report
To include a SummaryRunning in a report
To include a SummaryType in a report
►
Formatting Report Headers
Report Headers
To change the name of a report header
To change the font size used in a report header
To change the font color
To change the back color
To change the alignment of text
To rotate text in a report header
To add a graphic
To add graphical lines
To change the line color
To add and change the color of a border
►
Group Header Section
Group Headers
To insert a group header
►
Detail Section
Page Headers
To change the labels in a page header
To change the font, font size, and font color in a page header
To relocate and align fields
To resize labels in a page header
To set a default font
Detail Basics
To change the fields
To add Rich Text
►
Group Footer Section
Group Footers
To create a group footer that includes an aggregate function
►
Page Footer Section
Page Footers
To change the default page format
To add the time to a page footer
To add page numbers to a report
To add a page total to a footer
►
Report Footer Section
Report Footers
To add a grand total to the report footer
To add a checkbox to the page footer
►
Report Preview Tab
Report Previews
To remove the ruler from the Report Preview tab
To move from the beginning to the end of the report
To save the report to a file
To use the Find tool
To view single or multiple pages
To use the Zoom tool
To print the report
►
Starting Over
To reset the report layout
►
Printing
To view a single or multiple pages
To use the zoom tool
To move from the beginning to the end of the data
To print the results of an executed query
►
Technical Support
Technical Support
►
Trademarks and Copyrights
Trademarks and Copyright Page for InfoNaut
►
User Reference Guide
►
Chapter 1 - Preface
Introduction
The CONNX Data Dictionary (CDD)
The CONNX ODBC Driver
The CONNX JDBC Driver
The CONNX OLE RPC Server
The CONNX Host Data Server (RMS, Oracle Rdb, DBMS, VSAM, and C-ISAM only)
CONNX System Requirements
Unix Client System Requirements
CONNX Client and Web Server Requirements
CONNX Components
CONNX Compatibility
►
Chapter 2 - Working with Database Objects in CONNX
►
CONNX Basics
►
Working with CDDs
Creating CDDs
To create a CDD
Importing Existing Table Definitions
To open an existing CDD
To save a data dictionary entry
To use the CONNX Find feature
To cut a record in the CDD
To copy a record in the CDD
To paste a record in the CDD
To clone a database in the CDD
To use the CONNX Browse button (RMS only)
Filtering CONNX Data Types
To view an index
To refresh an index
Importing from the command line
►
CONNX Catalog Support
Catalog Support Defined
To enable CONNX database catalog support
►
Updating Statistics in the CONNX Data Dictionary
To update statistics in the CONNX Data Dictionary Manager
►
Adding a Database Connection
Adding a database connection
►
Linking Master CONNX CDDs
To link child dictionaries in the CONNX Data Dictionary Manager
To remove a child CDD in the CONNX Data Dictionary Manager window
To prevent a CDD from being linked as a child
►
Viewing Database Information by Database, Object, or Owner
To view database information by database name
To view database information by owner
To view database information by object name
►
CONNX Adapter: Enterprise and Database Modules
CONNX Adapter: OLE DB and ODBC Data Sources
ODBC Data Source Names Used with Multiple Users
►
CONNX Adapter: OLE DB Data Sources
OLE DB Data Sources: Enterprise Modules
To import an existing table from an OLE DB-compliant data source using the CONNX Adapter
To import an existing table from an OLE DB-compliant provider data source using the Desktop
►
CONNX Adapter: ODBC Data Sources
ODBC Data Sources: Desktop Modules
To import an existing table from an ODBC-compliant provider data source using the CONNX Ad
To import an existing table from an ODBC-compliant data source object using the CONNX Adapt
►
CONNX and Adabas
Adabas SQL Gateway Import Types
Limitations and Suggestions
►
Import from Natural
Introduction
To import from Adabas files (Natural)
►
Extract Files
►
Windows
To generate an OpenSystems SYSOBJH extract file
►
Mainframe
To generate a Mainframe SYSOBJH extract file
►
Import from Adabas Files
To import Adabas FDT (read field definitions)
►
Import from Dynamic DDL
To import from Dynamic DDL files
►
Adabas ADASCR Security
Using ADASCR Security with CONNX
Code Pages
►
CONNX and C-ISAM, DISAM, and Micro Focus
C-ISAM, DISAM, and Micro Focus Imports
►
C-ISAM, DISAM, and Micro Focus Manual Imports
Creating C-ISAM, DISAM, or Micro Focus Databases Manually
Creating CDD entries manually
To build a C-ISAM, DISAM, or Micro Focus database manually
To create a C-ISAM, DISAM, or Micro Focus table entry manually
To add columns to a C-ISAM, DISAM, or Micro Focus file entry
To refresh an index
►
C-ISAM, DISAM, and Micro Focus COBOL Imports
To import from C-ISAM, DISAM, or Micro Focus COBOL FD files
►
C-ISAM, DISAM, and Micro Focus Text File Imports
C-ISAM, DISAM, or Micro Focus Text File Import
C-ISAM, DISAM, or Micro Focus Table Import
C-ISAM, DISAM, or Micro Focus VIEW Text File Import Specification
To import tables or views from a C-ISAM, DISAM, or Micro Focus text file import specification
►
Micro Focus Sequential Files
To access a sequential file in Micro Focus
►
CONNX and DataFlex, RMS, and DBMS Databases
To import from a VAX or Alpha CDD repository
To import from Powerhouse PDL (Powerhouse Definition Language) files (RMS only)
To import from RMS COBOL FD (File Definition) files (RMS only)
To import from RMS SCT COBOL FD (File Definition) files
To perform an RMS SCT DBD (Database Definition) Overlay Import
To import an existing DIBOL table definition (RMS only)
To import existing formatted DDL (Data Definition Language) table definitions
To import from RMS VAX Basic MAP files
►
RMS Text Files
RMS Text File Import Specification
RMS View Text File Import Specification
To import tables or views from an RMS text file import specification
Creating CDD Entries Manually
To create an RMS table entry manually (CDD)
Creating RMS Databases Manually
To build an RMS database manually
To add columns to an RMS file
To view an index
►
DataFlex Tables
Importing DataFlex Table Definitions
To import existing DataFlex table definitions
►
POWERflex Tables
Importing POWERflex Table Definitions
To import existing POWERflex table definitions
►
Codasyl DBMS Tables
To import existing Codasyl DBMS tables
To include subschemas with Codasyl DBMS table imports
►
CONNX and DB2
CONNX DB2 Module
Import and Connect-Time Security Requirements
How the CONNX DB2 Module Maps ODBC to DRDA Isolation Levels
►
DB2 OS/400
Use of OS/400 Remote Commands
Dynamic SQL Package Security
AS/400 Plug-n-Play Mode
►
DB2 and DB2 for MVS
DB2 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
Dynamic SQL Package Security
►
CONNX and DB2 CDD Settings
To import existing DB2 tables, views, and stored procedures using TCP/IP
To import existing DB2 tables, views, and stored procedures using SNA protocol
CONNX DB2 Dynamic SQL Packages
To establish CONNX and DB2 CDD configuration options
►
CONNX and Informix
CONNX Informix Data Module
To import tables from an Informix ODBC provider data source
►
CONNX and Oracle
Importing Oracle Database Tables
To import an existing Oracle database table
Importing Oracle Rdb Database Tables
To import an existing Oracle Rdb table
►
CONNX and PostgreSQL
Importing PostgreSQL Database Tables
►
CONNX and SCT Import Rules
CONNX and SCT Import Rules
►
SCT DBD Overlay Conventions
Overlay Conventions
►
CONNX and SQL Server
CONNX SQL Server Module
ODBC Data Source Names Used with Multiple Users in SQL Server 7.0 and 2000
To import a SQL Server database using an OLE DB Provider
To import objects from a SQL Server ODBC provider data source
►
CONNX and Sybase
CONNX Sybase Data Module
To import tables from a Sybase ODBC-compliant data source
CONNX and VSAM
►
CONNX and VSAM - MVS-OS/390
To import from VSAM COBOL FD files (CICS) - MVS z/OS
To use the CONNX Integrated Logon with an ODBC-compliant application
To import from SCT COBOL FD (File Definition) files - MVS-OS/390
To perform a VSAM SCT DBD (Database Definition) Overlay Import
►
Importing Remote VSAM Files
Background and Prerequisites
To import remote VSAM files without matching local files from COBOL FD files (CICS) - MVS-OS/390
To import remote VSAM files with matching local VSAM files from COBOL FD (File Definition) files (CICS) - MVS-OS/390
Local and Remote File Query Performance
►
CONNX and VSAM - QSAM/PDS
To import from VSAM COBOL FD files - Started Task
►
CONNX and VSAM - VSE
To import from VSAM COBOL FD (File Definition) files (CICS) - VSE
To use the CONNX Integrated Logon with an ODBC-compliant application
To import from SCT COBOL FD (File Definition) files (CICS) - VSE
To perform a VSAM SCT DBD (Database Definition) Overlay Import
Creating CONNX VSAM Database CDD Entries Manually
To add a CONNX VSAM database CDD entry manually
►
VSAM File Import Configuration Parameters
Configuration Parameters - IMPORTALTINDEXES and FASTPATHMATCH
To disable the IMPORTALTINDEXES option
To enable the IMPORTALTINDEXES configuration option
To configure the FASTPATHMATCH configuration option
VSAM Text File Import Specification
VSAM View Text File Import Specification
To import tables or views from a VSAM text file import specification - MVS-OS/390
To import tables or views from a VSAM text file import specification-VSE
►
CONNX and IMS
Importing IMS files
Importing IMS files using COBOL FD (File Definition) files
Importing IMS files using Index text specification file
IMS Packed Decimal Data Fields
►
CONNX and Redshift
Importing Redshift Database Tables
►
Chapter 3 - CONNX Security
CONNX Security Overview
Secure Access to Data on Multiple Platforms
Adding Security to a Data Dictionary Entry
To add security to tables and columns
To delete an existing security restriction
To identify the server name
To override the default server name (RMS only - for multiple servers)
►
Users and Groups
CONNX Users and Groups
To add a new user
To change a user password
To add a new group
To add new users to a group
To remove users from a group
►
CONNX Embedded Logon
To use the CONNX Embedded Logon
►
Security for CONNX Views
To disable the creation of views
►
Database Account Management
Accessing multiple databases
To modify user names and password
To change database owner name
Disabling integrated security
►
Application Management
Managing Applications
To add an application
To remove an application
To remove a database from use within an application
►
Maximum CDD Security
Maximum security
To establish the maximum CDD security option
►
CONNX and VSAM: CICS Server-Side Security
CICS/VSAM Host / Client Security Overview
CONNX TCP/IP Listener and Server Security
Example of CICS Surrogate UserID Creation and CONNX Login
►
Chapter 4 - 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 Data Source Using a Provider String
To configure the data source name for the CONNX ODBC driver
To configure an existing data source
To link to a data source using Microsoft Access 2003
►
Connecting to the CONNX ODBC Driver
To open a connection to the CONNX ODBC Driver
CONNX ODBC Connection String Parameters
►
Chapter 5 - CONNX OLE DB Provider - Windows
OLE DB Provider Definition
CONNX OLE DB Conformance
Configuring the Data Source
Features of the OLE DB Provider
►
Configuring the OLE DB Data Source
To create an OLE DB Provider connection object
►
Chapter 6 - CONNX JDBC Driver
JDBC Driver Definition
The CONNXJDBC.LOG file
CONNX JDBC Configuration Settings
CONNX JDBC Router
JDBC Data Type Conversions
►
CONNX JDBC Architecture
JDBC Driver Architecture
CONNX JDBC Driver Architecture
CONNX JDBC Java Application Architecture
CONNX JDBC Java Applet Architecture
CONNX JDBC Java Applet Architecture with Router
CONNX JDBC Java Servlet Architecture
►
Connecting to a JDBC Data Source
Connecting to a Data Source
Registering the Data Source Name
To add a new data source name for the JDBC Driver
Setting the Classpath
►
Loading the JDBC Driver
To load and register the CONNX JDBC Driver
Opening a connection to the CONNX JDBC Driver
CONNX JDBC Connection String Parameters
►
Starting the CONNX JDBC Server
CONNX JDBC Server Definition
To start the standalone server for Windows
►
CONNX JDBC Conformance
Conformance
CONNX JDBC Error Messages
►
JDBC Interfaces Supported by CONNX
JDBC Interfaces supported by CONNX
Array
Blob
CallableStatement
Clob
Connection
DatabaseMetaData
Driver
InputStream
PreparedStatement
Ref
ResultSet
ResultSetMetaData
SQLData
SQLInput
SQLOutput
Struct
Statement
►
Chapter 7 - CONNX .NET Data Provider
General Information
To add a reference to the CONNX .NET Data Provider
To specify a name space for the added reference
CONNX .NET Data Provider Object Model
►
Class Tables
Class : CNXCommand
Class : CNXConnection
Class : CNXDataAdapter
Class : CNXDataReader
Class : CNXDbType
Class : CNXException
Class : CNXParameter
Class : CNXParameterCollection
Class : CNXTransaction
Class : CNXTransactionCapabilities
►
Chapter 8 - CONNX Unicode Support
Unicode support
►
Chapter 9 - CONNX OLE RPC Server
CONNX OLE RPC Server
CONNX.Connect
►
Chapter 10 - CONNX Remote Procedures and Remote Commands
CONNX Remote Procedures
To build a remote procedure
Execution of OS/400 Remote Commands via CONNX and DB2
To execute OS/400 remote commands via CONNX
Executing a Remote Procedure Call via SQL
►
Chapter 11 - SQL Grammar
SQL Grammar Introduction
►
Common SQL Grammar Elements
What are Common SQL Grammar Elements?
Character
Comments
Digit
Data Types
Data Type Conversion
►
SQL Literals
Binary Literal
Character Literals
Date Literals
Numeric Literals
Time Literal
Timestamp Literal
►
SQL Language Elements
SQL Tokens
Identifiers
Delimiters
Correlation Identifiers
Table Specification
Column Specification
Query Specification
Table Name Definition (Adabas only)
Cluster Specification (Adabas only)
Cluster Name Definition (Adabas only)
Adabas File Definition
SQL Data Type
Adabas Data Type
►
Table Elements (Adabas Only)
Adabas Column clause
Table Column Element
Table Constraint Element
Table Index Element
►
Column Elements
Column Constraint Element
Column Index Element
Column Physical Element
Privilege Specification
Grantee Specification
►
Expressions
Expressions
Operator Precedence
Query Expressions
►
Data Conversion
Data Type Priority
Numeric Expressions - Dyadic operators
Aggregate Function Data Conversion
►
Predicates
What are Predicates?
Between Predicate
Comparison Predicate
Exists Predicate
In Predicate
Like Predicate
Null Predicate
Search Condition
►
Primary SQL Commands
ALTER DATABASE
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
AVG
COUNT
MAX
MIN
SUM
►
SQL String Functions
ASCII(string_exp)
BIT_LENGTH(string_exp)
CHAR_LENGTH(string_exp)
CHARACTER_LENGTH(string_exp)
CHR(code)
CONCAT(string_exp1, string_exp2)
DIFFERENCE(string_exp1, string_exp2)
HEX(numeric_expr)
INSERT(string_exp1, start, length, string_exp2)
LCASE(string_exp)
LEFT(string_exp, count)
LENGTH(string_exp)
LOCATE(string_exp1, string_exp2[, start])
LTRIM(string_exp)
OCTET_LENGTH(string_exp)
POSITION(string_exp IN string_exp)
REPEAT(string_exp, count)
REPLACE(string_exp1, string_exp2, string_exp3)
RIGHT(string_exp, count)
RTRIM(string_exp)
SUBSTRING(string_exp, start, length)
SOUNDEX(string_exp)
SPACE(count)
TRIM(string_exp)
UCASE(string_exp)
►
SQL Date Functions
CURRENT_DATE()
CURRENT_TIME()
CURRENT_TIMESTAMP()
CURDATE()
CURTIME()
DAYNAME(date_exp)
DAYOFMONTH(date_exp)
DAYOFWEEK(date_exp)
DAYOFYEAR(date_exp)
EXTRACT(extract-field FROM extract-source)
HOUR(time_exp)
MINUTE(time_exp)
MONTH(date_exp)
MONTHNAME(date_exp)
NOW()
QUARTER(date_exp)
SECOND(time_exp)
TIMESTAMPADD(interval, integer_exp, timestamp_exp)
TIMESTAMPDIFF(interval, timestamp_exp1, timestamp_exp2)
►
WEEK functions
WEEK functions-summary
WEEK(date_exp)
WEEKE1(date_exp)
WEEKE2(date_exp)
WEEKS(date_exp)
YEAR(date_exp)
►
SQL Scalar Functions
CONNXCDD()
CONNX_API_VERSION( [catalog_exp] )
CONNX_SERVER_VERSION( [catalog_exp] )
CONNX_VERSION()
DATABASE()
GETCURSORNAME()
NTUSERNAME()
USER()
XPUSERNAME()
►
SQL Conversion Functions
CASTASCONNXTYPE( CONNXTypeName, ColumnName, [[Precision] [, Scale]] )
CNXRAWCONVERT( CONNXTypeName, ColumnName [[,Offset] [,Length][,Precision] [, Scale] [,Codepage]] )
CONVERT(exp, datatype)
►
SQL Numeric Functions
ABS(numeric_exp)
ACOS(float_exp)
ASIN(float_exp)
ATAN(float_exp)
ATAN2(float_exp1, float_exp2)
CEILING(numeric_exp)
COS(float_exp)
COT(float_exp)
DEGREES(numeric_exp)
EXP(float_exp)
FLOOR(numeric_exp)
LOG(float_exp)
LOG10(float_exp)
MOD(integer_exp1, integer_exp2)
PI()
POWER(numeric_exp, integer_exp)
RADIANS(numeric_exp)
RAND(integer_exp)
ROUND(numeric_exp, integer_exp)
SIGN(numeric_exp)
SIN(float_exp)
SQRT(float_exp)
TAN(float_exp)
TRUNCATE(numeric_exp, integer_exp)
►
SQL Decision Tree Functions
CNXNAME (string_exp, nameformat_exp, nameoutput_exp)
CNXPREFERENCE( likeclause_count, like_clause_1, like_clause_2, ... , criteria1_exp, value1_exp, criteria2_exp, value2_exp, ... )
IF (criteria_exp, then_exp, else_exp)
IFEMPTY(exp1, exp2)
IFNULL(exp1, exp2)
NULLIF(exp1, exp2)
SWITCH(criteria_exp, compare1_exp, return1_exp, compare2_exp, return2_exp,...,[default_return_exp])
DECODE(criteria_exp, compare1_exp, return1_exp, compare2_exp, return2_exp,...,[default_return_exp])
COALESCE(exp1, exp2, ...)
►
SQL Join Syntax
Inner Join
Outer Join
►
SQL Extended Functions
{adabasfdtfname adabas_fdt_file_name}
{adabasfilename adabas_file_name}
{bsearchtempkey}
{autobulkinserton}
{autobulkinsertoff}
{caseinsensitive}
{casesensitive}
{fn enableservertrace}
{fn disableservertrace}
{fn flushopenfilecache}
{fn refreshcdd}
{fn updatestatistics}
{fn setfilename
,
}
{forceadanonukey}
{forceadanukey}
{forcetempkey}
{hashtempkey}
{ignoretimestampfraction}
{killstatement}
{maxrows #}
{nativesql}
{nativetypemode}
{nomaxrows}
{nopassthrough}
{nosqloptimize}
{nooptimizeoperator}
{notempkey}
{passthrough
}
{recordmismatch}
{serverlist} (Adabas only)
{setadapassword}
{showsessions}
{statistics}
{startconnectionpooling}
{startwiththistable}
{stopconnectionpooling}
{transactmode readonly}
{transactmode readwrite}
{usekey}
autocounter()
BIBXREF(field, prefix, index)
cnxcurrentconnections()
cnxcurrentstatements()
cnxpeakconnections()
cnxpeakstatements()
cnxtotalconnections()
cnxtotalstatements()
CNXFORCECHAR(binary_exp)
CNXFORCEBINARY(string_exp)
CNXSLEEP(numeric_exp)
ILIKE
SLIKE
cnxclientdefaultcodepage()
cnxclientcodepage()
►
SQL Statistical Functions
Introduction: Statistical Functions
AVEDEVMEAN(numeric_exp)
AVEDEVMEDIAN(numeric_exp)
COEFVARPCT(numeric_exp)
COEFVARPCTP(numeric_exp)
FIRST(value_exp)
KTHLARGEST(numeric_exp, K_numeric_exp)
KTHSMALLEST(numeric_exp, K_numeric_exp)
KURTOSIS(numeric_exp)
KURTOSISP(numeric_exp)
LAST(value_exp)
MEDIAN(numeric_exp)
MIDDLE(value_exp)
MODE(value_exp)
MULTIMODALCOUNT(value_exp)
MULTIMODALOCCUR(value_exp)
QUANTILE(numeric_exp, Q_numeric_exp)
QUARTILE1(numeric_exp)
QUARTILE3(numeric_exp)
RANGE(numeric_exp)
RMSERROR(numeric_exp)
RMSERRORP(numeric_exp)
SKEWNESS(numeric_exp)
SKEWNESSP(numeric_exp)
SORTFIRST(value_exp)
SORTLAST(value_exp)
SORTMIDDLE(value_exp)
STDDEV(numeric_exp)
STDDEVP(numeric_exp)
TRIMEAN(numeric_exp)
VARIANCE(numeric_exp)
VARIANCEP(numeric_exp)
►
SQL Relational Operators
ALL
AND
ANY
BETWEEN
EQUAL =
GREATER THAN >
GREATER THAN OR EQUAL >=
IN
IS NOT NULL
IS NULL
LESS THAN <
LESS THAN OR EQUAL <=
LIKE
NOT
NOT EQUAL <>
OR
UNION
UNION ALL
►
Special Features of CONNX for DBMS
REVERSE FETCH
►
Chapter 12 - 64bit Support
Native 64bit Application Support
Native 64bit Data Source Support
Configuring 64bit and 32bit components
64bit to 32bit ODBC and OLE DB Bridge
64bit and 32bit port numbers for windows services
Location of DLLs on 64bit Windows
Limitations of 64bit Data Access on Windows
►
Chapter 13 - Enterprise Server Service
Enterprise Server Service Component
To enable the CONNX Enterprise Service
►
Chapter 14 - CONNX Configuration Settings
What are Configuration Settings?
Alphabetical links to Configuration Settings
►
Configuration Settings - Numeric through C
2DIGITYEARS
ADA_DEBUG_TRACE_MASK
ADA_FIELDNULLASZERO
ADA_ISNNAME
ADA_LOCKDONTWAIT
ADA_NATURALBYTEASBIT
ADA_NOQUALIFYBINARY
ADA_RESPECT_ISN_ON_INSERT
ADA_SECURITY
ADA_TABLENAME
ADA_WAITTIME
ADA_WFIELDASBYTES
ALLOWDATATYPECHANGES
ALLOWMIXEDCASEPASSWORDS
ALLOWMIXEDPWD
ALLOWNULLINCHAR
AUTOBULKINSERT
BULKOPERATIONCOUNT
ASYNCACCESS
BASE1INDEX
CASESENSITIVE
CERTPATH
CHARASVARCHAR
CLIENT_LOCALE
CNXBARNARD
CNXBATCHBUFFER
CNXCONNECTBACK
CNXDECNETTASK
CNXDIR
CNXHASH
CNXKBAUTHORIZE
CNXLOCALIP
CNX_LIBRARY_PATH
CNXLISTENER
CNXMUALPHA
CNXNOPREAUTHORIZE
CNXNOPOST
CNXNOQIO
CNX_NO_TIMER
CNXOLDLICENSE
CNX_PASS_TICKETS
CNXPOSTSERVERNAME
CNXRUNPORT
CNXSELECT
CNXSOCKETTIMEOUT
CNXTCPIPBUFFER
CNXTRUEUCX
CNXUSEMBX
COBOL_COMP_BYTESTEP
COLLATINGSEQUENCE
COMPRESS
COMMITCOUNT
CONNECTIONPOOLING
CONNECTIONPOOLINGTIMEOUT
CONNECTPORT
CONNECTRETURNPORT
CONNECTTIMEOUT
CONNECTTRIES
CONNXREG_DISPLAY_OPTS
►
Configuration Settings - D through E
DATAFLEXMODE
DATAFLEXSTRUCTUREUPDATE
DB_LOCALE
DEBUG
DEBUGLEVEL
DEBUGLOC
DEBUGVERBOSE
DEFAULTCOBOLCHAR
DEFAULTCOBOLDEC
DEFAULTCOBOLINT
DEFAULTONDEMAND
DEFAULTMUPE
DEFAULTPORT
DEFAULTVMSCREATEPATH
DOWNGRADELOCK
EMPTYSTRING
ENCRYPT
ENTIRENETWORK
ENTIRENETWORKMULTIFETCHFIXED
ESQNULL
►
Configuration Settings - F through L
FASTMEMORYSIZE
FASTPATHMATCH
FILTERDATATYPES
FIXMUPENAME
FORCEADANUKEY
FORCECLIENTSORT
FORCETRANSACTIONS
FORCEVERSION
FREEFORMCOBOLFD
FUJITSUCOBOLFD
HASH
HONORDBIDFILEID
HUFFMANPOWERFLEX
IGNORECOMMITONREAD
IMPORTFLATONLY
IMPORTGROUPNAMES
IMPORTOVERWRITE
IMPORTPREFIX
IMPORTPROCEDURES
IMPORTVIEWS
INFORMIXDIR
JDBCCONNECTIONPOOLING
JDBCCONNECTIONPOOLINGTIMEOUT
JOINCACHEMULTIPLIER
JOINCACHESIZE
JOINCOUNT
KEEPHYPHENS
KEEPGROUPS
LOGLOC
LISTENQUOTA
LOWERCASEONLY
►
Configuration Settings - M through Q
MAPFILEINCREMENTSIZE
MAXROWSCOMPARED
MAXROWSFETCHED
MAXROWSFETCHEDFAIL
MAXSOCKET
MISMATCHON
MIXEDCASEGRAMMAR
MULTIFETCH
MUPESUPPORT
NLS_LANG
NOLOGO
NOPROCEDURES
NOVIEWS
NOWAIT
NUMBERCONVERT
OLEINIT
OLDERVERSION
OPATTRIBUTES
OPDONTCALL
OPMAXCMDID
OPMAXHOLD
OPMAXISN
OPNONACTIVITY
OPREADONLY
OPSEARCHTIME
OPTIMEOUT
ORACLEBULKMODEDISABLEFLAG
ORACLE_HOME
PACKETSIZE
PEEKMESSAGE
PERFORMRANGECHECKS
PORT
PRECISIONOVERRIDE
QUADWORDDOUBLE
►
Configuration Settings - R through Z
READTIMEOUT
REISSUEOP
REPLACEPREFIX
RMSPADDEDNONULLS
SBCCSID
SCTLOGICAL
SETENABLED
SETOPEN
SHARECONNECTIONCOUNT
SHARECONNECTIONS
SOCKETPAUSE
STRICTCONVERSIONRULES
SUBQUERYROWESTIMATE
SUPERDESCRIPTORASFIELD
TABLECACHE
TCPIPDEBUG
TCPSIZE
TEMPPATH
TEXTDBMS
TIMEOUT
TWOPHASECOMMIT
UPPERCASEONLY
USE32KRECORDBUFFER
USECONNXSCHEMAFORNATIVE
USEDOUBLEFORNUMBER
USEOLDADABASDECIMALDATATYPE
USESXCALL
YEARWINDOW
►
CONNX Configuration Manager (Windows)
Managing Windows Configuration Settings
CONNX Configuration Manager - add settings
CONNX Configuration Manager - change or update settings
CONNX Configuration Manager - remove settings
►
CONNX SQLRegistry Program (Unix)
Configuring the CONNX Client and the JDBC Server
SQLRegistry Program - update UNIX configuration settings
Links to Data Server Settings
Started Task Configuration Instructions (Mainframe )
CICS Configuration Instructions (Mainframe)
►
Chapter 15 - 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
►
Chapter 16 - 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, D-ISAM, Microfocus and RM Cobol Data Types
DBMS Data Types
IBM Mainframe Data Types
►
CONNX Data Types
CONNX Data Types - (TXT) to Longword -> Double
CONNX Data Types - Marc BIB Decimal Key Date to Timestamp14
CONNX Data Types - TNRD to ZZ
►
CONNX Data Type Import Codes
Data Type Length Information
CONNX Data Types - Import Codes 1-42
CONNX Data Types - Import Codes - 43 - 79
CONNX Data Types - Import Codes - 80-118
CONNX Data Types - Import Codes - 119-225
CONNX Data Types - Import Codes - 226-265
CONNX Data Types - Import Codes - 266-356
CONNX Data Types - Import Codes - 357-406
CONNX Data Types - Import Codes 407-443
CONNX Data Types - Import Codes 444-500
►
Chapter 17 - CONNX Reserved Keywords and Symbols
Reserved Keywords and Symbols
To enable the Use Quoted Delimiters option
►
Chapter 18 - Advanced Features of CONNX
►
General Features
Connecting to multiple servers
Migrating to the new CONNX CDD format
CONNX FTL (Fast Tuning Logic)
SQL View Clause Text Box
►
CONNX Views
CONNX Views
To create a CONNX View manually in the CONNX Data Dictionary Manager
Adding security to a CONNX View
►
Rotated Arrays
Rotated Arrays (RMS and VSAM only)
Configuring a rotated array
Using the Rotated Array Assistant
SCT Plus2000-specific Non-standard Rotated Arrays
Using non-standard uncompressed format within SCT-specific rotated arrays
SCT Plus2000-specific Unusable Non-rotated Records
Excluding unusable non-rotated records within SCT Plus2000-specific rotated arrays
►
Clone Table Assistant
Clone Table Assistant (RMS, VSAM, and Adabas SQL Gateway only)
To use the Clone Table Assistant
►
Hot Connections
To open a hot connection to a server
►
CONNX and Oracle Advanced Features
Using Oracle stored procedures with CONNX
SQL Functionality and Oracle Native Functions
Performing Queries in Passthrough Mode
►
CONNX and DB2 Advanced Features
How CONNX Transparently Maps Dynamic SQL to Static SQL for DB2
To build a static SQL package using the CONNX CDD import utility
To define 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
Performing Queries in Passthrough Mode in SQL Server Databases
►
Adabas SQL Gateway (CONNX for Adabas) Advanced Features
How CONNX handles Adabas Periodic Groups and Multi-Value Fields
Rotated Tables
Inserting data into MU and PE fields
Updating data in existing MU and PE fields
Deleting data in existing MU and PE fields
►
Comparing Data Dictionaries
Summary of Data Dictionary Comparison Tool
Using the Data Dictionary Comparison Tool
Category Definitions
►
Using Excel Add In
Summary of CONNX Excel Add In
Using the CONNX Excel Add In
FAQs for CONNX Excel Add In
Troubleshooting the CONNX Excel Add In
►
SSL/TLS Support
Summary of SSL Support
SSL to the mainframe
SSL to VMS
SSL to DB2
SSL to the Enterprise Server Service
SSL with JDBC
►
Chapter 19 - Demonstrations and Applications
►
JDBC Sample Application
CONNX JDBC Sample Application
Using the CONNX JDBC Sample Application in a Microsoft Windows Environment
Using the CONNX JDBC Sample Application in a non-Windows environment
Running the CONNX JDBC Sample Application
To connect to the data source
Navigator Bar
►
CONNX Data Dictionary Viewer
Introduction to the CONNX Data Dictionary Viewer
To establish a connection to the CONNX Data Dictionary Viewer
To open a connection to a data source name
To locate a specific field
To close a database connection
►
Chapter 20 - Performance Tips and Application Notes
►
Microsoft Access and Visual Basic
Microsoft Access and Visual Basic Performance Tips
Dynasets vs. Snapshots in Microsoft Access
More Access Tips
Dynasets vs. Snapshots in Microsoft Visual Basic
More Visual Basic Performance Tips
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 OLE DB/ODBC-compliant Providers and the MDAC Configuration
Troubleshooting RMS Data Files
SCT-specific Troubleshooting
Troubleshooting VSAM Data Files
►
ODBC Driver
ODBC Driver - SQL Performance Tips
►
Adabas Performance Tuning
Sub/Super Descriptor Handling
►
Chapter 21 - Record Locking and Transactions
Transaction Support
Adabas
DataFlex
POWERflex
RMS
Oracle Rdb
DBMS
DB2
Oracle
VSAM
C-ISAM, DISAM, and Micro Focus
►
Chapter 22 - Troubleshooting: Error Messages
TCP/IP Codes/States
►
C-ISAM
C-ISAM: Error Messages
►
Adabas
Adabas Error Messages
►
DB2
DB2: SQL States
DB2: Distributed Data Management
DB2: APPC Primary Return Codes
DB2: APPC Secondary Return Codes
DB2: ODBC States
►
VSAM
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 Diagnostic Action Table
►
Appendix A - Technical Support
Technical Support
►
Appendix B - Trademarks and Copyrights
Trademarks and Copyright Page
►
Appendix C - GDPR and Personal Data
Privacy and Personal Data
►
Appendix D - Glossary
Terms and Abbreviations
►
Introduction to Adabas SQL Gateway Embedded SQL
►
Chapter 1 - Adabas SQL Gateway Embedded SQL
Introduction to Adabas SQL Gateway Embedded SQL
Getting Started
►
Windows Installation
Quick-Start Guide
►
z/OS Installation
Installing Adabas SQL Gateway Embedded SQL - z/OS
Required and Optional Fields and Files - z/OS
►
Unix and Linux Installation
Installing Adabas SQL Gateway Embedded SQL - Linux + Unix
►
Chapter 2 - Threading SQL Applications
Threading SQL Applications
SQL Context
SQL Threading Models in Adabas SQL Gateway Precompiler Clients
Implementing the Threading Models
►
Chapter 3 - Client/Server Configuration
►
Client Configuration
Description of Client Configuration
►
Server Configuration
Description of Server Configuration
CDD / JDBC Server
►
Client / Server Communication
Description of Client / Server Communication
Host / Port
►
Chapter 4 - Programming Guide - General Concepts
►
SQL Programming - General Concepts
SQL Statements
The SQL Communications Area (SQLCA)
Program Structure
SQL Commands and Grammar
Transaction Logic
►
Static SQL
Introduction
Manipulating Data
►
Dynamic SQL
Introduction to Dynamic SQL
General Aspects
Non-Select Statements
Select Statements
Using Host Variable Markers
SQL Descriptor Area (SQLDA)
Host Variable Specification
►
Chapter 5 - Programming Guide - C
►
SQL Programming Concepts - C
SQL Statements in C
Host Variables
►
Embedding SQL Statements in C
General Rules in C
Adabas SQL Gateway Precompiler C-string Logic
Error Handling in C
SQL Communication Area (SQLCA)
SQL Descriptor Area (SQLDA)
►
SQL Descriptor Area (SQLDA)
Encoding and using the SQLLEN field
►
Windows
Invocation and Precompiler Options (Windows - C)
►
Unix
Invocation and Precompiler Options (Unix - C)
►
z/OS
Invocation and Precompiler Options (z/OS - C)
►
Chapter 6 - Programming Guide - COBOL
►
SQL Programming Concepts - COBOL
SQL Statements in COBOL
Host Variables in COBOL
►
Embedding SQL Statements in COBOL
General Rules in COBOL
Error Handling in COBOL
SQL Communication Area (SQLCA)
SQL Descriptor Area (SQLDA)
►
Windows
Invocation and Precompiler Options - (Windows - COBOL)
►
Unix
Invocation and Precompiler Options (Unix - COBOL)
►
z/OS
Invocation and Precompiler Options (z/OS- COBOL)
►
Chapter 7 - SQL Statements
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
Host Variable Specification
INCLUDE
OPEN
PREPARE
ROLLBACK
SELECT (SINGLE ROW)
SET
SET AUTOCOMMIT
SET CONNECTION
USING Clause
WHENEVER
►
Chapter 8 - Utilities
►
ACEINT Utility
ACEINT
Server Connection
Direct SQL Statements
Additional Statements
ACEINT Commands
Batch Processing
Mainframe considerations - ACEINT utility
►
Chapter 9 - Error Messages
Error Messages - Precompiler
►
ACEAPI
ACAPI General Information
►
ACEAPI Argument Functions
SQL_CTR_BLOCK
SAGColumn
SAGContext
SAGPointer
SQLDA
SQLVAR
Decoding and Encoding SQLLEN
SQLDA Data Types
►
ACEAPI SQL Functions
About 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
►
Technical Support
Contacting Technical Support
►
Trademarks and Copyrights
Legal Notices
Adabas SQL Gateway Documentation
Code Page Support
►
Open Systems Event Replicator
►
Chapter 1 - Preface
Introduction
The What, Why, and How of Event Replication
Open Systems Event Replicator Architecture - Replicating to a Relational Database
Open Systems Event Replicator Architecture - Replicating Adabas to Adabas
Replication Overviews
►
Chapter 2 - Event Replicator Installation
System Requirements
Prerequisites
Installing the Event Replicator on a Windows Environment
Installing UNIX Event Replicator Components on the Replicator Administrator
Installing the Event Replicator on a UNIX Environment
Installation considerations in an Adabas to Adabas environment
Installing the JMS Server
Default Port Numbers and Firewall Considerations
Replication Components
►
Chapter 3 - Event Replicator Removal
Uninstalling the Event Replicator
►
Chapter 4 - Using the Event Replicator - Adabas to Relational
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
Adding a Replication to the Event Replicator
Mapping columns to a new Target Table
Adding New Column Mappings
Deleting Column Mappings from 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
Un-Deploying all Replications
Un_Deploying selected Replications
Stopping Event Replication
Restarting Event Replication
Starting Stopping and Getting Status from the Event Server
►
Event Replicator Tutorials
About Event Replicator Tutorials
Performing a Simple Replication - Adabas to Relational Database
Adding a new Replication and Redeploying
Removing a Replication from Deployment
Manipulating Replication Data
►
Chapter 5 - Using the Event Replicator - Adabas to Adabas
Preparing an Adabas database for Adabas to Adabas Replication
Creating a CDD for Adabas to Adabas Event Replication using the CONNX SQL Engine
Enabling a CDD for Adabas to Adabas Replication
Adding an Adabas to Adabas File Copy Replication to the Event Replicator
Renumbering Target Files
Deleting a Replication - Adabas to Adabas
Configuring Replication and Source Database Servers
Viewing Server Status
Deploying the Event Replication
Performing an Initial State
Un-Deploying all Replications
Un_Deploying selected Replications
Stopping Event Replication
Restarting Event Replication
Starting Stopping and Getting Status from the Event Server
Using adaopr command line utility
►
Chapter 6 - Event Replicator Menus and Tabs
File Menu
Edit Menu
View Menu
Tables Menu
Servers Menu
Help Menu
Replication Design Tab
Deployed Replications Tab
Server Status Tab
►
Chapter 7 - Event Replicator Functions
Opening the Event Replication CDD
Mapping SQL Expressions to Target Column
Adjusting Display Column Width
Event Replication Registry Settings
Data Filtering
Validating Active Replications
Switching from Test to Production
Changing Source Tables
Starting the UNIX Message Queue
Stopping the UNIX Message Queue
Starting the UNIX Replication Controller
Stopping the UNIX Replication Controller
Repcmd - using the replication command line tool
►
Chapter 8 - Event Replicator Troubleshooting Guide
Event Replication Troubleshooting Suggestions
Event Replication Error Messages
Event Replicator User Exits
Event Replication Troubleshooting Do's and Don'ts
►
Chapter 9 - ACD Replications
Introduction to ACD Replications
Creating ACD Replications
ACD Output
►
Appendix A - Technical Support
Support Contacts
►
Appendix B - Copyright Page
Legal Information
►
KPiSync
►
KPiSync
Introduction
System Requirements
Summary of Product Function
Installing KPiSync
►
KPiSync Administrator
►
Log in Tab
Log in Information
►
Accounts Tab
Managing User Accounts
►
KPi's Tab
Adding KPi's
Editing KPi's
Deleting KPi's
►
Query Builder
Getting started
Opening the Query Builder
Adding an object to the query
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
►
Groups Tab
Multiple KPi's in a single group
To push a group on demand
►
Schedule Tab
To schedule a KPi push task
To select a KPi push date
To select a KPi push time
To select an active range
To establish holiday scheduling
To view scheduling properties
►
Subscribing Users
User Subscriptions
Subscription by Account
Subscription by KPi
Subscription by Group
►
KPiSync Windows Store App
KPiSync Windows App
►
KPiSync Mobile App
KPiSync Mobile App
►
Trademarks and Copyrights
CONNX KPiSync Tool
►
InstantdbSync
►
Preface
Introduction
The What, Why, and How of Event Replication
InstantdbSync Architecture
Replication Overviews
►
Chapter 1 - Installation
System Requirements
Preparing SQL Server as a source
Preparing MySQL as a source
Installing InstantdbSync on a Windows Server
Transferring InstantdbSync components to Unix
Installing InstantdbSync on Unix
Default Port Numbers and Firewall Considerations
Replication Components
►
Chapter 2 - Using the Event Replicator
Creating a CDD for Event Replication
Enabling a CDD for Event Replication
Adding a Replication
Mapping columns to a new Target Table
Adding New Column Mappings
Deleting Column Mappings from 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 Replications
Performing an Initial State
Suppressing an Initial State
Un-Deploying all Replications
Stopping Event Replication
Restarting Event Replication
Starting Stopping and Getting Status from the Event Server
►
Chapter 3 - Event Replicator Menus and Tabs
File Menu
Edit Menu
View Menu
Tables Menu
Servers Menu
Help Menu
Replication Design Tab
Deployed Replications Tab
Server Status Tab
►
Chapter 4 - Event Replicator Functions
Mapping SQL Expressions to Target Column
Adjusting Display Column Width
Event Replication Registry Settings
Data Filtering
Validating Active Replications
Starting the UNIX Message Queue
Stopping the UNIX Message Queue
Starting the UNIX Replication Controller
Stopping the UNIX Replication Controller
Repcmd - using the replication command line tool
►
Chapter 5 - ACD Replications
Introduction to ACD Replications
Creating ACD Replications
ACD Output
►
Appendix A - Troubleshooting Guide
Event Replication Troubleshooting Suggestions
Event Replication Error Messages
Event Replicator User Exits
Event Replication Troubleshooting Do's and Don'ts
►
Appendix B - Technical Support
Support Contacts
►
Appendix C - Copyright Page
Legal Information
►
CONNX Data Synchronization
►
CONNX Data Synchronization
Introduction
Summary of Product Functions
Prerequisites
System Requirements
The CONNX Data Synchronization Tool Window
►
The CONNX Data Synchronization Tool
Installing the CONNX Data Synchronization Tool
►
Settings Tab
Setting Tab sub-tabs
►
Sync Behavior sub-tab
To select a target database for synchronization
To purge target tables and preserve schema
To create index before table population
To store transaction logs on target databases
To perform verification analysis on updates
To recreate indexes on target table
To create target tables in separate schemas (SQL Server only)
To add a date/time column to target tables
To disable logging
To set transaction batch size
►
Data Types sub-tab
To synchronize blobs
To treat CHAR data types as CLOB
To treat CHAR data types as VARCHAR
To select the maximum number/decimal precision for target columns
►
Error Handling sub-tab
To compare COUNT(*) of source and target
To retry failed synchronizations
To create a non-unique index if duplicate data is detected
►
Metadata sub-tab
To target metadata case
►
Tables Tab
To select a CONNX Data Dictionary for the Data Synchronization process
►
Groups Tab
To place multiple tables into a single group
To synchronize a group on demand
►
Schedule Tab
To schedule a synchronization task
To select a synchronization date
To select a synchronization time
To select an active range
To run a trigger file
To establish holiday scheduling
To view scheduling properties
To verify or view a synchronization in process
►
Per Schedule Synchronization Tasks
Per Schedule Synchronization Tasks
Before Synch Task
On Success Task
On Failure Task
►
Global Tasks Tab
►
Available Types of Scheduled Tasks
Scheduled Tasks
►
Global Scheduled Synchronization Tasks
Global Scheduled Synchronization Tasks
Global Scheduled Synchronization Task - Before Synch
Global Scheduled Synchronization Task - On Success Task
Global Scheduled Synchronization Task - On Failure Task
►
Global On-Demand Synchronization Tasks
Global On-Demand Synchronization Tasks
Global On-Demand Synchronization Task - Before Synch Task
Global On-Demand Synchronization Task - On Success Task
Global On-Demand Synchronization Task - On Failure Task
►
Troubleshooting
Purging History feature
Compact Database feature
Duplicate keys
Error messages
►
Command-line Feature
Starting a synchronization from a command line
►
Trademarks and Copyrights
CONNX Data Synchronization Tool
▼
CONNX SQL Gateway Documentation
►
ConnecX SQL Gateway Concepts
General Architecture
ConnecX SQL Gateway Configuration Scenarios
Getting Started
►
Installing ConnecX SQL Gateway
Conventions
Overview of the Installation Process
System Requirements
Installation Steps
Configuring CXGSERV
Configuring CXGCICS
Installing and Configuring CXGCONM
CICS Configuration Information
Validating the Installation
►
ConnecX SQL Gateway Reference
Conventions
DB2 SQLCODE Correlations
Trace Points
Server List Syntax
►
ConnecX SQL Gateway Administration
Conventions
The UQAD Administration Transaction
Diagnostics
►
Using ConnecX SQL Gateway
Application Design and Development Considerations
CXGCICS Statistics
Understanding SQL Processing
►
Messages and Codes
Abend Codes
Runtime Messages
CONNX SQL Engine 13.5
CONNX SQL Gateway 13.5
Documentation Overview
CONNX SQL Engine 13.5
CONNX SQL Gateway 13.5
Documentation Overview
Installation and Getting Started
Concepts
Getting Started
Installation and Configuration
Reference
DB2 SQLCODE Correlations
Trace Points
Server List Syntax
Messages and Codes
Using ConnecX SQL Gateway
Application Design and Development Considerations
CXGCICS Statistics
Understanding SQL Processing
ConnecX SQL Gateway Administration
The UQAD Administration Transaction
Diagnostics
