Options - Config Files

These entries are used to cross reference the database type to the config file to be used for the database. These entries are key to the correct functioning of the System-table Query Feature of Advanced Query Tool. Database Types and Config Files discusses this feature and how it relates to the config files.

AQT operates on the concept of auto-detecting the database type. This is not a trivial matter. It relies on what the database calls itself. This is reported in the field called: The database you are currently signed onto identifies itself as. AQT then tries to match this with one of the entries in the list of Database Identifiers.

AQT will populate the list of Database Identifiers when it runs for the first time. If there are any problems with these entries you will notice that the system-table query feature is not functioning (eg. the object tree in the Database Explorer will show only Tables/Views and System Tables).

Circumstances where you might need to change these entries are if:

your database identifies itself with a name different to what we have configured.
you have been supplied a config file for a new database type (either by us or by someone at your site) and you need to add in a new entry in order for this config file to be picked up.

These entries work as follows:

given the name the database calls itself, AQT will go through the “database identifier” entries and use the first one which matches.
when matching an entry, AQT tries to match on the first n characters of the names, where n is the length of the database identifier entry.
For example:

Database	identifies itself as	these databases are handled by the following entries
DB2 for AIX	DB2/6000	DB2/
DB2 for NT	DB2/NT	DB2/
DB2 z/OS	DB2	DB2

This would not work if the third database (DB2 z/OS) was at the top because the DB2 entry would catch all three databases.

There is no capability to specify different config file for different versions of a database.

Load Defaults

Click on this to load the default config entries supplied with AQT. If you are upgrading from an earlier version of AQT you might wish to click on this to pick up any new entries we have supplied.

Advanced Query Tool

https://www.querytool.com