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 1248 - 1277 of 4217   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
1248
Use a comma to delim your userid/password, not a semicolon. Eg. --aqt connect,dbs=gogdbm,UID=xxx,Epwd=xxx Phil....
Phil Castle
cardettnz
Offline Send Email
Dec 1, 2004
6:02 pm
1249
I received the same result: 12/1/2004 1:43:48 PM -----AQT started 12/1/2004 1:43:48 PM -----Processing file batch_sample.sql 12/1/2004 1:43:48 PM Running :...
Jelonek, Joe
javelin71amc
Offline Send Email
Dec 1, 2004
6:46 pm
1250
You still have a semicolon between gogdbm and UID. Change this to a comma. Phil. ... [ODBC] ... I ... 3001176/ ... ...
Phil Castle
cardettnz
Offline Send Email
Dec 1, 2004
7:16 pm
1251
I now get: 12/1/2004 2:47:31 PM -----AQT started 12/1/2004 2:47:31 PM -----Processing file batch_sample.sql 12/1/2004 2:47:31 PM Running : --aqt ...
Jelonek, Joe
javelin71amc
Offline Send Email
Dec 1, 2004
8:21 pm
1252
I got it. Sorry as I was mixing and matching a few things. This worked: --aqt connect,dbs=gogdbm,user=xxx,epwd=yyy ________________________________ From:...
Jelonek, Joe
javelin71amc
Offline Send Email
Dec 1, 2004
8:25 pm
1253
Hi, In a high-level manner, how come AQT is faster than other software in terms of querying stuff in database? John...
bichonfrise74
Offline Send Email
Dec 1, 2004
9:40 pm
1254
A number of reasons: a) we use native ODBC calls, which gives AQT very fine control of the database interface. This means that AQT has lesser impact on the ...
Phil Castle
cardettnz
Offline Send Email
Dec 2, 2004
8:05 am
1255
I am executing a select where one of the columns is a varchar(255) in a Sybase database. For each row returned I get a message Data Truncated and the data in...
Paquette, Sylvain
sjpaq
Offline Send Email
Dec 2, 2004
3:47 pm
1256
Phil, I have WinXP SP2 and it comes with Windows Installer installed. I have not yet been succesful in upgrading. Thanks. Daniel ... installed. ... interrupted...
Daniel V Gomes
danvgomes
Offline Send Email
Dec 2, 2004
6:51 pm
1257
Go to Options>Display Limits. Set Maximum Column Size to (say) 500. You probably have it set to something lower. The Maximum Column Width sets the maximum...
Phil Castle
cardettnz
Offline Send Email
Dec 3, 2004
9:51 am
1258
I have no further ideas as to why you are having trouble installing. However you can do a "manual" install: a) download http://www.querytool.com/aqt614alt.zip ...
Phil Castle
cardettnz
Offline Send Email
Dec 3, 2004
10:00 am
1259
Phil, Managed to solve the install/upgrade problem. Microsoft has a support document under it. Here is the solution for 'error:1324 "The Path My Pictures...
Daniel V Gomes
danvgomes
Offline Send Email
Dec 3, 2004
2:26 pm
1260
Some of our end users are not very savy. I would like a user to click on the AQT shortcut, connect and run a query from a file displaying the output on the...
javelin71amc
Offline Send Email
Dec 8, 2004
4:21 pm
1261
At this stage the startup script just allows you to connect to a database and run some (non display) SQL that (for instance) sets some environment attributes. ...
Phil Castle
cardettnz
Offline Send Email
Dec 9, 2004
9:08 am
1262
That sounds great Phil ! ________________________________ From: Phil Castle [mailto:group@...] Sent: Thursday, December 09, 2004 4:07 AM To:...
Jelonek, Joe
javelin71amc
Offline Send Email
Dec 9, 2004
3:17 pm
1263
Hello Phil, there is an error in the SQL-syntax the function "Build Query" generates. I think, the error happens when the original syntax uses the "join"- ...
radisma
Offline Send Email
Dec 9, 2004
6:00 pm
1264
Hi Phil My DBA's have set up Heterogeneous links in my Oracle 9i database to my Sybase ASE 12.5 database but when I try to query tables in Sybase from Oracle...
Sandra Monk
sandramonk
Offline Send Email
Dec 9, 2004
9:40 pm
1265
Hi, I wonder if you can generate a debug file for me (see Options>General Options) and maybe also an ODBC Trace (Options>Technical Parameters) and email these...
Phil Castle
cardettnz
Offline Send Email
Dec 10, 2004
1:38 am
1266
You are right. I'll correct this in AQT v6.1.7, due out at the end of the weekend. Basically AQT has trouble with join conditions which don't involve both...
Phil Castle
cardettnz
Offline Send Email
Dec 10, 2004
1:43 am
1267
and can be downloaded from http://www.querytool.com/aqt617.zip It has a number of bug fixes and minor enhancements. Details can be found at...
Phil Castle
cardettnz
Offline Send Email
Dec 12, 2004
8:56 am
1268
DB2. version 7.2 z/OS Temporary database created Statements launched from AQT A. 1. create global temporary table tb (id integer, namn char(20)); 'OK' Creates...
thomasbostedt
Offline Send Email
Dec 13, 2004
10:16 am
1269
I think the problem here is that Db2 global temp tables only exist in the same unit-of-work in which they are created. By default, AQT does a commit after...
Phil Castle
cardettnz
Offline Send Email
Dec 13, 2004
10:21 am
1270
Just been testing AQT v6.1.7 with SYBASE ASE 12.5 I've noticed that since AQT v6.1.6 the commented out drop statement for the generate table isn't working. (It...
polson03
Offline Send Email
Dec 13, 2004
11:15 am
1271
will be spending time with XDB, but not MainFrame Express; that is, i don't have an MFE installation on my machine. so AQT is my access to XDB databases....
ryoungbugs
Offline Send Email
Dec 13, 2004
2:05 pm
1272
... doh!! it's called Data Loader. not that i have permission, or so it says. ... i ... to ... find ... to...
ryoungbugs
Offline Send Email
Dec 13, 2004
4:32 pm
1273
Phil, This new feature works well and give me a way to auto login and present the user with the results of my SQL. Thank you for making the time to do this....
javelin71amc
Offline Send Email
Dec 13, 2004
5:23 pm
1274
Hello everyone I have been trying to insert about 52 million rows into a table. However, AQT seems to be stopping after 9757916 rows. I get a simple message...
aqtevaluator
Offline Send Email
Dec 13, 2004
9:19 pm
1275
Hi Phil, i'm using AQT 6.1.6 adv. i try to create DDL's using Option 'Send Output to one file per object' and define a directory that does not exist. AQT asks...
dbfan111
Offline Send Email
Dec 14, 2004
2:13 pm
1276
I can't think of any reason why this might happen. AQT just passes your SQL to SQL Server for processing (AQT itself doesn't do the insert). It could be that...
Phil Castle
cardettnz
Offline Send Email
Dec 14, 2004
8:05 pm
1277
I just tried that, same results.... strange, it always seems to stop at exactly 9757916 rows. ... I ... or...
aqtevaluator
Offline Send Email
Dec 15, 2004
12:07 am
Messages 1248 - 1277 of 4217   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