Aqt Advanced Query Tool

AQT provides a tool to display these dbmsoutput messages. This tool can be invoked from either the Database Explorer window or the Run SQL window with Tools Oracle DBMS Output. AQT will open only one DBMS Output window for each Oracle database. In order to use this feature, AQT needs to create a function on your Oracle database. Advanced Query Tool AQT is a fast and powerful multi-database query tool. The present version has a new function to rewrite your SQL queries. This is the equialent of importing your SQL into the Query Builder and back again; the SQL will be rewritten as per the options in the Query Builder.

Advanced Query Tool or AQT is a robust SQL database tool that supports any database accessible through ODBC with many capabilities to ease data analysis, write queries, load and export data. Some of the key features include 1) a point and click data loader that generates your create table statement when creating a new table and includes the. Advanced Query Tool: Fast, powerful, richly featured query tool runs against any ODBC-compliant database. Visit the AQT website for more information. Use only one tool to query your many different database types. Read more about AQT's features and download a free non-expiring trial version. No registration required. ISPF-based query tool. Description The 10.0 version of Advanced Query Tool is provided as a free download on our software library. Based on the users’ comments, Advanced Query Tool has the following benefits: the software has an easy-to-use interface and is feature-rich. The program lies within Development Tools, more precisely Database Tools.

Installing AQT (Technical Notes)

ALLUSERS Install

The install process installs AQT for the current user only. If you wish to install AQT for all users on your machine, run the following command:

Aqt Advanced Query Tool

aqtxxx_setup.exe /V'ALLUSERS=1'

You would either run this from a command prompt, or set this up in a *.bat file.

Allowing a non-administrator user to install AQT

Db2 Query Tool

Administrators can set a system policy that allows a non-administrator user to install AQT. This is described in http://kb.flexerasoftware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&externalId=Q105140

Install Log

If you are having problems with an install, you can switch on install logging. This is done with the following command:

aqtxxx_setup /V'/l*vx log.txt'

In this example, the log information will be written to file log.txt in the directory where the aqtxxx_setup file is located. This may provide some information to help you understand the problem you are having with the install.

MSI File

When the AQT setup runs, it extracts a MSI (Microsoft Installer) file. This MSI file will be placed in your local AppData directory. For Windows 7 this be:

C:Users<user>AppDataLocalDownloaded Installations

The MSI file can be used to do Repair installs or for Uninstalling AQT.

Strange Problem when running AQT after install

When the install completes, you will be prompted with the Launch the program option. This can sometimes cause a problem.

The install process gains elevated rights, and these will be carried through to AQT when it is runs at the end of the install. AQT will be able to access part of the registry it doesn't normally access. This can result in:

  • AQT thinking that you are not a registered user, when you are
  • if you enter a license key while in this mode, it may not be seen when you run AQT normally

Silent Install

Tool

You can do a Silent Install by setting up a script which has the following statement:

Aqt Advanced Query Tool

aqtxxx_setup.exe /s /v/qn

Sql Database Query Tool

A Silent Uninstall can be done with:

aqtxxx_setup.exe /s /x /v/qn

What the install does

Query

The install:

  • creates the install directory and copies the AQT executable and associated files to it. Ths install directory is (by default) C:Program FilesAdvanced Query Tool v9, or C:Program Files (x86)Advanced Query Tool v9 for 64-bit systems.
  • creates the user directory and copies a number of files to it. By default this directory is Advanced Query Tool in the user's AppData directory (on Windows 7 this is c:Users<username>AppDataRoaming).

    The user directory is specified in Options > File Locations. You can specify a different location for this directory if you wish.

    This directory must exist for AQT to operate normally. The files that AQT writes to this during the install process are various sample files which are not essential for AQT to run.

    If you are moving AQT to another machine you may wish to copy the contents of this directory to your new machine.

  • creates shortcuts for AQT in Start > Programs plus the desktop

No files are written to the Windows system directory. In earlier releases of AQT v9 one dll was loaded into the GAC (Global Assembly Cache) however this is no longer done.

If there are problems with the install, it can be done manually by:

Aqt Advanced Query Tools

  • creating the install directory and copying the AQT files to it (from, for instance, another machine where AQT has been installed successfully)
  • creating the user directory and Start/Desktop shortcuts

Aqt Advanced Query Tool Shortcut

You can back-up your existing install of AQT by copying all the files in the install directory to another location. Note that the AQT executable (aqtv9.exe) cannot run standalone but must have the dlls and other files in the same directory.