What Are the Parameters in the Lawson Database Interface Configuration File?

The following topics describe the parameters in the Lawson db.cfg database interface configuration file:

Parameters that Specify Your Database Implementation

The parameters in the following table configure the database.

Parameter Description
[SECTION]

A section name to group parameters. At least one entry is required; if your product line configuration includes multiple databases, you can have more than one entry. If you specify a value for dbname in %LASRCDIR%\dict\dataarea.xml, the section name should match the dbname. If you do not specify a value for dbname in dataarea.xml, the section name should be one of the following, depending on your database type.

  • COMMON

    Any parameters placed in this section will apply to all database instances defined in the db.cfg file.

  • MSFDB

    Indicates the database in this section is a Microsoft SQL Server database.

  • ORADB

    Indicates the database in this section is an Oracle database.

  • UPGDB (Deprecated)

    This parameter allows one additional database connection. You must specify the database type within this section using the DBTYPE parameter.

DBTYPE

Deprecated. Formerly used to indicate the type of database for this set of data. Normally this parameter was only used when the database section is designated [UPGDB].

This value would match the value of the dbtype parameter in the dataarea.xml file. You can change that value using the changeda command.

PORT The port number for the database server.
LOGINNAME

This is the user name used when the database driver connects to the database. The default is lawson.

The parameter is not required if SERVICENAME is specified.

PASSWORD

This is the password for LOGINNAME, which the database driver uses when it connects to the database. The default is lawson.

The parameter is not required if SERVICENAME is specified.

SCHEMA

Deprecated.

Do not use this parameter in the db.cfg file. This value is configured in the dataarea.xml file.

Parameters that Support Text Search

The parameters in the following table configure the Lawson database driver to use text indexing and search features provided by the database.

Parameters that Configure Record Caching

Use the following parameters to enable record caching.

Parameter Description
ARRAYBUFSIZE

Indicates the maximum number of rows to be fetched at a time from the database. The default is 10 rows.

The setting for this variable in the database driver configuration file applies to all files in the data area.

INSERTBUFSIZE

Indicates the maximum number of rows to be buffered in the database driver before an array insert flushes data out to the database.