Version 4.2.6 for Mainframes
 —  Parameter Reference  —

DB - Database Types and Options

This Natural profile parameter can be used to define database types and options for all and for specific database IDs.

It corresponds to the NTDB macro in the parameter module NATPARM.

Possible settings database-type database-type is besides ADABAS and its synonym ADAV7, for example, ADAV8, DLI, VSAM, DB2, etc. For further information on the corresponding Natural database management interface, see the Database Management System Interfaces documentation.

This subparameter is mandatory for the NTDB macro.

database-ID database-ID must be in the range from 0 to 65535.

Database ID 255 must not be specified, because it is reserved for internal use.

You can specify a single database ID, a list of database IDs enclosed in parentheses, or an asterisk (*) to indicate the default for all databases not specified explicitly.

options options, see Possible Database Options below.
Default setting ADABAS,* Adabas Version 7.
Dynamic specification yes This parameter can only be specified dynamically. In the Natural parameter module NATPARM, the macro NTDB must be used instead.
Specification within session no  

At compile time, Natural Data Manipulation Language (DML) statement functionality will be limited to the functionality that is available for the specified database type.

At runtime, the specified database type defines which Natural database management interface is called for a database ID.

The following topics are covered below:


DB Parameter Syntax

The DB parameter is specified as follows:

1. Default Database Definition

The default database type and its default options is specified as follows. It applies to all database IDs not explicitly specified by the DB parameter or NTDB macro. If there are no options, the commas and the asterisk can be omitted.

DB=(database-type,*,options)

2. Single Database Definition

A single database ID is specified as follows:

DB=(database-type,database-ID,options)

3. Multiple Database Definition

Multiple database IDs of the same database type with the same options can be specified together, enclosed in parentheses:

DB=(database-type,(database-ID1,database-ID2,...),options)

Top of page

NTDB Macro Syntax

The NTDB macro is specified as follows:

1. Default Database Definition

The default database type and its default options is specified as follows. It applies to all database IDs not explicitly specified by the DB parameter or NTDB macro. If there are no options, the commas and the asterisk can be omitted.

NTDB database-type,*,options

2. Single Database Definition

A single database ID is specified as follows:

NTDB database-type,database-ID,options

3. Multiple Database Definition

Multiple database IDs of the same database type with the same options can be specified together, enclosed in parentheses:

NTDB database-type,(database-ID1,database-ID2,...),options

Top of page

Possible Database Options

The following options can be specified for both the DB parameter and the NTDB macro:

ACODE The Natural application must communicate to Adabas whether code page or Unicode support is desired if the Adabas DBID used is enabled for character encoding and data conversion. Therefore the ACODE setting specifying the application-specific code page for all A fields and/or the WCODE=4095 (UTF-16) setting for all W fields must be sent with the OP call. See also Unicode and Code Page Support.
WCODE
ENTIRE The database is to be handled by Entire DB.
ETP The database is to be handled by Entire Transaction Propagator.
OPEN This option applies to Adabas databases only, for which Adabas requires an open request to be issued. If OPEN is specified for such a database, an open request is always issued (even if the ETID is blank).
READ The database is to be read-only.

The following options can be specified for the dynamic parameter DB only.

NOENTIRE Resets the ENTIRE option.
NOETP Resets the ETP option.
NOOPEN Resets the OPEN option.
NOREAD Resets the READ option.
OFF Removes any DB or NTDB definition for the specified databases, see Examples of DB Parameter below.

Top of page

Examples of NTDB Macro

NTDB DLI,7
This defines Database 7 as DL/I database.
NTDB 
ADAV8,(10,15,57),ETP
In the Natural parameter module NATPARM, this defines Databases 10, 15 and 57 as Adabas Version 8 databases which are to be handled by Entire Transaction Propagator.

Top of page

Examples of DB Parameter

DB=(VSAM,(22,26,33))
This defines Databases 22, 26 and 33 as VSAM databases.
DB=(,*,READ)
This sets all databases for which the default database definition applies to read-only.
DB=(,(8,9),NOREAD)
This removes the read-only option for Databases 8 and 9.
DB=(,17,OFF)
This resets the database definition of Database 17 to defaults.

Top of page