UDB - User Database ID

#### Search Results

Search

# UDB - User Database ID

This Natural profile parameter specifies the DBID to be used for a database access at runtime. This database ID specified with the `UDB` parameter replaces DBID 0 when Natural objects are executed.

Possible settings | `0` or `1 - 65535`, except `255` | Valid database ID. Note Database ID 255 is reserved for logical system files, see profile parameter `LFILE`.
Default setting | 1 |
Dynamic specification | yes |
Specification within session | no |
Application programming interface | `USR1005N` | See SYSEXT - Natural Application Programming Interfaces in the Utilities documentation. * Recommended.
`USR1040N` *

Notes:

1. The database type of DBID 0, which is specified in the DBMS assignments table of the Configuration Utility, and the database types of the DBID specified with the `UDB` parameter must be the same: ADA/ADA, ADA2/ADA2, SQL/SQL or XML/XML. As an exception, the combination ADA/ADA2 is possible. The first type is the database type of DBID 0 and the second type is the database type of the DBID specified with the `UDB` parameter.
2. If the DBID in the DDM used is 0, then the database type is taken from the DBMS assignments table entry `DBID=0` at compilation time, whereas the database type of the DBID specified with the `UDB` parameter is used only at runtime.
3. If no DBID 0 is specified in the DBMS assignments table, then the default database type is set to `ADA`.
4. If no DBID is specified in the DDM used, the DBID specified with the `UDB` profile parameter determines which database is accessed. If so, the `UDB` profile parameter must be set to a valid DB number.
5. `UDB` is also used to specify the DBID for stowing transaction data if the profile parameter `ETDB` is not specified.