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 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 or ADA2/ADA or ADA2, SQL/SQL or XML/XML. 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.