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.
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 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.