Excuse me if I am missing something obvious here, but I can't use AQT to create a stored procedure. I mostly work with DB2 on iSeries (v5r3), but I also have...
By default, AQT interprets a semi-colon as an end-of-statement delimiter, so thinks you are running a bunch of separate SQL statements. You can correct this by...
Are there any plans to change the configuration queries for SQL Server 2005 to use the Information Schema views rather than querying the catalog object...
Phil, When we use the explain function in combination with a parameter substitution the parameter is not replaced by its value select * from employee_tabel ...
Morning Phil, Well, it's been awhile but have noticed with this latest version that if I have any comments after the SQL code and there is a substitution in...
Hi Nick, I havn't been able to reproduce this problem. Could you show me a sample of the SQL? Thanks. -- Troy Pascoe Technical Support Cardett Associates Ltd ...
Hi Ad, This is a bug in AQT. We will look at it and let you know when we have a fix. Regards. -- Troy Pascoe Technical Support Cardett Associates Ltd ...
Hi Ad, We have fixed this problem - you can download the fix from http:// www.querytool.com/aqt820i.zip (assuming you are running AQT v8). Phil. ... ...
Hi Phil, This was against version 8.1.6. That is weird on one machine I get the double parm entries from this query and on the other machine I get just the...
Hi Ad, Yes, it will expire on the 30/09/07, but before then we will release the official version. Regards. -- Troy Pascoe Technical Support Cardett Associates...
Hi Phil, Yes, that is what is happening but not on both machines just one of them. Really weird. Nick Hi Nick, So is the problem you are being requested for...
Hi Nick, Can you go to: Options/Run Sql/ Technical Parameters and click the ODBC Trace checkbox? Reproduce the problem, and then send me ODBC Trace file. NOTE:...
Hi Phi and folks, First, I love AQT. I have found an apparent bug with AQT 8.1.7 and AQT 8.2.0 Beta when using multiple monitors. Put the main AQT window in...
Hi Harold, Yes, this is a known problem with a third party component that AQT uses. Unfortunately, there isn't a solution to the problem at this time. The...
I have a table that was originally replicated but replication is turned off. When I attempt to alter the properties the table appears to have a bunch of...
Hi william, Can you tell me what version of SQL Server you are using? Also, can you send me a screenshot of the table? Thanks. -- Troy Pascoe Technical Support...
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...
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.
