File format: $BSE/lib/ora/ora_driver_param

The driver parameter file provides a way to influence the behavior of the database driver on a per table/index basis for:

  • The ownership of the database tables. For more information, see Database Security.
  • The query generation. For more information, see Query tuning.
  • The refresh time of the record cache: this field is obsolete.

This is an example of an entry in the driver parameter file:

*:*:T: group:014::

In this example, the database driver creates tables owned by an LN group, and uses the iterative technique during the query generation.

A driver parameter file is defined for each database driver. The storage file for the LN Oracle database driver is called ora_driver_param and is located in the Windows directory %BSE%\lib\ora or the UNIX directory $BSE/lib/ora.

The file consists of zero or more entries, each of which consists of several fields separated by colons. The format of an entry in the storage file is (primary key in bold):

 <table/module specification> : <company number> : <object type> : <group> : <table/index optimization> : <refresh time>

For information on each of the fields in an entry in the storage parameter file, see Parameter file field descriptions.

The drivers scan this file top-down. The first matching line is used, but not the best matching line.