Previous Topic

Next Topic

Book Contents

Book Index

Known Problems

The following known problems exist with AQT.

A number of these are because of peculiarities/bugs of ODBC drivers and/or the databases. You may or may not experience these problems depending on the level of software drivers you are using.

Area

Problem Description

Column Types for Sybase Enterprise and MS SQL Server

These are held in the system tables in a very complex way. Furthermore we have developed our queries to work on both SQL Server 6.5 and 7.0; this adds an extra degree of difficulty. Hopefully our queries will report on this information accurately but we make no guarantees!

Column Types for MS SQL Server

The column width is reported inaccurately for nchar and nvarchar columns (these are stored as Unicode and occupy double the space that has been declared – AQT picks up the space used).

Parameter Usage with Sybase Enterprise

This doesn’t seem to handle numeric parameters. Workaround: use Options > Parameter Usage > Use Substitution, or code your query as where id=convert(int,?)

Default values in DB2 z/OS

These are held in a complex way in the database that AQT doesn't yet handle accurately.

MS Access gets “Statement not Valid at this time” when running update.

Switch off Safe Update Mode (see Options > Run SQL).

ODBC table info

Many problems exist if you use Options > Table Info > Use ODBC. You wouldn't normally do this. When running in this mode AQT gets information on the tables from the ODBC API calls, rather than querying the system tables. There appear to be many bugs with these APIs.

Some of these problems also exist for non-catalog databases such as MS Access.

The circumvention for all these problems is to use Options > Table Info > Use System Tables.

Database type

known issue

most databases

don't give anything for the column Default value

Oracle Version 7

gives duplicate values for the table owner names

Oracle

is sometimes confused about what is a Table and what is a System Table

DB2

is sometimes confused about what is a Table and what is a System Table

 

doesn't give anything for the column Description