Hi, first try at AQT Batch Mode and need a little help with the connect string. Trying to connect to the master database on SQL Server 2000 server named...
If you already have an ODBC Datasource set up for the database (so that it appears in the AQT signon menu), you can just use the dbs parameter of the connect....
Phil, I think I find the cause. It must be the retrieval of the query itself ( in the box below) which take some time on my PC. I also have to wait when I open...
Actually, the query is held in memory, so doesn't need to read the disk. I have an old PC that also takes a large amount of time to do open-query etc. Turned...
Hi We use Sybase IQ and since AQT does not have a config file for it, we use the Sybase Anywhere configuration and this works great. We recently upgraded from...
Using the suggestion sent earlier, I was able to connect to SQL Server. I am inclosing the fix you sent here so others on this forum may benefit as well: ...
Your solution sounds like the best option. I will investigate making this change to the Sybase Anywhere config files. Phil. ... we use the Sybase Anywhere...
And can be downloaded from http://www.querytool.com/aqt713q.zip It has a number of minor fixes and enhancements. For more information about what is in this...
Hi! We are very pleased with the AQT product. We use it with DB2 for z/OS Version 8. When you open a new connection, AQT starts by doing a "Select distinct ...
This could be achieved by putting a dummy entry in the cfg file. I'll come up with something and get back to you on this. Phil. ... z/OS ... distinct ... ...
AQT opens what ever is first in the menu1 area of the config file. You should be able to put whatever you want to use most often first in that list, and it...
Jim, Thanks for your hint. I'm not that familiar with the config file, but I moved Procedures to the top and now, when I start AQT I get the Stored Procedures...
hi phil, if i use 'export data to' - 'delimited file', enter a name and then change to i.e. 'fixed format' only the extension was changed. the only format...
By default, the filename is the table-name plus the file-type appropriate to the export format. For Excel, the file name defaults to output.xls and the...
Could the "Cancel AQT Query" popup be given a minimize button? Perhaps an option that makes it default to minimized. It's nice to have there, but normally...
Phil, I'm using the new extended compare for several tables in a schema on DB2 for z/OS, and I'm finding it running really slow. A monitoring tool indicates...
its ok. but if i type in a differnt filename an then change to 'Excel' the name will be overwritten to 'output.xls' and not only the extension will be changed....
Yes, this is a poorly performing query. I will improve it. If you go to file db2390_adm.cfg and change query 54 (near the bottom) to: SELECT part.LIMITKEY FROM...
Yes, other people have asked for this to. I'll do some work on it. Phil. ... Perhaps an option that makes it default to minimized. It's nice to have there,...
At the beginning of AQT the signon screen can show the most recent datasource signons with their usernames and passwords automatically put in the proper boxes....
Thanks Phil. That's way faster. One problem. "PART" is a reserved word, so I changed it to "tpart": SELECT tpart.LIMITKEY FROM SYSIBM.SYSINDEXES ind,...
I can add the ability to delete an entry from the list (right-click and select Delete). I presume this will do what you want. This will be in AQT v7.1.4. I...
A version of the Cancel Query task that has minimise-to-system tray can be downloaded from http://www.querytool.com/aqtcancel.zip I have added an option (to...
Hello Phil, when opening a file having the attribute "write protected", AQT igores it. That means, I can edit the file and save it, an it is overwritten ...
A good point. Shouldn't be too hard to do. AQT already supports read-only files (eg. if you open a file using the standard windows open dialog and check "Open...
How about automatically scanning the ODBC datasource, and removing the entries not found in there? (I think that the defined ODBC must exist somewhere in the...
I installed the new DLL. The cancel dialog no longer comes up. Now when I change the time on the cancel query option, I get a message: Processing error at...
Hello Jim, no, you Do not need to be on 7.1.3. I am, but I get the same result. I've renamed the old DLL, too... Was a wise decision :-) Peace Josef ... up....
Hello Phil, when starting statements in the window "Run Multiple Statements", there are the options Stop On Error: ( ) Yes ( ) ignore errors on drops ( ) No...
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.
