Advanced Query Tool

Administration Component of AQT

This feature is part of the Extended Edition of AQT.

Use the Administration Component to:

  • create, alter and drop database objects such as tables, indexes, tablespaces, functions, stored procedures.
  • run various admin actions against your objects (such as Rename, Runstats, Analyze)
  • generate full DDL for your objects (not just tables, but also tablespaces, triggers, procedures etc).
  • manage security for your objects with the comprehensive security helper.

All screenshots shown are for DB2/UDB; displays will vary depending on database type.

As elsewhere in AQT, the Admin Component is driven entirely from configuration files. These define the structure of your database objects, and what actions can be performed on them. By doing this, we can configure the Admin Component for a large number of database types, and allow you to define your own admin functions for any particular requirements.

The Admin component has been configured for Oracle, DB2/UDB, DB2 for z/OS, DB2 for iSeries, Sybase ASE, Sybase Anywhere, SQL Server, MySQL, Informix, Pervasive.SQL, PostgreSQL, MS Access and SQLBase.

Create Table

Example of Create Table window in DB2/UDB:

Create Table

Alter Table

AQT makes it very easy to alter a table, as demonstrated by the following screenshot, for DB2/UDB.
  • You can only alter those parts of the table definition that can be changed.
  • Any changes are highlighted in yellow.
  • Click on Preview to see the SQL that AQT has generated to alter the table.
  • Click on Run to apply the changes. If any of the changes fail, the values will remain highlighted in yellow for you to correct or cancel.
Alter Table

Define other Objects

You can define a lot more than just tables. This screenshot shows creation of a foreign key for DB2/UDB.
Create Index

Stored Procedures

AQT is able to create and alter Stored Procedures. Plus Triggers, Functions.
Alter Procedure

Actions against Objects

Use AQT to run any defined action against your objects. This example will change the comments of your tables. Many other functions have been defined.

Generate DDL

  • AQT generates full DDL for tables including primary key, indexes, foreign keys, check-constraints, triggers, dependent views and aliases, grant statements.
  • AQT generates well-formatted and readable DDL.
  • AQT can also generate DDL for other objects, such as tablespaces, bufferpools, stored procedures, functions.
  • You can generate the DDL for all objects in a schema in a single action.
  • You can generate the DDL to the window, or to a file, or to a separate file for each object.
  • You can generate DDL for another database type. For instance, you can generate DB2/UDB DDL using Oracle syntax. This is useful if you are migrating objects between different database types.
  Go Home Go to Top

Last reviewed on 18 May 2011   

Copyright 2002-2011 Cardett Associates Ltd. All rights reserved.