Advanced Query Tool features
Database Explorer
shows you comprehensive information about the objects in your databases
not just tables, but also views, aliases, indexes, tablespaces, triggers, procedures, functions, users, authorities
unique 3-pane displays makes it easy to deal with thousands of objects
can sign onto multiple databases
configured individually for Oracle, DB2/UDB, DB2 z/OS, DB2 for iSeries, Sybase Anywhere, Sybase ASE, Sybase IQ, MS SQL Server, Informix, MySQL, Pervasive.SQL, SQLBase, PostgreSQL, Interbase/Firebird, Netezza, Progress, MAXDB/SAPDB, IDMS, RedBrick, NonStop SQL/MX, NonStop SQL/MP, EXASolution, Teradata
configuration-driven system; displays can be amended or altered
can define and display Favorites
display your Saved Queries - useful for those who run pre-build queries
Run SQL
syntax highlighting of SQL
"intellisense" giving you a popup list of schema, tables, columns and column functions
save / retrieve queries
SQL can contain substitutional parameters (values are prompted when SQL is run)
SQL History (saved to disk between sessions)
single-click table and column analysis
format SQL
Search Table window to easily build simple searches (screenshot)
long-running queries can be cancelled
run scripts containing thousands of SQL statements. Scripts can be paused, amended, restarted
run Stored Procedures. These can contain INOUT and OUT parameters, and produce multiple result-sets
explain plan (for DB2/UDB, DB2 z/OS, Oracle, SQL Server, Sybase, MySQL)
Displaying Data
display large values and multi-line text
group query results
display row detail
display LOB columns. LOB values can be displayed in an external application
display Unicode data
display XML values with AQT's XML Viewer
sort, copy, print, save, compare query results; move, freeze, hide columns
display totals and subtotals, save/load display layouts
display data from related tables
pivot a column for data summarization
Updating Data
build and run update / delete / insert statements
build either single-row update/deletes or mass update/deletes
updates can run under transactional control
inline-editing of table data
has safe update mode to prevent inadvertent mass updates/deletes
insert / update LOB values
Graphical Query Builder
many users have said that this is the best query builder on the market
quickly build multi-table queries
auto-detect table relationships
reverse-engineering capability - take an existing SQL query and display it as a graphical query
support for table expressions / inline views
build complex Where clauses and Column expressions
use native or ansi join syntax
many options for formatting the SQL
has a sophisticated window for building Where clauses
Data Export
export to csv, HTML, Excel, fixed format, XML
export to HTML has full options for HTML formatting and use of style sheets (example)
export to XML follows dbunit specifications
can export data as a series of Insert statements
export to HTML and Excel can hyperlink to LOB files (example)
has native interface to Excel (you do not need Excel installed on your PC)
Charting
you can create Charts from your data
once you have defined a Chart, you can save it to disk (as a file). It will appear in the Queries display of the Database Explorer window, and can be defined as a Favorite
the Chart can be refreshed with current data with a couple of clicks
charts can be created in batch (unattended) mode
Database Administration (Extended Edition only)
create / alter / drop objects
not just tables, but also indexes, foreign keys, tablespaces, triggers, procedures, functions, users
admin module has been developed for Oracle, DB2/UDB, DB2 z/OS, DB2/400, Sybase Anywhere, Sybase ASE, MS SQL Server, Informix, MySQL, Pervasive.SQL, SQLBase, PostgreSQL, MS Access, Interbase/Firebird
generate full DDL for objects
security administration
full compare of table definitions (including indexes, keys, constraints)
excellent cross-database support - copy/compare objects definitions between databases of different types
Data Loader (Extended Edition only)
load data from delimited files, Excel files, tables, queries
load data from one database to another database type (eg. Oracle to DB2)
copy LOBs between databases
graphical mapping of target columns from source
transform data from source to target
preview data before loading
comprehensive options for transactional control and error handling
restart the load after failure
can be run in batch mode
has native interface to Excel (you do not need Excel installed on your PC)
Data Compare (Extended Edition only)
compare data in tables, views, or results of queries
compare data across databases of different types
generate a script to resync table contents
compare full LOB values
can be run in batch mode
Object Compare (Extended Edition only)
compare the definition of objects from one system to another
compare across databases of different types
compare not just tables but also indexes, keys and other objects
compare all the objects in a schema
can specify what parameters of an object are compared
System Monitor (Extended Edition only)
configured for DB2/UDB, Oracle, Sybase, SQL Server
monitor many different parts of your system
displays can be customized
critical conditions can be highlighted
has auto-refresh