Aggregating Identical Adabas Databases
MultiDB
The MultiDB function of CONNX is a specialized capability for Adabas that enables identically structured Adabas databases to be aggregated and treated as a single logical database.
For example, if a new Adabas database with an identical structure is created every year, the information from each year is in a separate database. The MultiDB function enables queries that search all of the databases configured seamlessly.
Syntax
You can set the filter for the duration of the connection using the following SQL command:
{multidbfilter catalog name dbid,dbid2,dbid3...}
All following queries will honor this filter. For example:
{multidbfilter adabas_host 4,5}
When you reset the filter, all available databases are searched for the remainder of the connection:
{multidbfilter catalog name reset}
Example:
{multidbfilter adabas_host reset}