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 |
|---|---|---|
database-ID |
database-ID must be in
the range from 0 to 65535.
Database ID 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:
The DB parameter is specified as follows:
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) |
A single database ID is specified as follows:
| DB=(database-type,database-ID,options) |
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) |
The NTDB macro is specified as follows:
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 |
A single database ID is specified as follows:
| NTDB database-type,database-ID,options |
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 |
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.
|
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.
|
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. |
