I have display limits set to 500 on AQT. Now I have a table that has 50,000 rows in it. I need to see all the rows in the table, but I don't want to set...
I running AQT 6.1.5 and I am having a problem in the graphical query builder. If I have a non column based column and double click it in order to modify, the...
I solved the problem with a new installing of the Oracle ODBC Driver (9.2.0.5.0). This version contains a bug fix for the fractional seconds of the timestamp....
It is a bug for the column to be marked as column-based when it is not. I will endevour to fix this in AQT v6.1.6. However, this is not a major problem. If the...
Based on my original request (see below), I've gotten several responses that suggested they could better help me if they knew what type of database I'm...
In the AQT database explorer for SQL Server, the bottom item on the left is Columns. This gives you all the column names in your tables; when you click on one...
well, the clob issue [not being able to pass one back to V8 from down level server] seems to apply to the generate DDL function (new, better one). this is an...
... would anybody have the new db2390.cfg?? i've updated any number of times since, but i guess i've got an old copy??? i'm now able to connect to 390/v7.1...
Does AQT support DBMS conversion efforts - such as taking a table from zOS/DB2 to Unix/Oracle with consideration of the different datatypes and is it possible...
Being able to do this is the holy grail of cross-platform database administration. AQT can't do this, though we are moving in that direction. In AQT V7 we plan...
... i've had to deal with this issue in two ways: moving a DB2 schema definition to Oracle, and moving DB2 data to Oracle. as to the first, i suppose an...
when i try to multirun sql (a lot of it) i ancounterd the following message "processing error at do_sql Overflow" what is it, it worked fine on the previous...
I wonder if you could tell me: a) what version of AQT are you using? b) how may SQL statements are you running? c) are you using Run From File? Phil....
a) 6.1.5 b) Itīs works great up to about 30 000 sql statemets, In previous versions i have been running upp to 300-400 000 statement itīs insert into ..........
By cooincidence I have been doing some work on this function for AQT v6.1.6 - been putting in performance improvements to make the loading of the script...
... i will wait for the Official Release. but i now realize that this is getting more and more like Christmas Eve --> i Really want what's in that shiny new...
Geez, some people are never happy. We release a new point release, with fixes, every month or two. If anyone has an urgent problem, we provide a prompt...
... we ... resolution ... us, ... from ... in ... ummm Shiny New Package [although the pig one resonates] (and this was a bon mot to, not a complaint about,...
I am having a rounding problem when I run the following queries in Sybase. declare @bob_14_9s float declare @bob_15_9s float select @bob_14_9s=6.99999999999999...
Hi Phil, I've just installed the new Fixpack 7 for our DB2 8.1 dabatase. Previously the DB2 Advisor run perfectly well from AQT 6.1.5 But after the Fixpack I...
I suspect that this is an issue with the Sybase ODBC Driver. I have tested this query with another ODBC-based product and it returns the same results as AQT. I...
These are scheduled for the next version of AQT (v7). This will have a) a Data Compare tool. This will be able to display and report on the differences in the...
Looks like the syntax of the db2advis command has changed with the introduction of FP7. Unfortunately the command that AQT uses is hard-coded in AQT, rather...
I have a Sybase IQ DB stored procedure when I run it from an AQT sql window, I do not get the output from the stored procedure message command (message 'Error=...