Index

Symbols & Numeric 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

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