// -----------------------------------------------------------------------
//  This file is provided by ILOG JRules.
// -----------------------------------------------------------------------

In the same directory as this readme.txt you will find a two sql files per database supported by the Rule Execution Server.

For each dtatabse, you will find two SQL scripts which handle instructions to create the
database resources.

The repository* scripts contain the database schema of Rule Execution Server
The trace* scripts contain the database schema of Decision Warehouse.

You will find the complete list of supported database in the documentation.

======================
Prerequisites
======================

   * The SQL scripts attempt to drop and create tables and indexes. Please, check that your database
     user has the corresponding rights before running these scripts.

   * For Oracle, in addition to tables and indexes, sequences and a view are also created. Please,
     also check that your database user has the corresponding rights before running these scripts.
   
   * For DB2, the Decision Warehouse database schema uses a buffer pool of 32k page size. The default name of the buffer pool
     is BP32K.
     

======================
How to use the scripts
======================

To use these SQL scripts, you just have to load them into a database tool that can execute SQL instructions.
Basically, each database provides such a tool :
   * 'ij' for Derby
   * 'command center' or 'command line processor' for IBM DB2
   * 'SqlTool' for Hypersonic HSQLDB
   * 'mysql' for MySQL
   * 'sqlplus' for Oracle
   * 'Pointbase console' for Pointbase
   * 'Query Tool' for SQL Server
   * 'isql' for Sybase

Please refer to the documentation of these tools for more information.

======================
Notes
======================

Concerning the schema, you can only change the RULESET_RESOURCES.NAME length. Other modifications are not supported (expect adding index).
