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 for Software AG products, see profile parameter `LFILE`.
Default setting | database ID applicable for `FUSER` |
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 DBID 0 and the databases selected with the `UDB` parameter must be of the same type (ADA/ADA, SQL/SQL or XML/XML, for example).
2. If no DBID is specified in the DDM used, the DBID specified with the `UDB` profile parameter determines which database is accessed. Thus it is possible to have different user environments without multiple `FUSER` files being required.
3. If no DBID is specified in the DDM and the `UDB` profile parameter is not specified, the DBID that applies to the `FUSER` system file is used.