----------------------------------------------------------------------

SQL/R A.01.71 - patch 9912020

----------------------------------------------------------------------


Fixed problems:
---------------

* Version number changed to A.01.71

* When a date field is used to access an index (in a join or
  optimizing the WHERE clause) SQL/R did not correctly encode serial
  date values above 1999-12-31 (e.g. FROM 1972).


Patch PS16-9911020
------------------

* Version number changed to A.01.70

* Sqlr.DLL and sqlrexec are now compatible with either 6-digit or
  8-digit date encodings. This is important when a date field is used
  to access an index (in a join or optimizing the WHERE clause)
  because SQL/R must encode a value according to conventions used in
  the database.

  Formerly, the default date encoding was YYMMDD (6-digit). This has
  changed to YYYYMMDD (8-digit including century). For backward
  compatibility reasons, the old encoding is still available.

  Backward compatibility is controlled by using the "date" keyword
  with the SQLR_OPTIONS environment variable.

  Syntax: The SQLR_OPTIONS environment varible is specified as a
  list of options separated by a semicolon (;). Each option
  consists of a keyword and a value, separated by an equal sign (=).

  For example:
  SQLR_OPTIONS="date=ymd"
  export SQLR_OPTIONS

  Please note that the quotes are important since the semicolon
  is handled as a statement separator by the shell.

  Keywords:
     date - specify date encoding
            cymd : including century (8-digit date encoding)
            ymd  : excluding century (6-digit date encoding)
            default is "cymd"


Patch PS16-9808210
------------------

* Version number changed to A.01.65
* Max. string length has been extended from 1024 to 2048


Patch PS16-9807170
------------------

* Version number changed to A.01.64
* Fixed memory overwrite in header line


Patch PS16-9807150
------------------

* Version number changed to A.01.63
* Fixed memory overwrite in header line


Patch PS16-9807030
------------------

* Version number changed to A.01.62
* Max. number of aliases has been extended to 384


Patch sqlr-1.61
---------------

* Version number changed to A.01.61

* Sqlr.DLL and sqlrexec not compatible with PA-RISC 1.0 hardware

* Sqlr.DLL and sqlrexec are now compatible with eloqdb5 to easy the
  A.06.00 transition. If a database path does not begin with a slash
  (it's not an absolute path) and the leading segment is not an existing
  directory, all characters before the first slash are ignored. This
  should have no impact on backwards compatibility.


Installation:
-------------

SQL/R A.01.60 (or above) must be installed previously. While this
patch probably works with previous versions as well, this has not been
verified.

In order to install this patch, you need to unpack it with gzip.
Gzip is included with HP-UX 10.x (and above). Gzip for
for HP-UX 9.x can be obatined from this ftp server in the /pub
directory. Installation requires root privileges.

cd /opt/sqlr
gzip -dc PS17-9911290-hpux.tar.gz | tar xf -

Files:

   bin/sqlrexec
   lib/Sqlr.DLL
   lib/libsqlrvar.sl
   lib/libC.sl