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

ELOQUENCE B.07.10 - patch PE71-0801252

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

This patch adds enhancements or fixes defects of the schema utility
as released with Eloquence B.07.10. This patch will be integrated in 
the Eloquence B.07.10 release.

Eloquence B.07.10 must be installed before applying this patch.

Severity:
 PE71-0801252: ENHANCEMENT, BUG FIX

Superseded patches:
 PE71-0610310: BUG FIX


Patch PE71-0801252
------------------

Platforms: All

* Added support for case insensitive index option (#1073)

  A new "CI" index option was added to specify case insensitive
  indexes. The example below would set the index options EMPTY
  and CI:

  MATCHCODE (CI,EMPTY) = NAME;

  NOTE: To use case insensitive indexes, the related eloqdb6
  patch PE71-0801240 or newer must be installed before creating
  a database with this option. Otherwise the resulting index
  could be corrupted.

* Fixed a problem in the schema processor that caused some index
  flags to be improperly set in the database schema when the
  EMPTY index option was specified (#3480).

  This inconsistency had no effect during operation but could
  result in an unnecessary rebuild of the index on the next
  restructuring of the database.

* An item of type B may be specified with a partial size in an
  index defintion.

* Changed the Windows file version to "7.1.0.7"


Notes / Related patches:

- Using the case insensitive index functionality requires a recent
  eloqdb6 database server version (patch PE71-0801240 or newer).

- Patch PE71-0801253 adds case insensitive index support to the
  prschema utility.

- Patch PE71-0801254 adds case insensitive index support to the
  dbutil program.


Patch PE71-0610310
------------------

Platforms: All

* The schema processor enforced a minimum record size (media size)
  of 4 bytes (#3234). This limitation could affect compatibility of
  stand-alone manual master and detail sets.  An error message 
  like below was output by the schema processor:

  *** (ERROR) Record size below minimum

  The minimum record size limitation was removed from Eloquence 
  B.07.10 (and recent B.07.00 patch levels) but was still enforced
  by the schema processor.

* Changed the Windows file version to "7.1.0.6"


Notes / Related patches:

- The dbutil patch PE71-0610311 fixes a related problem in dbutil.


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

Please download the patch archive that corresponds with the installed
release.  The patch files follow the conventions below:

   PE71-0801252-hpux-ia64.tar.gz
        ^       ^    ^
        |       |    Architecture / OS specific build
        |       Operating system
        Patch ID


HP-UX:

In order to install this patch, you need to unpack it with gzip and tar.
Gzip is included with HP-UX. Installation requires root privileges.

cd /opt/eloquence6
gzip -dc /path/to/PE71-0801252-hpux.tar.gz | tar xf -

Files:

   bin/schema
   share/doc/PE71-0801252-README


Linux:

In order to install this patch, you need to unpack it with tar.
Installation requires root privileges.

cd /opt/eloquence6
tar xzf /path/to/PE71-0801252-linux.tar.gz

Files:

   bin/schema
   share/doc/PE71-0801252-README


Windows XP/2000/NT:

This patch should only be installed if you previously installed
the Eloquence database utilities on your system.
Installation requires administrative capabilities.

Two options are available for patch installation. The patch is
available as self extracting archive for automatic installation
and as a zip archive for manual installation. Both patches are
equivalent. Installation requires administrative capabilities.

For autmatic installation of this patch, please download the patch
file PE71-0801252-win32.exe file. Before installation, please
consider closing all applications and execute the patch installation
program. Installation does not require a reboot unless the patched
files were active.

For a manual installation of the patch, please download the
patch file PE71-0801252-win32.zip file and unpack its contents.
Then perform the following steps:

* Please copy the schema.exe file into the bin subdirectory of your
  Eloquence installation (for example C:\Programs\Eloquence\bin).

* Please copy the PE71-0801252-README.txt file into the share\doc
  subdirectory of your Eloquence installation (for example
  C:\Programs\Eloquence\share\doc).

Files:

   schema.exe
   PE71-0801252-README.txt