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
|