My turn to ask the group a question, in case there are any DB2 z/OS v8 users out there. I have a customer who has asked for a new feature - they want all their...
At my DB2 V7/Zos site, most of the tables are accessed through an alias name and that's the way the programmers know them. When updating a table through the...
In the next version of AQT (v8), AQT will remember the key you have specified, so you will only have to specify it once. This is useful when you are updating a...
Phil, Could you make the SQL History resizable/maximizable, please? Is there any good reason to not do this? Also, being able to change the size of each...
You have a particularly old version of SQL Server, which has an older structure for the system tables. To correct this problem: a) find file sqlserver.cfg in...
This seems like a reasonable suggestion. I'll add it to our list of enhancements. It may not make it into v7.1.4 (for which I am doing the final testing). ...
Can you check the performance of the Data Export to Excel? 3K rows take about 1.5 minutes. Tab delimited only takes a few seconds. I really like the excel...
... database ... doesn't on our MainFrame 7.2 instances. i've wondered, but never pursued, whether this was due to our use of BMC, or that IBM didn't define...
... database ... doesn't on our MainFrame 7.2 instances. i've wondered, but never pursued, whether this was due to our use of BMC, or that IBM didn't define...
I am using AQT for a DB2/AS400 database. I have always used a period (.) as the separator for the table name (ie LIBRARY.TABLE). After returning from vacation...
Currently AQT writes data to Excel a cell-at-a-time, which is why this is slow. I have done some work on this; in the forthcoming AQT v7.1.4 the data is...
Hi, I have to say I have become a big fan of AQT. Since buying the admin upgrade, it does lots of stuff for me. And, of course, it opens up more questions. One...
Table SYSCAT.SEQUENCES should exist in V7.2. You may have had an earlier version of DB2 and upgraded it to V7.2. There is a migration step during the upgrade...
Yes, this can be done. However you will need to make a change to the Admin Config system (which is a little complicated). I will send you details (and a...
I am getting a "Processing Error at get_data_odbc. Invalid procedure call or argument" This was a query that was working before I upgraded from v6 to v7.1.3. ...
I'm not sure what is happening here. Can you switch on AQT Debug Mode (see Options > General > Debug Mode), reproduce the problem, then email the debug file to...
DB2 Z/OS V7 AQT 7.1.3 AQT does not show authority on global temporary tables, nor does it allow you to do a grant on it. One might think that global temporary...
I've figured out what is happening here. For MySQL, FLOAT data types are reported with a SCALE greater than the PRECISION. This causes an error when the...
And can be downloaded from http://www.querytool.com/aqt714.zip This has been built with a newer version of InstallShield - if anyone experiences any problems...
Hello Phil, (thank you for the resizable History-Window. Wonderful!) Asume I have a SQL-Window with an new statement (not already saved in the history). Then I...
Use Ctrl+R, and it works correctly. Once you have found something, then F3 should work, but you're right, it doesn't. Not even from the Edit menu. Peace, Jim...
Hi Phil, Here is another new bug in the new version: I have opened a readonly-file. After changing it and trying to save it, the 1. dialog ask me: "overide ...
Hi Phil, I've tried it again in a new session, and AQT worked correct. Sorry, but I cannot produce the bug again to find the circumstances. The effect happened...
You're right. Damn - there's always something that slips through the net. If you keep the Find window open and click on Find repeatedly it will refind through...