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.
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:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
Is any valid numeric database value between 0 and 255.
Is any valid Access File name.
Is any valid ADBS segname in the Access File.
Queries the current settings.
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 |