Hi Phil, It's been a while but I wanted to follow up with your reply. I went ahead and updated to the latest version of the Oracle ODBC driver available and...
AQT uses ODBC, whereas TOAD and SQL Developer do not. This is why these products are not affected by the short-comings of the ODBC Driver. AQT can display the...
Hello everybody, i'm using aqt 7.1.1 and i work with aqt for get access to very big tables in SQL Server 2005 and Informix, many of them have 15 or 50 millions...
The data was copied from sql server 2005 and informix directly, we just access the data using aqt, i made a count of records and tables had more than 20...
Hello Luis, try to specify one of the following SQL-Clauses: 1.) "FETCH FIRST x ROWS" and/or 2.) "Optimize for nnnn Rows" with x as an greater number than the...
Hi Luis, I suggest you install the latest version of AQT v7, which you can download from http://www.querytool.com/aqt718m.zip - this is just an updated exe,...
I've found two ways to do this. 1. Update TABLE-1 but reference TABLE-2 in the WHERE clause. This example updates a column in TABLE-1 for only those records...
Sometimes the formatting gets lost when sending SQL text into Yahoo, but I'll try anyway. Right now the formatting option sets the indenting left adjusted as ...
Hi Phil, i copied http://www.querytool.com/aqt718m.zip to my AQT directory and now everything is ok. Thank you very much...! and thanks everybody too...! Luis....
OK, received it OK. I'll guess the formatting is a matter of person choice. I prefer having the keywords at the left. Though is does make sense to have the...
When you count the rows in a table (using the Analyse-> Number of Rows function), you need to add "WITH UR" on all DB2 platforms. I just found this working...
Hi Phil - I've been seeing some odd things with DB2 views. It doesn't occur on all, or even the majority of, my views,but it is a reasonably frequent problem....
Hi, I have to extract a query result table to a text or csv file with a specified record length given by a record layout. I can extract data but the record...
When running in compatibility mode, column TEXT in SYSIBM.SYSVIEWS has been changed to a Blob. The result is that the data comes through to AQT as EBCDIC. AQT...
This isn't really all that easy. The Fixed Format export is probably the closest to what you are wanting - in this the columns are given a fixed length....
Hi Phil, I just cannot get the connect working in our environment. See the coding below. The documentation about the parameter 'dbs' is not quite clear. Is...
See examples in batch_sample.sql in your AQT directory. In your code below you should use: --aqt connect,dbs=DBSPART1_GSYS,user=hotz02,pwd=password not...
Hi Phil, When using the dataloader via batch and setting the option 'delete table contents before loading' (del=y) we get this processing error. Not using that...
I'm not sure why this isn't working for you - works OK in all the tests that I have done. What version of AQT are you using? Phil. ... supposed to. ... ...
This looks like a bug. Will fix in the forthcoming AQT v8.1.6. I can send you a fix if this is an urgent problem. Phil. ... table contents before loading'...
Hi Mark, as mentioned in the previous post, this error is due to the ebcdic- ascii conversion. AQT attempts to work out whether a string is ascii or ebcdic...
Wow, quick work! Thanks Phil. No emergency need - it' more of an annoyance factor for now, and I'm guessing the 8.1.6 isn't too far away since it's been a...
It is rather urgent. Also, i could test that for you. Andreas ________________________________ Von: aqt@yahoogroups.com [mailto:aqt@yahoogroups.com] Im Auftrag...
if i specify the logon name in brackets after the dbs parm as in -- aqt use,dbs=DBQPARI1 (art) it works. Andreas PS.: we use AQT 815, connecting to Sybase ASA...
You can download a fix from http://www.querytool.com/aqt816q.zip This release hasn't been fully tested. I recommend taking a copy of your existing aqt.exe...
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.
