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 to share photos of your group with the world? 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 2975 - 3005 of 4213   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
2975
Are you still planning on doing this? If this is already done can you tell me how to access it? I have version 8.1.3 of your product and I don't see how to...
atfalatitkb
Offline Send Email
Nov 2, 2006
7:02 pm
2976
Hi, I would like to buy the software from Mexico (I already have my bur reference), just I want to know if once I made the payment, the software will be...
Snap
snapmx
Offline Send Email
Nov 2, 2006
7:06 pm
2977
There's no shipment of a physical product. When you purchase a license you will be emailed a license key. When this is loaded into AQT, it turns it from an...
Phil Castle
cardettnz
Offline Send Email
Nov 2, 2006
8:58 pm
2978
At the top of the list-of-procedures is the Admin Toolbar. Click on the 5th of these icons, this has a dropdown, select Compile. This will show you a window...
Phil Castle
cardettnz
Offline Send Email
Nov 2, 2006
10:12 pm
2979
Thanks for the quick response. I couldn't locate any info on compiling in the help. I have the standard edition of the product. The run button for the...
atfalatitkb
Offline Send Email
Nov 3, 2006
1:30 pm
2980
I apologize for the heading, but I have already tried to post this message, and it never went onto the board. I am running version 8.1.2, and I am having a...
Vandy125
Offline Send Email
Nov 3, 2006
4:32 pm
2981
I don't have any immediate suggestions as to what might be the problem here. It could be that your machine is running low on memory. Does the slow load-time...
Phil Castle
cardettnz
Offline Send Email
Nov 6, 2006
9:39 am
2982
Thanks for the input Phil! The issue occurs when opening the results windows for the most part. I have about 1GB of RAM in this PC, and I do not have problems...
Eric Vander Wall
Vandy125
Offline Send Email
Nov 7, 2006
3:19 am
2983
You should also check that you don't have an ODBC Trace switched on by mistake. This will definitely slow down your AQT session. See the ODBC Admin window >...
Phil Castle
cardettnz
Offline Send Email
Nov 7, 2006
5:07 am
2984
would like to learn more aabout how to features of AQT that support actions like: RUNSTATS - not only running this utility, but clearly seeing what tables...
darlenewolff
Offline Send Email
Nov 8, 2006
6:51 pm
2985
... would ... the ... have ... checking ... the ... to ... single ... I would like the option B. This would minimize the performance hit....
odotisd67
Offline Send Email
Nov 8, 2006
6:52 pm
2986
Hi there, Yes, AQT is more than just a query tool, and has many features for the DBA and Developer. 1. Runstats. AQT is able to run Runstats against your...
Phil Castle
cardettnz
Offline Send Email
Nov 8, 2006
7:41 pm
2987
This change was implemented in AQT v8.1.3, released on 9th October. We went for Option b. Phil....
Phil Castle
cardettnz
Offline Send Email
Nov 8, 2006
8:07 pm
2988
and can be downloaded from http://www.querytool.com/download.html For information on what is new in this release, see http://www. querytool.com/whatsnew.html ...
Phil Castle
cardettnz
Offline Send Email
Nov 13, 2006
10:01 am
2989
The improved load time for the data base explorer is great! It works for more than just table schemas. Tablespaces, columns, packages and procedures load...
Jim Herrmann
jim_kcsr
Offline Send Email
Nov 13, 2006
4:06 pm
2990
I would write a script in AQT to automate which should compare nearly around 200 tables in Informix with Oracle.If so any one can guide me how to do that. ...
sri_ya2006
Offline Send Email
Nov 15, 2006
9:44 pm
2991
Yes, this is possible to do. The Data Compare function of AQT can be scripted, so you can set up a batch job to run a large number of compares. Information on...
Phil Castle
cardettnz
Offline Send Email
Nov 16, 2006
2:59 am
2992
Sriya is wanting to write a script in AQT to compare tables in Informix with Oracle. If you are looking at comparing record numbers I have a script that...
Sandra Monk
sandramonk
Offline Send Email
Nov 16, 2006
8:08 pm
2993
Hello, I am trying to comapre two dates; In the database its stored as yyyy- mm-dd hh:mm:ss. How do I use the between function to just compare yyyy- mm-dd?...
sbrownassoc1
Offline Send Email
Nov 16, 2006
10:42 pm
2994
It depends on the database you are yousing, but you should use a function to get the datepart of the timestamp. Examples for DB2: ... WHERE date(timestamp1) =...
radisma
Offline Send Email
Nov 16, 2006
11:00 pm
2995
Thanks for your reply. I am using sybase. ... yyyy- ... compare yyyy-...
sbrownassoc1
Offline Send Email
Nov 16, 2006
11:45 pm
2996
I don't know of any tidy way of getting the date component, but you could say: where datepart(year,date1) = datepart(year,date2) and...
Phil Castle
cardettnz
Offline Send Email
Nov 17, 2006
1:02 am
2997
This is returned when using Sql History to re-load a Table Function statement: Unable to find columns for TABLE( Bar.SomeFunction('ZZZ') in database Foo Error...
ryoungbugs
Offline Send Email
Nov 21, 2006
4:36 pm
2998
This error happens when AQT tries to find the column-list for the "table" in your query. AQT gets confused by this form of statement - it is looking for...
Phil Castle
cardettnz
Offline Send Email
Nov 21, 2006
8:31 pm
2999
Sandra, I am looking for similar kind of script .Could you please share yours. Appreciated. Thanks Sriya Sandra Monk <sandra.monk@...> wrote: Sriya is...
SRI y
sri_ya2006
Offline Send Email
Nov 22, 2006
1:27 am
3001
Hi, Phil when I save the query: 1) SELECT DISTINCT paz.cognome, paz.nome, paz.nascita, trp.co_des 2) FROM DBA.cart_terap trp, 3) DBA.pazienti paz, 4)...
giorgiozani61
Offline Send Email
Nov 26, 2006
3:10 pm
3002
It could be that the Query Builder is having trouble interpretting your SQL. If you retrieve the query into the Run SQL window, is the SQL correct there? It...
Phil Castle
cardettnz
Offline Send Email
Nov 26, 2006
9:07 pm
3003
AQT815, Sybase ASA Hi Phil, When generating DDL for a table is it possible to take along the defauts i.e. default content such as 'current user', ' current...
andreas.hotz@...
andreashotzde
Offline Send Email
Nov 29, 2006
8:15 am
3004
AQT 815; sybase ASA Hello Phil, When looking at the text of a trigger via 'Full details of trigger .....', only the first 20 lines are shown on the screen....
andreas.hotz@...
andreashotzde
Offline Send Email
Nov 29, 2006
4:36 pm
3005
aqt version 7.1.7 1)is something like this possible. I get errors about dbmaster not open. Is there a way to reference a connection like this? I tried using...
williamstandkeiii
williamstand...
Offline Send Email
Nov 29, 2006
8:49 pm
Messages 2975 - 3005 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