I'm using the latest version of AQT and have been experiencing what appear to be timeouts when doing queries against large 9.2 and 10g databases. Generally,...
I have no immediate explanation for this. I presume that AQT isn't returning a response after more than 30 minutes. When you look at the active tasks running...
Hi Phil, We have created scripts to do mass data compares of a few hundred tables on different DB2 subsystems. We are using the append option - thanks again...
A good point. I'll put in an option to not show the message. If you run the compares as part of a batch script, you do not get the popup message. Phil. ... - ...
Hi! At the moment we're using tvo different versions of DB2 platform, namely 7.2 and 8.1. We've noticed that using of certain combinations of those makes AQT...
The best way you can help us diagnose this is by switching on Debug Mode (see Options > General). Once you have hit the problem, you can email me the debug...
DB2 z/OS V7 AQT V 7.1.5 When a result set of data is retrieved using an alias on a table, going into inline edit does not recognize the primary key of the...
This issue will be resolved in AQT v8. In this version, AQT will remember the unique key you specify for editing a table / view / alias. You will need to...
Hi Phil, Print data: The SQL statement that is included per default in the header will be cut off after a certain length ... Which is quite annoying: Could you...
Where will it be remembered? Will that be in a text file that we could create once and share with all users? Please don't put that in the registry. Thanks, ...
Hi! Using v7.1.5 When trying to compare two tables created with the same create tables stement in DB2 (z/OS) v7 I'm receivinf the following error message. ...
Your syntax is OK. It looks like there is an error in the Data Compare. I wonder if you can switch on Debug Mode (see Options > General), redo the compare,...
I'm editing a stored procecedure in a Sybase IQ (or ASA) database. The stored procedure contains semi-colons (;) in it. AQT assumes that this is the line...
Hi, use Options > Run SQL > Statement Delimiter > None. Phil. ... The stored procedure contains semi-colons (;) in it. AQT assumes that this is the line...
Hi! Is there a particular cfg file for a SQLDS/VSE DB2 database? With cfg files included we're not able to see the tables. Here's the log at connect: ...
There is no cfg file for SQLDS/VSE. We haven't had much demand for it. The problem you are getting here is because the DB2 Client is trying to read from the...
Hi Ron, To help you with this, I've implemented a new option into the Data Compare. You can now specify whether you wish to see the report file after the...
As may be seen from the debug file, AQT does: Select TEXT from SYSCAT.VIEWS WHERE VIEWSCHEMA=? AND VIEWNAME=? order by seqno and gets the response SQL0351N...
Hi Phil, ... -- Create Procedure dbo.test ... create procedure dbo.test () as truncate table DWEB002..TWEB149 return 0; When running this statement the OBDC...
I'm working with Your version 7.1.5 and DatabaseServer DB2/MT 8.2.2. I try to retrieve a clob using the LOB-option "send to files" but it does not work. Bug or...
When you say "does not work", what exactly happens? You need to click the "Do this for" > CLOBs option. If it still does not work, the best way I have of...
I installed the AQT and configured the ODBC datasource and I get the error, "TNS:could not resolve service name". I have mostly worked with sql server before...
Hi there, the AQT Help has information on how to configure datasources and connections to your databases. See the section "Configuring a Database Connection" >...
Hi Phil, Thanks for that. I was able to do a small test and it looked good. Regards, Ron ... file ... can ... hundred ... option ... get ... report ... ...
Hi Phil I am not sure if this is an issue that has come up on the mail list before - apologies if it has. I have been writing my first AQT script to batch run...
Yes, you are right. It looks like there is a bug in the INCLUDE function in that it doesn't deal with multiple statements on the same line. A fix for this will...
What do I need to do to connect to a db2 on another machine from my local aqt. I guess I need a driver to create a odbc connection, but where can I find a...
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.
