H06.13 Release Version Update Compendium

4 Database and Transaction Processing Products
The H06.13 RVU contains new features for these database and transaction processing products:
• SQL/MX
• SQL/MP
• TMF
• TS/MP
• OSS ODBC/MX
SQL/MX
DISPLAY USE OF Enhancements
The DISPLAY USE OF command is enhanced to:
• Display the source file from which a particular module is compiled.
• Display modules that are invalid as a result of DDL changes to any particular object.
Import Utility Enhancements
The import utility imports data from an input file in ASCII or UCS2 format into an SQL/MX
table. This utility supports OSS large files (files greater than 2 GB) as input files. In the H06.13
RVU, the IMPORT utility supports these enhancements:
• Provides a way to ignore parsing and execution errors and to have the error log filenames
and error message log filenames automatically generated. This eliminates the need to specify
values for the new -XL, -XE, -XM, -PM, and -SF options, as well as the existing -L and -E
options.
• Ignores the specified number of ignorable execution errors (MAX-EXEC-ERRORS, valid
range is 0 to 2147483646) without terminating.
• Allows you to specify the pathname (EXEC-ERROR-FILENAME) of an OSS output file to
which Import logs data rows that have execution errors.
• Allows you to specify the pathname (EXEC-ERRORMSG-FILENAME) of an OSS output file
to which Import logs the error messages that correspond with the logged data rows that
have execution errors.
Versioning Enhancements
The SQL/MX versioning tool supports these enhancements:
• Expand-connected nodes with compatible SQL/MX software versions can interoperate.
• Access to or from nodes with incompatible software versions fails in a predictable manner.
• Each version of SQL/MX software contains a set of specifications that allows the software
to determine compatibility.
Memory Allocator Enhancements
The Memory Allocator feature has been redesigned to provide:
• Better usage of memory by handling memory fragmentation.
• Improved performance of compile times and reduced memory utilization by compilers.
• Improved memory usage in memory allocation.
SQL/MX 15