Version 14.7
New Functionality
This section includes new functionality added in the product with the current release.
CONNX Configuration Manager
The CONNX Configuration Manager is now part of the CONNX REST Server. You can manage the CONNX configuration settings on the REST Server host machine remotely.
CONNX REST Server Data Dictionary Manager
The CONNX REST Server Data Dictionary Manager now has the function to create a CONNX Data Dictionary (CDD) and import database information to a CDD.
64-bit CONNX REST Server
The CONNX REST Server now has a 64-bit version, in addition to the existing 32-bit version. Use the 64-bit server to access data sources that load libraries that require 64-bit processing.
UPSERT in RMS
When RMS detects a duplicate key violation in a database, the "INSERT" statement now updates the data to remove the error.
New data type "Text Date (MMDDYYYY)"
"Text Date (MMDDYYYY)" is a new CONNX data type that you use to indicate the text date in the specified format.
New data type "Pack Date (CYYJJJ)"
The "Pack Date (CYYJJJ)" is a new CONNX data type that indicates the pack date in the specified format. This data type supports dates from 01/01/1800 to 12/31/2799.
cnxsetfilename() function
A new SQL extended function that changes the physical file name of a specified table or table alias for the remaining time of the connection duration.
For more information about the SQL extended functions, see SQL Extended Functions.
Resolved Issues
This section includes the issues that are resolved in this product release.
CONNX Client/Server
Creating Adabas table with unsupported default values
Attempting to create an Adabas table with default values that are not supported fails, but does not return an error message.
The issue is resolved. Now the create table operation fails and returns an error message that the default values are not supported for this Adabas table.
Object ID does not exist for PostgreSQL
For PostgreSQL data types, when inserting data into a "LONGVARBINARY" field in a table, CONNX returns an error that the object ID does not exist.
The issue is resolved.
"SELECT" query does not return correct data
When selecting data from an Adabas table with 78 or more occurrences of a periodic group (PE), the "SELECT" query does not return the correct data.
The issue is resolved.
Bulk delete locks records
Deleting records in bulk locks other records in a table. The issue is resolved.
"AUTOBULKDELETE" setting
After configuring AUTOBULKDELETE, the setting is not applied to the table records. The issue is resolved.
Connecting to server with password containing "="
When you try to connect to the CONNX server using ACF2 authentication and the password includes the equal sign ("="), the connection attempt fails. The issue occurs when the CONNX Started Task components are installed.
The issue is resolved. You can now use a password or username that include the equal sign ("=") to connect to the CONNX server.
Performance issues when inserting data
Inserting data in bulk affects the server performance. The issue is resolved.
MySQL STATISTICS function
The MySQL "STATISTICS" function now returns the index columns in the proper order.
Database number does not match in InfoNaut
When using the "CREATE CLUSTER DESCRIPTION" statement with the "DATABASE NUMBER" keyword, InfoNaut returns an error that the database number specified in the "CREATE" statement does not match any known Adabas database number in the CONNX Data Dictionary (CDD), even when that database number does occur in the CDD.
The issue is resolved.
Rotated array with expression in quoted-string notation
CONNX performance issues when handling a rotated array that contains an expression with quoted-string notation are now resolved.
CONNX server in a high-latency network
A network with high latency impacts the performance of the CONNX server.
The issue is resolved. Now the CONNX server performance in a high-latency network is similar to that over an FTP connection.
Improved performance of "limit" and "{maxrows}" for ISAM join queries
The performance of "limit" and "{maxrows}" for ISAM join queries is now improved.
Parsing delimited identifier
An error might occur when parsing a delimited identifier.
The issue is resolved.
"cnxsetfilename" SQL extended function
An error might occur when using the "cnxsetfilename" SQL extended function to change the physical file name of a specified table or table alias for the remaining time of the connection duration.
The issue is resolved.
Bulk update
An error might occur when performing a bulk update. The issue is resolved.
Bulk insert anf create table with Teradata
An error might occur when using Teradata to perform a bulk unsert and create of a table.
The issue is resolved.
Memory corruption
CONNX has memory corruption issues.
The issue is resolved.
Bulk delete in VSAM
An error might occur when performing a bulk delete method in VSAM.
The issue is resolved.
ASCII character 255 treated as space
The ASCII character 255 is treated as a space.
The issue is resolved.
"TCPNODELAY" values
The valid values of the "TCPNODELAY" configuration setting now include the value of "0".
VSAM alternate index
Issues related to the VSAM alternate index are now resolved.
Deadlock in SQL server with connection sharing
When connection sharing is enabled on a highly loaded SQL server, CONNX detects a deadlock condition.
The issue is resolved.
REST Server
Log entries
The CONNX Rest Server now logs version information for each entry in the log file.
The REST Server stops responding after failed authentication
When you connect to a database server that does not require a password and you specify the wrong password, the CONNX REST Server stops responding.
The issue is resolved.
CDD Manager
Importing data from CISAM
When importing data from a CISAM database with the 64-bit Data Dictionary Manager and the "FTPIMPORT" configuration setting set to "0," a “Socket is null” error might occur.
The issue is resolved.
Importing data from PostgreSQL
UTF data types are now correctly imported from a PostgreSQL database.
License administrator
The license administrator now uses the HTTPS protocol to connect to the license server.
InstantdbSync
Incorrect value for MySQL "MEDIUMINT" unsigned data type
InstantdbSync replicates the value of the MySQL "MEDIUMINT" unsigned data type incorrectly when the value of that data type is larger than "0x7FFFFF" in the MySQL database.
The issue is resolved.
Core file on Linux
A core file is now correctly created on Linux when the InstantdbSync Adabas nucleus terminates abnormally.
Invalid login for CONNX Data Dictionary
The CONNX Data Dictionary (CDD) for event replication saves invalid login information. Opening that CDD results in an error that selecting data from the tables failed and the CDD does not open.
The issue is resolved.
Error message enhanced
The error message “Unable to retrieve Primary Key data for UPDATE” now contains information about the file number and ISN.
Upgrading InstantdbSync
InstantdbSync now correctly upgrades from versions lower than 13.0 to version 13.5 and higher.
Deleted transactions remain in queue
Deleted transactions might remain in the queue because of unresolved errors.
The issue is resolved.
Synchronization failure
InstantdbSync might fail to synchronize because of the logging of table lock requests when the log level is set to "Verbose".
The issue is resolved.
Adding records to table with SQL view clause
InstantdbSynch now adds a changed record from a source table with an SQL view clause to the target table so that the view clause will not filter out the changed record.
Deleting Adabas source table fails
During replication, deleting an Adabas source table results in a 0 records affected error. The issue occurrs when multiple tables point to the same source but at some point one of these tables is made to point to a different source.
The issue is resolved.
Improved replication performance
The replication performance of source tables with a view clause is improved.
View clause logic error reporting
Error reporting related to the view clause logic is now improved.
View logic in target table
Issues related to the view logic in the target table are now resolved.
DataSync
UCASE passthrough queries
The UCASE passthrough queries fail for extended ASCII characters in CONNXStore tables.
The issue is resolved.
Illegal characters in database names
Both DataSync Rest Server and DataSync Classic now support illegal characters in database names.
Language-neutral DataSync
DataSync is now language-neutral.
Index with the same column repeated multiple times
Now DataSync does not select a unique index that has the same column repeated multiple times.
DataSync table generator
The DataSync table generator now functions correctly when the CONNX Data Dictionary contains a space in its name.
Order of indexes
The order of indexes of the saved transformations on the Index tab is now consistent.
Unique and non-unique indexes in saved transformations
Unique and non-unique indexes in saved transformations are now correctly marked as their respective type.
Index names of transformations
The index names of transformations created with both DataSync REST Server and DataSync Classic now begin with "0" instad of "1".
JDBC Server
Thread ID values
Thread ID values are now correctly labeled as either signed or unsigned in the log.
Multi-line error messages
Multi-line error messages about the JDBC Server are now fully displayed in the log.
"gettempfilename"
The "gettempfilename" function now replaces any directory characters in a username with an underscore ("_").
InfoNaut
Process ID of query
In InfoNaut, the process ID of a query now remains associated with the connected file when you cancel that query and the "TABLECACHE" configuration setting is set to "0."
Installation
Installation scripts in Solaris
In Solaris, the installation scripts now support a line longer that 1024 characters.
Amount of MSU or cores
The license administrator is now enhanced to report information about the amount of MSU or cores for all types of licenses.
Documentation Changes
This section includes major changes in the documentation for the current release.
The release notes for this product are now included in the documentation. For the release notes of lower CONNX versions, go to CONNX Release Notes for 14.6 and below.
The information in the Installation Guide has been reorganized.
The information in User Reference Guide has been moved to new guides.
The Concepts topics in the help explain how the Software AG CONNX components interact and function.
The Administration Guide includes topics, such as configuring and securing Sodtware AG CONNX.
The Developer Guide includes topics, such as details about the CONNX drivers and support for 64-bit clients.
The Operations Guide includes toipcs, such as working with database objects and remote procedures.
The Reference Guide includes toipcs, such as SQL grammar and CONNX data types.