Release 11.7.1 of OpenEdge SQL includes support for the following features:
Autonomous Schema Update on Replication target database
Autonomous Schema Update(ASU) functions differently when working with a read-only Replication target database. Because the Replication target database is read-only, the schema cannot be updated. In the event of an SQL width problem caused by SQL reporting applications on the Replication target, ASU will create DDL commands on the Replication target database to address the SQL width issues. These DDL statements are ALTER statements and the syntax is as follows:
ALTER TABLE table-name ALTER COLUMN column-name SET PRO_SQL_WIDTH column_width;
These statements are written to a log file when ASU is enabled on the Replication target DB. The log file name will follow the naming convention SQL_asu_alter_commands_serverpid_timestamp_A.log. A second log file is named SQL_asu_alter_commands_serverpid_timestamp_B.log. The log files have a size limit of 500MB, and once the size limit is exceeded on the first log file, logging happens in the second log file. Once the second log file size exceeds 500MB, the first log file will be overwritten. These files are shared across sessions for the same database. Users should then manually run the DDL commands from the log file on the Replication source database using a tool like SQL Explorer. Only users with SQL DBA access on the Replication source can perform these actions.
Logging is on by default and users can choose to either turn logging on or off using the following statements:
SET PRO_ASU_REPLICATION_SERVER LOG ON;
to turn logging on and
SET PRO_ASU_REPLICATION_SERVER LOG OFF;
to turn off logging.
Connection Failover and Load Balancing support for Progress DataDirect Series ODBC and JDBC drivers
OpenEdge SQL supports Connection Failover and Load Balancing provided by Progress DataDirect Connect Series for ODBC and JDBC drivers. SQL client products have these drivers embedded. This enables the SQL clients to use the Connection Failover and Load Balancing features of the Progress DataDirect Connect Series for ODBC and JDBC drivers.
Note: For more information on Progress DataDirect Connect Series for ODBC and JDBC drivers, see Progress DataDirect Documentation.
Autonomous Schema Update on Replication target database