Adabas Dynamic Database Number

How to:

Previous versions of the Adapter for Adabas required specification of the Adabas database number in the Access File using the DBNO attribute. This feature required a duplicate copy of the Access File for each database accessed.

Adabas database numbers can now be set from a FOCEXEC or profile. This SET command allows users to override the DBNO in the Access File. Note that specifying database numbers in the Access File is still supported. Use of the dynamic database number makes Master and Access Files shareable among databases.

The SET command remains valid throughout the session.


Top of page

x
Syntax: How to Set the Adabas Dynamic Database Number
x
ENGINE ADBSINX SET DBNO dbno 
ENGINE ADBSINX SET DBNO dbno AFD afd 
ENGINE ADBSINX SET DBNO dbno AFD afd SEG[NAM] segname 
ENGINE ADBSINX SET ?
ENGINE ADBSINX SET DBNO DEFAULT

where:

ADBSINX

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

dbno

Is any valid numeric database value between 0 and 255.

afd

Is any valid Access File name.

segname

Is any valid ADBS segname in the Access File.

?

Queries the current settings.

DEFAULT

Returns to the default settings for all previous settings. The DBNO is read from the Access File. If the attributes are not specified in the Access File, the adapter will determine the DBNO from the DDCARD.

Examples are shown below:

ENGINE ADBSINX SET DBNO 5

Retrieves all data from database number 5.

ENGINE ADBSINX SET DBNO 2
AFD EMPFILE

Retrieves data for the EMPFILE from database number 2.

Note: Several commands can be issued for different files. Each command must be issued separately. Changes are cumulative. For example:

ENGINE ADBSINX SET DBNO 1 AFD EMPFILE
ENGINE ADBSINX SET DBNO 2 AFD EMP2
ENGINE ADBSINX SET DBNO 3 AFD VEHICLES

ENGINE ADBSINX SET DBNO 2
AFD EMPFILE SEG S02

Retrieves data for the EMPFILE in database number 2 for a particular ADBS segment (segment S02).

ENGINE ADBSINX SET ?

Displays your settings.

ENGINE ADBSINX SET DBNO DEFAULT

Returns to the default settings. This resets all SET DBNO commands for all Access Files.


Information Builders