Version 14.8
New Functionality
This section includes new functionality added in the product with the current release.
License Administrator
You can now manage your CONNX Data Integration Suite licenses with the online CONNX Configuration Manager in the Online CONNX Suite. This replaces Windows tool, now named License Administrator (Classic).
JDBC DSN Creation Tool
The JDBC data source name creation tool is now available in the CONNX Configuration Manager in the Online CONNX Suite.
Add Database Connection
You can now add a new or additional database connection to a CDD in the CONNX Data Dictionary Manager in the Online CONNX Suite.
Link Child CDDs
You can now add additional CDDs as child connections to a CDD in the CONNX Data Dictionary Manager in the Online CONNX Suite.
New data type "PIC N(X)" (National/Unicode)
"PIC N(X)" enables support for VSAM databases or any File Definition import.
New PACKED in COBOL Copybooks
CONNX now supports the PACKED and COMP3 data types in COBOL Copybooks.
KEEPDASHES Configuration Setting
You can now use the new KEEPDASHES configuration setting to replace the dashes or dots in imported column and table names with underscores. Default is 1 - keep the dashes. The setting is located in CONNXCDD\Options.
FLAT table imports in Adabas
CONNX now remembers the number of occurences for FLAT table imports from the last import.
Connection.isClosed method
CONNX now supports the Connection.isClosed JDBC method.
fn unsetfilename function
You can use the new fn unsetfilename function to revert the filename that you have set with the fn setfilename function to the previous file name. See {fn unsetfilename <File Name>} for more information.
EXACTADSEARCH Configuration Setting
You can now use the new EXACTADSEARCH configuration setting to force the REST server to accept only fully qualified Active Directory users in the format DIRECTORY\ADUSER. In addition, this limits the Active Directory lookup of the REST server only to the specified user.
InstantdbSync
EC_SQL_MAX_HANDLES_PER_RL configuration setting
You can now control how many SQL handles are cached per record loader with the new configuration setting EC_SQL_MAX_HANDLES_PER_RL (default 500). To determine the amount of SQL handles, CONNX takes the greater value between the value of EC_SQL_MAX_HANDLES_PER_RL and the value of the old setting EC_SQL_MAX_HANDLES divided by the record loader count.
Log Enhancements
InstantdbSync now displays the SQL cache size in the EC log and a one-time message when a record loader exceeds the Cache size.
SKIP_TARGET_PROKEEPDCESSING define
You can now use the new SKIP_TARGET_PROCESSING define to play back a replication queue in the Replication Controller without sending the changes to the target.
transferQueue function
You can now use the new transferQueue function mq_monitor to transfer a queue from a big endian platform to a little endian or vice versa.
Pre-image support for ACD Tables
You can use the EP_ACD_PREIMAGE configuration setting to enable pre-image support for ACD tables.
EP_USER_NAME configuration setting
You can use the EP_USER_NAME configuration setting to not have the replication put variable data in the user name field.
Resolved Issues
This section includes the issues that are resolved in this product release.
REST Server
Enhanced Error Message on Failed Log In
Added a specific error message that is displayed when you fail to log in the REST Server and the REST Server service is installed in a workgroup instead of a domain.
REST Service - Online CONNX Data Dictionary Manager
Import Options for the 64 bit Data Dictionary
The DataFlex and PowerFlex import options have been removed from the 64 bit list because they are 32 bit only databases.
Importing data from RMS servers
An error might occur when importing data from multiple RMS servers and the physical RMS server name does not exist in the CDD but an RMS cylinder with a different name exists.
The issue is resolved.
Importing data from Adabas Dynamic DDL
The REST Server might crash after performing an Adabas Dynamic DDL re-import.
The issue is resolved.
Importing data from SQL Server with an ODBC driver
System tables are now correctly removed when importing from SQL Server with an ODBC driver and the "Include System Tables" option is turned off.
Importing data from Adabas FDT and Adabas SYSOBJH
An error was returned when you tried to import a database with no tables from an Adabas FDT or SYSOBJH file.
The issue is now resolved. You can import a database with no tables. This creates an empty cylinder in the CDD.
Leftover files from the import procedures
Some import procedures left temporary files on your system.
The issue is now resolved.
POST /api/cdd/object/import/importbuilder/properties API call
The POST /api/cdd/object/import/importbuilder/properties API call now correctly uses the "buildPackages", "ownerLibrary", "as400PlugandPlayMode", "convertBinaryToCharacter", and "jobPriority" options when used for a DB2 import.
Importing from DB2, CONNXStore, and Redshift
The Authentication Mode list for DB2, CONNXStore, and Redshift imports contains duplicate values.
The issue is resolved.
GET /api/cdd/object/import/importbuilder/initial API call
The GET /api/cdd/object/import/importbuilder/initial API call fails without an error message when importing from SQL Server.
The issue is resolved.
GET /api/cdd/object/fulltablenames API call
The REST Server might crash if the "tableNameSearchPattern" input is null in the GET /api/cdd/object/fulltablenames API call.
The issue is resolved.
PUT /api/cdd/object/connxtables/tablecolumns API call
Column ordinals from the PUT /api/cdd/object/connxtables/tablecolumns API call are now one based. Previously they were zero based.
POST /api/cdd/object/connxtables/tablecolumns API call
An error is returned when you try to add a column with a name that already exists in the table.
PUT /api/cdd/object/connxtables/tablecolumns API call
An error is returned when you try to rename a column to a name that already exists in the table.
Importing from Adabas SYSOBJH
When importing from an Adabas SYSOBJH file, sometimes the import procedure created an empty database cylinder without importing any of the selected tables.
The issue is resolved.
Importing MySQL and MariaDB with ODBC and OleDB connections
The database name was not imported correctly when importing from MySQL and MariaDB databases with an ODBC or OleDB connection.
The issue is resolved.
POST /api/cdd/objects/connxtables API call
Importing tables with the POST /api/cdd/objects/connxtables API call results in tables with incorrect database type.
The issue is resolved.
"GRANTOR" role in CDD administration
The "GRANTOR" role in the "table_privileges" table shows as "CONNXSuperUsers" when a table is created by a CONNX user.
The issue is now resolved. "GRANTOR" now shows as the database owner.
DataSync
Multiple Syncs running simultaneously
Sometimes an "out of bonds" error might occur when multiple syncs are running at the same time.
The issue is resolved.
Column map is in random order
The columns in the column map are in a random order after saving a transformation.
The issue is resolved.
Data inserted into a wrong column
After syncing a transform where columns were manually mapped from a source table to a target table, data is inserted into the incorrect column.
The issue is resolved.
Authorization when creating a transform
An "Authorization has been denied for this request" error occurs when creating a transform as a DataSync Designer.
The issue is resolved.
Indexes on Teradata target
Only one index is created on a Teradata target despite having multiple indexes on the source table.
The issue is resolved.
License error
An "Out of licenses" error occurs for a user with two active DataSync Licenses when a sync is running in the background and another sync is running interactively.
The issue is resolved.
Invalid timestamps with Teradata as source and SQL Server in Azure as target
An "Invalid timestamp literal" error occurs when running a timestamp sync with Teradata as source and SQL Server in Azure as target.
The issue is resolved.
Transformation sync error
A "TableSynchronizations table not found" error occurs when performing a transformation sync with the "store transaction log on target" option turned on in DataSync.
The issue is resolved.
REST Service - Configuration Manager
The Registry keys are now returned in an alphabetical order.
CONNX Client/Server
Oracle client on Solaris platforms
The Oracle client on Solaris platforms has been updated from version 10 to version 12.1
Binding JDBC to large parameters
Unpredictable behavior occurred when using JDBC to bind a very large binary parameter.
The issue is resolved.
"SELECT" query does not return correct data
When containing both a maxrows and an ORDER BY clause, the "SELECT" query does not return the correct data.
The issue is resolved.
Importing from MicroFocus COBOL FD files
An import with a local copybook failed when the server was remote.
The issue is resolved.
SQLGetDiagRec function
A crash might occur when the SQLGetDiagRec function is called incorrectly from a calling application.
The issue is resolved.
SQL_SUCCESS return for calls to SQLFreeStmnt on SQL_DROP
CONNX now always returns SQL_SUCCESS for calls to SQLFreeStmnt on SQL_DROP call.
"SELECT" query returns incorrect results
When requesting data from Adabas with a "SELECT" query that contains an ORDER BY clause and MultiDB is enabled, the "SELECT" query returns incorrect results.
The issue is resolved.
UniformSQL buffer
The UniformSQL buffer size is increased to handle a case where many large SQL statements are unioned together and each SQL statement held large column lists.
Adabas packed subdescriptors
CONNX counts start and end offsets for alpha fields from right to left instead of left to right. In addition, the Sign nibble must always be present. This means that CONNX adds one byte to the format data and shifts all the data by one nibble (4 bits).
Support for passing a null object to the setObject function for all data types in the JDBC interface
You can now pass a null ojbect to the setObject function. CONNX returns SQL_SUCCESS_WITH_INFO as warning in the log instead of an error.
Memory overwrite in JDBC connection pooling
Connection errors occur in the JDBC interface due to memory overwriting in JDBC connection pooling.
The issue is resolved.
STRICTUNMERICDATA Configuration Setting
You can use the STRICTNUMERICDATA configuration setting to force CONNX to return NULL if the data in fields with data types "Text -> Integer" and "Signed overpunch" is not strictly numeric.
PostgreSQL numeric data type length calculation
The length of PostgreSQL numeric data type is now calculated correctly.
Configuration Manager
Sometimes the configuration manager returns only default values for CONNX settings.
The issue is resolved.
SSL/TLS connection crashes
A crash might occur when an SSL/TSL connection attempt to the JDBC Server failed due to an error.
The issue is resolved.
InstantdbSync
SQL Server replication
An exception occurs when a keyword is used without quotes in a column name (Pkey).
The issue is resolved.
SQL Server replication - Large SQL tables with varchar primary keys
Issues regarding the replication of large sql tables with varchar primary keys to SQL server are resolved.
SQL Server replication - false change event
A false change event is created when a change involved a segment that contained a key, despite the key staying unchanged.
The issue is resolved.
MU/PE fields
MU/PE fields with more than 191 elements are causing errors.
The issue is resolved,
MU/PE fields - element count for fields with more than 255 characters
MU/PE fields with more than 255 elements now have the element count set correctly when moved between machines with a different endian type.
ACD Columns
ACD Column names are now always uppercase.
Solaris server performance
InstantdbSync performance with Solaris servers is improved.
Enhanced error message
The error message that appears in the column map screen when specifying an index that doesn't exist is enhanced. The error message now specifies whether the index is missing from the source or the target table.
Mainframe
Performance issues due to TCPIPBUFFERSIZE being used as zero on the mainframe if not explicitly defined with the configuration manager are now resolved.
Installation
Unix Server Installer
The Unix Server Installer crashes when used to update from a very old version.
The issue is resolved.
Silent Installer
The license server is not installed correctly with the license installer.
The issue is resolved.
Unix Client and Server Installers
An error occurs when connecting to and transferring files from newer FTP servers with SSH authentication.
The issue is resolved.
32 bit Linux CONNX Installation
When installing CONNX on Linux, the 32 bit CONNX components are installed only if the 32 bit compatibility libraries are also installed.
Unix Installations
The connxjdbc.jar and connxRouter.jar files are now included in the installation and are placed in the install directory.
CONNX Excel Add In installer
The standalone CONNX Excel Add In installer is removed. It is part of the main installer.
Start menu Icons
The installation creates icons for the Web Administrator applications when they are not selected.
The issue is resolved.
CONNX Embedded SQL for Adabas installer
Sometimes the CONNX Embedded SQL for Adabas installer would not run when selected for installation.
The issue is resolved.
CDDBASEFOLDER configuration setting
The installer reads the CDDBASEFOLDER setting incorrectly when reinstalling CONNX.
The issue is resolved.
REST Server Port
Prior installations set the 64 bit REST Server listener port to 6501.
The issue is now resolved.
License Administrator (Classic)
Selecting a license when trying to use the update or revoke license buttons after the licenses are sorted by any column results in the selection of an incorrect license.
The issue is resolved. The License Administrator (Classic) tool is replaced by the License Administrator in the REST Server.
Online CONNX Suite
Pop ups which have buttons fall off the visible dialog when viewed at certain screen resolutions.
The issue is resolved.
Online CONNX Data Dictionary Manager
"Items Per Page" option in the table column screen
The "Items Per Page" option for table columns now defaults to 500 and if set a custom value, the value will be remembered across sessions. In addition, the page is more responsive when a large amount of columns is listed.
Importing from MicroFocus Cobol File Definition files
When importing from MicroFocus Cobol File Definition files with the online CDD Manager, now the list of all files changes font color when it is selected and you must always select one column.
Scroll bars in import screens that show a list of local files
Lists that show local files now have a scroll bars that appear when the list is too long to fit on one page.
DataSync
The dropdown in the DataSync Transforms column mapping screen is not working when selecting source column names.
The issue is resolved.