Hi Phil - AQT v8.2.4 DB2 9.1, DB2 9.5 With larger DB2 stored procedures, both the "Procedure Text" display and the Generate DDL functions are not retrieving...
Hi @ all, I'm having the same "The memory could not be read" error occur while using DB2 and AQT 8.2.5 (in Batchmode). Options - Cancel Queries - 'Run the AQT...
Yes, this error sometimes happens when AQT is terminating. We've spent some time looking at this, however haven't found the cause. AQT has closed all it's...
I think the data is being exported OK, it's that Excel is choosing to display the data as dates rather than integers. It should display correctly if you go to...
I couldn't find a list of system (software and hardware) requirements on the website. Can someone please list the requirements for this software application...
AQT needs: . a version of Windows more recent than Win98, eg. NT, Win2K, XP, Vista, Windows Server 2003. . a database client and ODBC Driver for your database ...
I have a feeling the answer is: "don't do that", so the question is... When I attempt a simple (schema) compare between a table in an xdb database and the...
You should be able to do that. Could you generate a debug file and email this to me at phil@.... Also a couple of screenshots might be useful for me...
I think, and unless it happens with local (intra-net) xdb/DB2, the issue is a particular VPN setup. When on it, local (intra-net) drives disappear. Somehow I...
Defining it as an msaccess database in the config table partially works. It doesn't pick up the schema correctly. I'll send you an odbc trace created when I...
Hi, I'm using AQT for DB2 database. I want to run a query passing parameters at run time. Is it possible to do that? For example, my query looks like: SELECT *...
Yes, say: SELECT * FROM TABLE1 WHERE COL1 = ? Phil. ... parameters at run time. Is it possible to do that? ... the variable? ... intended solely ... recipient,...
I was hoping to be able to do the following, but I can't find a way to do it. May be there is a way? Table Foo has column Bar in database Baz. Bar has 100...
I would copy table Foo to OliverHardy then run a query such as: select * from DisplayValues where Values not in (select distinct Bar from Foo) Phil. ... ...
Yes, that will work. I was hoping for a way to do it with Data Compare, so I could pass it on to others; who may not be comfortable with table copies and the...
It may be possible to do it with Data Compare, but the method I outlined is probably the simplest. It is possible to set up a copy/query script (as per the...
Can you let me know what version of AQT you are running? I have been trying to reproduce this error you are getting (without success) - perhaps you are not...
Phil, I am running version 8.1.5, yep it is an older version. Is there something you would like me to try, or did you want to see the SQl. Terry 920-433-5112 ...
Thanks. I can't reproduce the problem in AQT 8.1.5 either. Could you go to Options > General, switch on Debug Mode, reproduce the problem, then email me the...
Phil -attached, this going after SQL 2005 DB
Terry
From: aqt@yahoogroups.com [mailto:aqt@yahoogroups.com] On Behalf Of Phil Castle
Sent: Wednesday, October...
Hi, we are using system monitor for our company (oracle 10g). Just wanted to confirm what tables a user needs access to in order for the system monitor to...
They need access to: Views SYS.V_$BUFFER_POOL_STATISTICS SYS.V_$ROLLNAME SYS.V_$SESSION SYS.V_$SQL SYS.V_$SQL SYS.V_$TRANSACTION Plus synonyms DBA_LOCK ...
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.
