{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}{\f1\fnil\fcharset2 Symbol;}} {\*\generator Msftedit 5.41.15.1503;}\viewkind4\uc1\pard\qc\lang3081\b\f0\fs36 CL4 OpenAccess ODBC Database Server\par \fs32 Release Notes\b0\fs20\par \pard\par \b\fs32 Introduction\par \fs24\par \b0\fs20 This document provides a software change history for the current release version of the CL4-SQL Server.\par \b\fs24\par \pard\li284 Release\par \pard\li568\tx3408\b0\fs20 CL4 ODBC server release:\tab\b 1.6b\b0\par OpenAccess release:\tab\b 4.80.8\b0\par Document ID:\tab $Id: Release.wri,v 1.5 2003/03/11 05:29:54 planetary Exp $\par \pard\par \b\fs32 Release History\fs24\par \pard\li284\par \pard\li284\tx2272\fs20 Release 1.6b:\tab 11-Mar-2003\b0\par OpenAccess:\tab 4.80.8\par \par This is a minor bug fix release.\par \par Bug fixes:\par \pard{\pntext\f1\'B7\tab}{\*\pn\pnlvlblt\pnf1\pnindent0{\pntxtb\'B7}}\fi-284\li568 Time fields of value '0:00:00' were identified as NULL values. Now a time field, like all except date fields, may never be NULL as CL4 currently has no concept of NULL data.\par {\pntext\f1\'B7\tab}Time values were not being inserted or updated correctly in time fields, but were being set to "0:00:00". This has been corrected.\par \pard\li284\par \pard\li284\tx2272\b Release 1.6a:\tab 30-Oct-2002\b0\par OpenAccess:\tab 4.80.8\par \par This is a minor bug fix release.\par \par Bug fixes:\par \pard{\pntext\f1\'B7\tab}{\*\pn\pnlvlblt\pnf1\pnindent0{\pntxtb\'B7}}\fi-284\li568 NULL date values in alternate key tables (key files) were not being correctly updated. Key tables with date fields can now be safely set to NULL or updated from NULL when the primary table is updated.\par \pard\li284\par \pard\li284\tx2272\b Release 1.6:\tab 3-Sep-2002\b0\par OpenAccess:\tab 4.80.8\par \par Bug fixes:\par \pard{\pntext\f1\'B7\tab}{\*\pn\pnlvlblt\pnf1\pnindent0{\pntxtb\'B7}}\fi-284\li568 The issue with NULL dates resurfaced in the SCO Unix release & has now been properly repaired for all platforms.\par {\pntext\f1\'B7\tab}MS-Query and some other windows utilities requested all schemas on connection by passing a table owner of "%". This release of the server now handles this special condition.\par {\pntext\f1\'B7\tab}Stored procedures sometimes did not successfully return data result sets back to the server on some platforms. This has been repaired and tested for all platforms produced for this release.\par \pard\li284\par \pard\li284\tx2272\b Release 1.5:\tab 13-Mar-2002\b0\par OpenAccess:\tab 4.80.8\par \par Bug fixes:\par \pard{\pntext\f1\'B7\tab}{\*\pn\pnlvlblt\pnf1\pnindent0{\pntxtb\'B7}}\fi-284\li568 Precision improvements for G data datatypes.\par {\pntext\f1\'B7\tab}Correct handling for byte (B) datatypes when used in WHERE clauses.\par {\pntext\f1\'B7\tab}Improvements on the speed of retrieval of subsets of data.\par \pard\li284\tx2272\par Additions:\par \pard{\pntext\f1\'B7\tab}{\*\pn\pnlvlblt\pnf1\pnindent0{\pntxtb\'B7}}\fi-284\li568 Upgrade to middleware release 4.80.8\par {\pntext\f1\'B7\tab}New built-in functions \i substr(sourceStr, fromChar [, numChars])\i0 , \i instr(sourceStr, matchStr [, fromChar, numChars])\i0 and \i translate(sourceStr, matchStr, replaceStr)\i0 .\par \pard\li284\tx2272\par \b Release 1.4:\tab 8-Jan-2002\par \b0 OpenAccess:\tab 4.7.15\par \par Bug fixes:\par \pard{\pntext\f1\'B7\tab}{\*\pn\pnlvlblt\pnf1\pnindent0{\pntxtb\'B7}}\fi-284\li568 INSERT processing: Inserting a row without specifying every column filled in the remaining data from the most recently retrieved record in the table.\par {\pntext\f1\'B7\tab}INSERT processing: Inserting NULL data into fields in a row caused a failure of the server's client instance. NULL data now correctly handled on INSERTs. (NB: Dates are the only CL4 datatype which can be properly recognised as NULL data. All NULL numeric columns are set to zero, and all NULL character columns are set to the empty string.)\par {\pntext\f1\'B7\tab}INSERT processing: Now properly rejecting inserts to tables where a record of the same key is already in the table.\par {\pntext\f1\'B7\tab}UPDATE processing: Disallow update of key fields in records, which caused duplication of the record.\par {\pntext\f1\'B7\tab}PROCEDURE processing: Procedures with fewer columns returned in the result set for rows subsequent to the first would cause the server's client instance to fail.\par {\pntext\f1\'B7\tab}System tables: There was a server fault in access of the OA_COLUMNS table if it was selected from before the OA_TABLES table.\par {\pntext\f1\'B7\tab}DML processing: Key table records are now maintained correctly when inserting, updating or deleting records in it's primary table. Note that unlike in CL4, key tables are not directly accessible as tables in the CL4-SQL schema environment.\par \pard\par \pard\li284\tx2272 Additions:\par \pard{\pntext\f1\'B7\tab}{\*\pn\pnlvlblt\pnf1\pnindent0{\pntxtb\'B7}}\fi-284\li568 Support for database referential integrity using CL4's hierarchical cascading delete mechanism. If this function is enabled, any related records in ("Set") tables are deleted when a master table's row is deleted.\par {\pntext\f1\'B7\tab}Additional procedure \i HIER('[on|off|default[:default]]'); \i0 implemented to support referential integrity faciltity. See implementation guide \i Implemnt.wri\i0 for more information.\par \pard\par }