The section description must be enclosed in brackets ([ ]).

A space character must precede and follow the hyphen in the first line.

In the initialisation file, a line is considered as a comment if the first character is the ‘#’ sign. Otherwise, there is no fixed order for the element description.

If a logical database name is mapped more than once in the initialisation file, the first mapping defined is used. All other mappings are discarded.

The format to use when mapping logical database names in the pro4v[n].ini file is as follows:

[database - logical database name]
location=physical location
{lowercase=Y}
{filetype=file type identifier}
{connection=connection-string}

Where:

Item

Description

logical database name

Logical database name to be mapped to a physical location.

physical location

Location of the directory in the file system.

lowercase

Controls the case conversion of the full pathname and filename string.
Y= The entire path name and file is converted to lowercase. This setting is the default and also affects PROPATH and PRODATA.

file type identifier

Describes the type of file being identified.  Valid only for PROIVTEMP and SQL files.

The value of the file type identifier can be one of the following:
blank (default), PROISAM, CISAM, when used as FSIDEFAULT
DECRMS
DEFAULT when used, the file type stored in FSIDEFAULT is used.
Oracle for Oracle

MYSQL for MySQL

connection-string 

Describes the commands required to log-on to a SQL database.  Usually these replace the SQL_USERNAME and SQL_PASSWORD environment variable.

If Oracle is being used, the following lines must be added to the prov4[n].ini file:

[database - sqldefault]
connection=prousr/prousr
filetype=ORACLE

Comment on this topic

Topic ID: 720224