Search the web
Sign In
New User? Sign Up
aqt · Advanced Query Tool Discussion Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 3479 - 3508 of 4213   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
3479
Also, I am able to view functions via the Oracle Enterprise Manager Console. Any ideas on why the query hangs with AQT? Thanks, Mavin...
mavincomputer
Offline Send Email
Dec 3, 2007
8:26 pm
3480
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...
palmerb3
Offline Send Email
Dec 3, 2007
8:28 pm
3481
Hi, Sorry, I haven't received the debug file. Could you send the debug file too: troy@... Thanks. -- Troy Pascoe Technical Support Cardett Associates...
cardett_troy
Offline Send Email
Dec 3, 2007
8:32 pm
3482
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...
Edd M. Jentzsch
eddjench
Offline Send Email
Dec 5, 2007
7:17 pm
3483
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...
Phil Castle
cardettnz
Offline Send Email
Dec 5, 2007
7:27 pm
3484
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...
The Computer Mavin
mavincomputer
Offline Send Email
Dec 5, 2007
7:41 pm
3485
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...
cardett_troy
Offline Send Email
Dec 5, 2007
8:58 pm
3486
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. ...
The Computer Mavin
mavincomputer
Offline Send Email
Dec 6, 2007
8:13 pm
3487
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',...
Phil Castle
cardettnz
Offline Send Email
Dec 6, 2007
8:29 pm
3488
Thanks it works like a charm! Phil Castle <group@...> wrote: Wow, SYS.ALL_OBJECTS must now be so slow as to be virtually unuseable. If you change...
The Computer Mavin
mavincomputer
Offline Send Email
Dec 6, 2007
8:36 pm
3489
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....
cjbraudy
Offline Send Email
Dec 7, 2007
4:52 am
3490
A good point. This type of query is easy to add to AQT. I'll let you know when I have something. Phil. ... partition...
Phil Castle
cardettnz
Offline Send Email
Dec 7, 2007
5:11 am
3491
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...
dsemmler
Online Now Send Email
Dec 11, 2007
1:03 am
3492
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...
Phil Castle
cardettnz
Offline Send Email
Dec 11, 2007
9:10 pm
3493
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...
jasontimms
Offline Send Email
Dec 12, 2007
7:19 pm
3494
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...
Phil Castle
cardettnz
Offline Send Email
Dec 12, 2007
8:58 pm
3495
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...
Phil Castle
cardettnz
Offline Send Email
Dec 13, 2007
8:12 am
3496
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...
Phil Castle
cardettnz
Offline Send Email
Dec 13, 2007
8:15 am
3497
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...
mark_aqt
Offline Send Email
Dec 13, 2007
7:46 pm
3498
Hi, This looks like it might be a bug. We will have a look at it and get back to you. -- Troy Pascoe Technical Support Cardett Associates Ltd ...
cardett_troy
Offline Send Email
Dec 13, 2007
10:03 pm
3499
OK, thanks. Were running the AQT extended version 8.2.2 ... get ... amount ... NULL , ... NULL ,...
mark_aqt
Offline Send Email
Dec 13, 2007
10:54 pm
3500
In "Run Multiple SQL Statements" window, is it possible to "Step" through the queries, rather than run them all?...
Michal Pasniewski
michalp
Offline Send Email
Dec 14, 2007
10:14 pm
3501
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?...
Phil Castle
cardettnz
Offline Send Email
Dec 15, 2007
9:30 am
3502
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...
Phil Castle
cardettnz
Offline Send Email
Dec 17, 2007
4:07 am
3503
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...
gavinjolly
Offline Send Email
Dec 17, 2007
9:16 am
3504
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...
Phil Castle
cardettnz
Offline Send Email
Dec 17, 2007
7:23 pm
3505
Yup, that did the trick. No more rounding errors on loads. Thanks ... we ... and ... NULL...
mark_aqt
Offline Send Email
Dec 17, 2007
9:16 pm
3506
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....
ryoungbugs
Offline Send Email
Dec 18, 2007
2:39 pm
3507
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...
ryoungbugs
Offline Send Email
Dec 18, 2007
4:19 pm
3508
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...
Phil Castle
cardettnz
Offline Send Email
Dec 18, 2007
8:24 pm
Messages 3479 - 3508 of 4213   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help