The history files go into the "Default Directory for files created by AQT" as defined in the Options -> File Locations. The default is the program directory....
AQT will only move the files to sub-directory "workfiles", if the "Default Directory for files created by AQT" is the program directory. If this is some other...
Hi Phil, I installed the latest beta 8.0.6 and see that sequential table ID's are still quoted (e.g. Tablename "a"). This doesn't work on DB2 for iSeries. I...
A new schema was added to a database, to which I have access through AQT. This new schema is not showing in my list of tables down the left hand side on AQT....
I've used the AQT DDL export feature extensively with DB2 (LUW version 8.2). It's great. Howerever, for one procedure -- perhaps others -- a portion of the SP...
Hi! Just thought I'd mention this as it has become an annoyance. I use AQT to connect to an Informix db and an Oracle db (10.1g). Everything works fine except...
The problem here is that the Oracle ODBC Driver does not handle Timestamp (or Interval) data types and will crash if they are retrieved. AQT has a crude...
That does seem odd. I'm not sure where the Missing Code ("LOOP_LABEL2> 'I'" etc) fits in with the Complete Code. Perhaps you can send me the complete Create...
Phil, Maybe for the new v8 (since some of the GUI is being reworked), the ability to configure a different 'background' color for the SQL and the results...
Hi Phil - Here is the procedure --- a good and a chopped version. In a quick test, the identical chopping occurs in two sepate DB2 instances and databases...
Yes, this is a good idea, and one that has been in my mind for a while (I have run a script against prod by mistake too!). The problem is finding a consistent...
Hi Phil --- I replaced aqt.exe in Program Files with the new version. Success. Many thanks. AQT is the best product on the market! Best regards, Chris ... ...
Hi, I've got a user request for "Copy options" dialog (that appears when pressing CTRL+C). The user is frequently using the copy function to copy rows from a ...
Phil, Is there a way in the oracle.cfg to do a 'Describe' instead of a SELECT to retrieve information on an object? The problem we have is showing columns (and...
Hi Phil, the posted problem still exists in the newest version. Yesterday I was changing between the windows of AQT, EXCEL and the MS- IE very often. And...
What seems to be happening is that when you go back to AQT / Run SQL window, the text area hasn't got focus, instead focus is on the menubar. You can do this...
You are right, this does appear to be the case. It seems that when the Abort button is not visible on the toolbar it is inactivated. This may be the way the...
No, that's not the reason. The focus is definitly in the text. For example after selecting text with the mouse I can copy/paste it with the right-Mousebutton...
AQT fans! Here's your chance to pine about your favorite query tool. I just started a Wikipedia page for AQT: http://en.wikipedia.org/wiki/Advanced_Query_Tool...
Thanks! Yes, you may use text from the querytool website. Other databases you can list are Pervasive PSQL, SQL Anywhere, Firebird, MaxDB, Interbase. Phil. ... ...
I love AQT and am using it to administrate both DB2 and Oracle. My problem is with Oracle. When I start the tool up and click on the table schema name, it...
Just a followup - I tried downloading the Beta version and there is a definite improvement. Now it only takes 3-4 seconds to do the initial table loading....
This is true. AQT gets the information on objects in the Database Explorer window by using the SYS.* catalog views. Unfortunately these views are slow as they...
Haven't seen a response for this. I did notice the 'Run SQL' window will display the column names using v8 only, not v7. But neither version display's synonym...
Sorry for not replying earlier - it slipped through the net. What you say is true. In AQT v8, when getting the columns for a table (in the Run SQL window,...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
