Good Morning, Our environment utilixaes the SQL Server Agent to run scheduled jobs. For the life of me, I cannot figure out how to access the SQL Server agent...
Sorry, we do not publish a list of our customers. We can tell you that we have been operating since 1999 and have sold into over 60 countries. We can provide...
... sold ... Phil, Thank you very much for respecting the privacy and confidentiality of your customers. Aggregated data is one thing - actual names of ...
AQT doesn't link into SQL Server Agent per se. However you may be able to view some of the scheduled jobs by running some stored procedures (such as...
--aqt queryparm,parm="funder",desc="Agreement Funder",select= (select 'All' from dual union all select dhb_ssg || ' - ' || dhb_name from dssadm.dim_dhb where...
It looks like this can happen if the (second) query returns no rows. In this case AQT puts <1> in the parm value. I'll correct AQT so that, when no rows are...
Can someone tell me how to specify the aqt connect command for DB2? 9/13/2007 3:54:22 PM Running : --aqt connect,dbs=DDDDDDD userid=IIIIII password=PPPPPP ...
They both definitely have rows returning and the parameter drop lists show this. When I swap the parameters around the 'new' second parameter fails. The...
I've set up a queryparm very similar to this, and I can't reproduce the problem. It could be useful if you could switch on debug mode (see Options > General),...
Hello, We have a licensed copy of AQT extended edition v 8.1.7. I connect to a local postgresql database, v8.2.4 and try to generate a DLL for the tables and...
This was an oversight on our part. I'll email you a cfg file which will implement DDL for functions. Phil. ... generate a ... the ... menu. ... Administration ...
Hi, I've been using AQT 7 for a couple of months now. Since I upgrades to Vista I was no longer able to use the SQL window in AQT. Today I deinstalled AQT 7...
Hi there, tabctl32.ocx should be installed as part of the AQT install package. It looks like this was not installed correctly. Make sure that you are logged on...
A day or so ago I got a warning that my history file was large. Now when I ask for History (ctrl-H) the only thing showing is the last statement that was run....
Hi Phil, As a very happy user of the AQT v8.2 beta, I am concerned that when I get to work on Monday, Oct. 1, my 8.2 AQT will not work. Granted my 8.1.7 is ...
Don't worry - I haven't forgotten about the 30 Sep deadline (I'm running the v8.2 Beta also!). We will be doing the official release of v8.2 within the next...
And can be download from http://www.querytool.com/download.html For info on what's new in this release, see http://www.querytool.com/ whatsnew.html For those...
AQT 8.2.1 looks really good. I am very happy to see the DB Monitor. It can be of great help to any DBA. It looks very similiar to DB2Mon which is a link on...
The Force Application feature is there for DB2 v9 only. AQT doesn't have any internal hooks into the database, but goes through the standard SQL interface. In...
Hi Phil, When i'm trying to generate DDL for table-controlled partitioned table in AQT v.8.2.1 it is not giving me the PARTITION BY keywords. I have created it...
Hi Phil... I work in a PeopleSoft environment in DB2/zOS and in a single DB2 subsystem I have 5 PS databases with over 30,000 objects EACH. When I do a Compare...
I would like to take this opportunity to invite the AQT fans on this list to go update the AQT page on Wikipedia with the new features. It's against Wikipedia...
I've been tossed in the SQL Server pool (deep end). The AQT display is rather different from DB2; no extended column info, for example. I did a bit of work...
That's up to IBM. AQT doesn't have any internal hooks into the database, but only gets information that is available through the normal SQL interface. For...
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.
