Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X Y Z
A
A quick start to AQT
About this Guide
Actions on multiple objects
Adding an object to Favorites
Adding Multiple Objects to Favorites
Adding parameters to a query
Additional functions
Administration Component
Advanced Customization
Advanced Signon options
Alter Table
Amending Data
Amending individual rows
Analyse data by grouping columns
Analysing your table
Another example of Pivot
AQT crashes on startup with a Data Execution Protection error
AQT exe
AQT exe
moving
AQT on Windows NT crashes in Build Where clause window
AQT scripting
Auditing
Auditing
auditing SQL statements
Authorities: database-type specific notes
B
batch mode
BLOBs
inserting from files
displaying
Displaying BLOBs and CLOBs
Options - LOB Options
Displaying BLOBs and CLOBs
inserting
Inserting BLOBs or CLOBs
loading from files
Options - LOB Options
Row display and row change
updating
Build a Where Clause
Build Query Column
Building a Query Using the Data Display window
C
Can AQT build Stored Procedures for DB2 z/OS?
cancel
cancelling a query
Options - Technical Parameters
Running SQL
setting async mode
Cannot display tables for Netezza
catalog
Code-blocks in Sybase / MS SQL Server
Collation Order problem with Data Compare
columns
Generate Text
generating list of
maximum in table
Options - Technical Parameters
command-line mode
comments
commit
Running multiple statements
Transaction / Commit mode
Compare Objects
Compare Table Definitions
Compare table definitions across two systems
comparing
Compare table definitions across two systems
Comparing table data
comparing table structure
query results
table data
Comparing Data
Comparing table data
config files
Database types and config files
introduction
location of
matching to database
Options - Config Files
Options - File Locations
Configuring a Database Connection
connecting
connecting
problems with
Connecting to DB2
Connecting to Excel
Connecting to HP SQL/MX
Connecting to Informix
Connecting to MS Access
Connecting to MS SQL Server
Connecting to MySQL
Connecting to Oracle
Connecting to Sybase
Connecting to Text and CSV Files
Connection Problems
copying
Copying the definition of an existing table
Copyright Notice
Crash in smartuishared when AQT is closing
Create new table
Cross-Database Queries
csv files
csv files
using AQT with
Customizing the display of particular data types
Customizing the Explain statement used
Customizing your displays
Customizing your toolbars
D
Data Compare
Data Display options
Data Display window
Data Loader
Data Loader error with MS SQL Server and Sybase
database explorer
configuring
Database Explorer
Database types and config files
Displaying Data
showing
Database Explorer - shortcut keys
Database notes
Database types and config files
Database types that AQT accesses
Database Userid and Password
Database-specific Admin notes
databases
commit
Database types and config files
Database types that AQT accesses
determining type
locking
Transaction / Commit mode
types
Date and time columns
date columns
Date and time columns
format of
how displayed
Options - Display Format
DB2
DB2
Options - Technical Parameters
uncommitted read
DB2 - Restricting Schemas displayed by AQT
Db2 Command
DB2 Monitor switches
DB2 z/OS - Admin notes
DB2/400
DB2/UDB - Admin notes
DDL generation
Debug mode
Decimal separators
Deleting
deleting rows
Editing table data
editing tables
Row display and row change
Running an action SQL statement
dictionary
Display data - shortcut keys
Display of large Oracle numeric columns is incorrect
Display Oracle DBMS_OUTPUT
Displaying BLOBs and CLOBs
Displaying Data
Displaying information about your database
Displaying table contents
Displaying view definitions
Doing a Direct Connect
E
Editing
Editing
editing tables
Editing table data
Entering your Registration Key
Error SQL7008 while updating a DB2/400 table
Error-handling options
Excel
Excel
Exporting Data
exporting data to
exporting multiple queries to
Running multiple statements
Expert only
Explain Plan
Export as Inserts
Export function set-up
Export to Delimited File
Export to Excel
Export to Fixed Format
Export to HTML
Export to XML
exporting
exporting
tables and query results
Exporting Data
Exporting LOBs
Extended Edition of AQT
F
FAQs
Fast Export
Favorites
file
file
exporting table/query as
For the DBA
Formatting Data
Four main benefits of AQT
G
General usability concepts
Generate DDL
Generate encrypted password
Generate Text
Generating an Export statement
Getting help
go
Grid usability concepts
Gui Query Builder
Gui Query Builder - Columns Tab
Gui Query Builder - Gui Tab
Gui Query Builder - Options Tab
Gui Query Builder - shortcut keys
Gui Query Builder - Table / Joins Tab
Gui Query Builder - Where Tab
H
Having Clause
history
history
SQL statement
How Numeric Values are Displayed
How the Data Compare compares values
HP SQL/MX
HTML
HTML
creating from table/query
I
images
images
loading
Including comments in your SQL
Informix
Informix
Options - Display Options
showing the rowid
Informix - Admin notes
Inserting
Amending individual rows
Editing table data
editing tables
Exporting Data
exporting table as INSERT statements
inserting a similar row to another one
inserting rows
Row display and row change
Running an action SQL statement
Inserting BLOBs or CLOBs
Installing and Uninstalling AQT
Installing AQT on a 64-bit version of Windows
Installing AQT under Citrix
Installing AQT under Windows 2003 Terminal Server
introduction
Introduction to AQT
J
joins
building
Gui Query Builder
User-defined relationships
K
Known Problems
L
Layout of AQT windows
Limitations of evaluation version
Link to Related Tables
Load method
Load options
Load problems
LOBs
inserting from files
displaying
Displaying BLOBs and CLOBs
inserting
Inserting BLOBs or CLOBs
loading from files
Row display and row change
updating
M
Main features of AQT
Manage Authorities
Manage Foreign Key
Manage Index or Primary Key
Manage Object
Manage Procedure or Trigger
Manage Table
Manage View
Managing Indexes, Keys and other parts of a table definition
Managing your ODBC Datasources
Map to target from source
Maximum column size 200 bytes
Misc Load notes
Misc Options
MS Access
MS Access: Data Loader unable to start
MS SQL Server
MS SQL Server - Admin notes
multi-table joins
Multiple Data Display windows
Multiple query results
Multiple result-sets
Multiple Select statements
Multiple SQL Windows
MySQL
MySQL - Admin notes
N
No windows visible in AQT
Notes on Favorites
O
ODBC
Database types and config files
sysinfo API call
System-table query feature
table info
ODBC drivers
ODBC trace
options
async queries
BLOB columns
config files
Database types and config files
Options - Config Files
Options - File Locations
Database types and config files
debug
Displaying table contents
file locations
Database types and config files
Saving and opening a query
format of binary columns
format of date columns
format of null values
format of varchar columns
max col size
Displaying table contents
Options - Display Limits
max rows
max rows displayed
ODBC table info
option
Options
Options - Config Files
Options - Display Format
Options - Display Limits
Options - File Locations
Options - General
Options - LOB Options
Options - Table information
Options - Technical Parameters
parameters
Quote Table and Column names
Running multiple statements
saved queries
Saving and opening a query
semicolon
stop on error
System-table query feature
table info
use semicolon
Options – Run SQL
Options - Auditing
Options - Cancel Queries
Options - Config Files
Options - Display Format
Options - Display Limits
Options - Display Options
Options - Explain Plan
Options - File Locations
Options - General
Options - History
Options - LOB Options
Options - Syntax Highlighting
Options - Table Editing
Options - Table information
Options - Technical Parameters
Options - Unicode Options
Options - User Rights
Options - Window Behaviour
Oracle
Date and time columns
Explain Plan
NLS_DATE_FORMAT
Date and time columns
Options - Display Format
Options - Display Format
Options - Display Options
Oracle
showing the rowid
Oracle - Admin Notes
Oracle - Database Explorer is Slow
Oracle - Diagnosing Connection Problems
Oracle error ORA-02041 while displaying remote data
Organise Favorites
Other displays
Other notes on database signon
Other options in the Run SQL window
output to file
AQT scripting
Exporting Data
outputting query-results to a file
running automatically
P
parameters
Adding parameters to a query
AQT scripting
specifying in script
switching off
Unable to display table information
Pervasive.SQL
Pervasive.SQL - Admin notes
Pivot columns
PostgreSQL
Printing
Problems updating data
Program source
Program source
generating
Q
queries (see SQL)
Query Explorer
R
Recent Signons
referential integrity
Registering AQT components to Windows
REM
rollback
Row display and row change
Rowcount for SQL Server and Sybase
rowid
rowid
include as part of table display
rowed
used in updates
Run from File
run SQL
running delete SQL
running insert SQL
running update SQL
Run SQL window - shortcut keys
Run Stored Procedure window
Run the load
Running a DB2 Command
Running a Stored Procedure
Running an action SQL statement
Running AQT under Window Vista
Running Data Compare in Batch
Running multiple statements
Running Oracle PL/SQL or SQL Server/Sybase Transact-SQL
Running SQL
Running your SQL
S
safe update mode
SAPDB / MaxDB
Saving / retrieving the display Layout
Saving and opening a query
Scriptin - Disconnect function
Scripting
AQT scripting
running a script
running unattended
Scripting
Unattended Batch Mode
Scripting - CloseXL function
Scripting - CloseXLFile function
Scripting - Connect function
Scripting - Datacomp
Scripting - Export Function
Scripting - Include
Scripting - Layout
Scripting - Load
Scripting - Options
Scripting - Parms Function
Scripting - Queryparm
Scripting - RenameButt
Scripting - Schema Compare
Scripting - Setparm
Scripting - Tran function
Scripting - Use Function
Scripting functions
Search Table
Searching for Data
Select load source
Selects return only 50 rows
semicolon
Shortcut keys
Signing on to a Database
signon
problems with
Simple DDL Generator
Specifying a table's general properties
SQL
retrieving results
Adding parameters to a query
Analysing your table
async queries
binary columns
building update/insert/delete statements
cancelling a query
Data Display window
Date and time columns
date columns
date columns (how displayed)
delimiting statements
displaying large columns
errors processing
Generate Text
generating
Grid usability concepts
Gui Query Builder
history of statements run
joining tables
multi-table joins
multiple statements
null values
number of rows displayed
Options – Run SQL
Options - Display Format
Options - Display Limits
Options - File Locations
Options - Technical Parameters
parameters
query timeout
result-set display
retrieving a query
Row display and row change
Run from File
running
running a script
running action statements (intro)
Running an action SQL statement
running large script file
Running multiple statements
Running SQL
saving a query
Options - File Locations
Saving and opening a query
Saving and opening a query
saving results
semicolon
Options – Run SQL
Running multiple statements
SQL history
statement delimiter
time columns
time columns (how displayed)
updating rows
User-defined relationships
varchar columns
SQL history
SQL window layout
SQLBase - Admin notes
Standard shortcut keys
startup command
Startup script
Stored Procedure problems with Sybase
stored procedures
stored procedures
running
Sub-Totals
Summary or Group-by queries
Sybase
Sybase - Admin notes
Sybase unable to display tables in Database Explorer
syncpoint
System Monitor
system-table query feature
config files
Database types and config files
Options - Config Files
config files (location of)
Database types and config files
Database types that AQT accesses
databases this works with
Displaying Data
displaying information on objects
introduction
Options - Config Files
Options - File Locations
problems with
switching off
System-table query feature
Unable to display table information
T
Table access grid
tables
access grid (Oracle)
Amending individual rows
amending rows (intro)
analysing
Analysing your table
Compare table definitions across two systems
comparing data
comparing definition across two systems
Comparing table data
copying rows (to the clipboard)
Data Display window
DDL generation
displaying an individual row
Displaying Data
displaying large columns
Displaying table contents
displaying table info
exporting as HTML
exporting as INSERT statements
Exporting Data
exporting to Excel
exporting to file
Generate Text
generating list of
Gui Query Builder
inserting/updating/deleting rows
joining
multi-table queries
number of rows
Printing
Row display and row change
Running SQL
showing the values of a column
Simple DDL Generator
Table access grid
table display window
User-defined relationships
Tabulation
Technical information
Teradata
Terminology
text
text
loading text columns
time columns
Date and time columns
format of
how displayed
Options - Display Format
timestamp
timestamp
format of timestamp columns
Tools
Transaction / Commit mode
Transaction mode issues
transactions
Troubleshooting
Two-Pass Compare
Typographical Conventions
U
Unable to display table information
Unattended Batch Mode
Understanding Foreign Keys
Unicode support
Unicode support with DB2
Unicode support with Informix
Unicode support with MySQL
Unicode support with Oracle
Unicode support with other databases
Unicode support with SQL Server
Unicode support with Sybase
Unicode support with Sybase Anywhere
Updating
Editing table data
editing tables
Options – Run SQL
Row display and row change
Running an action SQL statement
safe update mode
updating rows
Use Slots
User rights
User-defined Keys
User-defined Parameters
user-defined relationship
Gui Query Builder
udr
Gui Query Builder
User-defined relationships
User-defined relationships
User-defined relationships
Using the Gui query builder
Using the Window-list bar
V
varchar columns
varchar columns
showing length of
views
DDL generation
Displaying view definitions
Simple DDL Generator
W
What's coming up
What's new
Where Clause Syntax