Eloquence B.07.10 - QUERY3K release notes ========================================= Revision: B.07.10 - 2007-02-16 The Eloquence QUERY3K utility is intended as a replacement for the MPE QUERY/iX utility. QUERY3K is designed to be closely compatible and to require only minimal changes to existing QUERY scripts. For general information on QUERY3K, please refer to http://www.marxmeier.com/eloquence/support/B0710/doc/query3k/index.html This in an updated version of QUERY3K that fixes known problems and improves some of the QUERY3K database limits. This version passed our internal testing but due to a large number of internal changes this version should be considered beta quality. This test release is intended to enable additional external testing. Please refer to the section "known problems" below for any known issues. Please send any feedback or problem reports to the Eloquence support at support@marxmeier.com. ============= Prerequisites ============= The following prerequisites must be met before installing the Eloquence QUERY3K utility: - Eloquence B.07.10 with the hp3k license option. ============ Installation ============ A platform specific archive is available for download from the Eloquence web site. The distribution archive only includes the new QUERY3K binary any may be installed in an arbitrary location. It can be installed in parallel to a previous QUERY3K version. HP-UX PA-RISC QUERY3K-70216-hpux-pa11.tar.gz HP-UX IA64 QUERY3K-70216-hpux-ia64.tar.gz Linux x86 QUERY3K-70216-linux-glibc2.2.tar.gz Windows QUERY3K-70216-win32.zip HTTP download: http://www.marxmeier.com/eloquence/download/beta/B0710/query3k/ FTP download: ftp://ftp.marxmeier.com/eloq/beta/B0710/query3k HP-UX and Linux platform ------------------------- The Eloquence QUERY3K software is distributed as a compressed tar archive. Please download the distribution archive and place it in a temporary directory. The archive file is compressed (gzip) and needs to be uncompressed before installation. # gunzip QUERY3K-70216-hpux-pa11.tar.gz This creates the QUERY3K-70131-hpux-pa11.tar archive file and removes the compressed archive file. Then please extract the archive file to the local directory. # tar xvf /tmp/QUERY3K-70216-hpux-pa11.tar This extracts the following files (relative to the current directory): query3k - QUERY3K executable Windows platform ---------------- The Eloquence QUERY3K software is distributed as a ZIP file archive. Please download the distribution archive and copy the content to their target locations. This archive provides the following files: query3k.exe - QUERY3K executable It is strongly recommended to change the QUERY3K console properties. - On Windows it is required to set the console font to a TrueType font (such as "Lucida Console") to get the correct output for non-ASCII characters. By default the console Window uses a bitmapped font that does not support the CP1252 code page. As a result, non-ASCII characters are displayed incorrectly. To change the font, please start QUERY3K, open the console settings and change the font to a TrueType font. Then apply the change to all windows of that name. While you are in the settings, please consider changing the font size and text foreground/background color to have a more convenient display. ============== Uninstallation ============== To uninstall restore the previous QUERY3K executable. ================== History of Changes ================== The following user visible changes were incorporated in QUERY3K since the 70131 test release: - Fixed a problem outputting some E4 values could result in a field overflow (#3287). The fix in the previous test did not work correctly. - Fix a bug related to JOINS using more two data sets that could perform wrong evaluation of the JOIN condition in some cases. J DETAIL2.KEYE2 @ TO DETAIL4.E4ITEM, & DETAIL4.E4ITEM @ TO DETAIL3.E2ITEM - Fixed a problem with calling DBINFO 812 improperly that might result in returning a status -21 on Little endian platforms. - The QUERY3K version number was changed to B.07.10.04 (20070216), the Windows file revision was changed to 7.10.0.4 The following user visible changes were incorporated in QUERY3K since the B.07.10 release : - Fixed a problem outputting some E4 values could result in a field overflow (#3287). Some values (such as -1000) could in some cases result in a field overflow due to a rounding problem while estimating the number of significant digits. - Fixed a problem with QUERY3k crashing when printing string items with a size beyond 255 bytes (#3267). This problem was caused by a buffer overflow. As a temporary solution, string items with a size beyond 255 characters are no longer considered printable and will result in a message like below: ILLEGAL ITEM LENGTH X500, ITEM ID-DATA-500-1 IGNORED - Fixed a memory corruption with the FIND command when entering an item with more than 16 characters (#3296). For example: >find skldjflskjflskdjflskjdflskjflskdjlskdjf PROCEDURE NAME TOO LONG >exit ** Cought signal 11 ... - The FORM SETS command was changed to suppress outputting the MAXIMUM CAPACITY if the output would be the Eloquence default. As all Eloquence data sets are considered to have a dynamic "capacity" this would otherwise clutter the output without providing any additional information. - QUERY3K was enhanced to improve support of the Eloquence database limits. This release should now support - a record size of up to 5120 bytes - 2048 items per database - 500 data sets - 1024 items per set. - The item type 'B' (binary) is now mapped to 'X'. String items with more than 255 bytes per subitem are not yet supported and may result in undefined behavior. Please be aware that only limited testing was performed so far with databases that exceed the previous TurboIMAGE limits. - Fixed a number of problems related to the JOIN command and using indexed access on Little Endian platforms (Linux, Windows). - Fixed a problem with DBINFO 812 returning a status -21 on Little endian platforms. - The QUERY3K version number was changed to 20070131, the Windows file revision was changed to 7.10.0.3 ========================== Known problems/limitations ========================== The following problems/limitations are currently known: * QUERY3k does not yet fully support the Eloquence database limits. Using QUERY3K with databases that exceed the internal limits may result in undefined behavior. * Printing string items with more than 255 characters is currently disallowed. * The database password entered in QUERY3K has no effect; please use the environment variables EQ_DBUSER and/or EQ_DBPASSWORD.