Thanks Troy, I appreciate the response. I'll look into it. I did find that at least the explorer window opens a lot quicker when it is in "Favorites" mode...
Hi, Sorry, I haven't received the debug file. Could you send the debug file too: troy@... Thanks. -- Troy Pascoe Technical Support Cardett Associates...
Using DB2 UDB v 8.2 and 9.1 I have a large number of schema within the database. What do I need to do to configure AQT 8.2.2 to allow me to see the schema...
The standard displays shows you Tables and Views, Indexes, Procedures etcs, then within these all the Schemas. Are wanting the high-level to be the schema...
Hi: I had sent this earlier..here it is again. I am able to see functions in Oracle Enterprise manager with the same userid so it is not a problem with not...
Thanks, got it. We are currently looking into this problem. The view used to display Functions in Oracle is a very complicated one, using: SYS.ALL_OBJECTS. It...
This solved one problem. When I click on the Functions "tab" it expands quickly. But when I click on a schema to see which functions are there it hangs. ...
Wow, SYS.ALL_OBJECTS must now be so slow as to be virtually unuseable. If you change query 66 to: select o.name, decode(o.status, 0, 'N/A', 1, 'VALID',...
I'd love to see some AQT queries for DB2 9 (LUW) range partitioned tables. The other day, I was trying to have a peek at the partition definitions in AQT....
Hello, I've successfully created a batch file that prompts the user for the database name, userid, and password to use for the connection. This is all working...
Hi there, it isn't possible to give the user a list of all the Datasources defined on the system. If you know what database they need to connect to, but don't...
I have a few suggestions from our team (we love your product!) Syntax highlighting is great and helps to find the various parts of the query. We've been...
Thanks, we will take your comments into account for the next version of AQT (which we are working on). In the current version, it is not easy to dynamically...
This is a bug with Microsoft ODBC Driver for Oracle - it doesn't return any results when a WITH statement is run. There's not much AQT can do to circumvent...
To my knowledge, one cannot send a Shell command through to Linux. The MySQL ODBC Driver doesn't support this functionality. One way around this would be to...
I am trying to load a text file into a table, and the values get rounded using the AQT load utility. If I do it with insert statements it works. Prob is...
Not per se. However you can de-select them all (so none run) by clicking on the Select None button. Then to run a particular statement, click on the Run?...
This problem should be fixed in a new build of AQT, which you can download from http://www.querytool.com/aqt823h.zip Could you test this out to see if it...
I really need to know if there are known issues with ODBC/FoxPro and locks on the files? Also, are known issues wit Foxpro file locks and AQT before? I have...
AQT doesn't take any locks on the tables when it is just reading them. It reads a table in read-only mode, and as soon as it has finished reading the table it...
Not sure when this started, now on 8.2.3 (latest zip), but I can no longer update rows with x'FF' in a character column. Had not been a problem before....
additional info: - select doesn't work, either. not surprising. - running against our subsystem with SQuirreL 2.6.2 and the same DB2 client, the x'FF' don't...
What actual message do you get when you try to do the Update? Maybe if you can send me a debug log and/or ODBC Trace this would be useful. DB2 Connect will try...