
	Version 8.2.3 for Mainframes	SEARCH CONTENTS \| PDF BOOKS \| HOME UP PREV NEXT

— 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	See DB Parameter Syntax.
Default setting	`ADABAS,*`	The default database type is Adabas.
Dynamic specification	yes	This parameter can only be specified dynamically. In the Natural parameter module `NATPARM`, the macro `NTDB` is used instead.
Specification within session	no

Notes:

For information on the Natural database management interface, see the Database Management System Interfaces documentation.
For the supported versions of the database management systems, refer to Database Management Systems in the current Natural Release Notes for Mainframes.
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
NTDB Macro Syntax
Possible Database Options
Examples of DB Parameter
Examples of NTDB Macro

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)

Where:

Syntax Element Value Explanation

Syntax Element	Value	Explanation
`database-type`	`ADABAS` or `DLI` or `VSAM` or `DB2` or `CXX`, etc.	Database type. This subparameter is mandatory for the `NTDB` macro.
`database-ID`	`0` - `65535`	Database identification. 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`		See Possible Database Options.

database-type

ADABAS or DLI or VSAM or DB2 or CXX, etc.

Database type.

This subparameter is mandatory for the NTDB macro.

database-ID

0 - 65535

Database identification.

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 See Possible Database Options.

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

Possible Database Options

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

Option	Explanation
`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 in the dynamic parameter DB only.

Option	Explanation
`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.

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.

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 databases which are to be handled by Entire Transaction Propagator.

SEARCH CONTENTS | PDF BOOKS | HOME UP PREV NEXT