I am installing AQT v 6.1.5 on a Windows XP SP1 machine. Two things are going crazy. It will not show a config file on the database properties when displaying...
exactly... how do you set this up... basically the flat file is in Server A, and I want import this flat file to Server B. Is there a documentation on this? ...
It looks like AQT is not recognising the type of database it has connected to. The Explain option is only visible if it has connected to DB2 (or Oracle, MySQL,...
The help system for the Data Loader tells you how to use that tool. In your particular scenario, you need to run AQT on a machine that: a) can read the flat...
couple of things that would help: - how big a deal is it to bifurcate the User Rights Allowed SQL into two parts, one for System Tables, and one for User...
I have clicked on the load defaults button. It does not help.. The two parameters you have asked about are.... DATABASE TYPE - DB2/MVS INTERNAL AQT TYPE -...
Phil, this is a review of an earlier problem and resolution you had provided, although one fix cause an error for the other From an earlier issue that we had...
I have been using AQT's Data Loader to load Excel Spreadsheets of data into tables. I am running into a problem now where the field type is a varchar(255) and...
Hi John, I've been looking at the rowcount issue again, hoping to put in a fix. However I'm now puzzled as I cannot reproduce the behaviour you have noticed. I...
I'll look into it. One solution may be to automatically add a "set rowcount n" to all queries that run. I have spent the whole day on this. This seems resolve...
I'll look into it and get back to you in a day or two. My Informix server has died, so I'll need to try and resurrect it before I can understand what is going...
To answer my own post, the rowcount "sticks" if the ODBC Datasource is defined with a Select Method of 1-direct, and ignored with 0-Cursor. This has just gone...
Hi, maybe it's not an aqt problem I have but perhaps you can help me. Since changing from my old PC (P III 700MHz 256MB RAM) with windows 2000 professional to...
Dirk Reckeweg
dirk.reckeweg@...
Oct 5, 2004 3:14 pm
1148
I am running a query that joins data from a table in SQLServer with a table in mainframe DB2. I have successfully run it to write the results to a table in...
We have had several occurances of several querries not displaying the Fetching Data screen while running. This makes it impossible to abort and in several...
I can't think of anything in AQT that might cause this problem. Most of our machines are Win XP, so there is no problem running on this. Make sure you are not...
Queries are processed in two phases: a) running the query on the server b) fetching the data If a) takes a long time, then AQT will be locked and you will not...
When you run a query, AQT doesn't "do" anything to the query. It just passes it, as you have written it, to the database for processing. If you get an error...
Actually I'm not sure how you have joined SQLServer and DB2 data, as AQT doesn't support joins across more than one database. Maybe you have copied the DB2...
You got it! Exactly this was the reason!!! Thank you Kind regards Dirk Reckeweg ... [Non-text portions of this message have been removed]...
Dirk Reckeweg
dirk.reckeweg@...
Oct 6, 2004 6:35 am
1155
I think I may have a resolution to this. a) download http://www.querytool.com/aqt617.zip b) go to Options>Technical Parameters and set the option "For Sybase ...
In the absence of my Informix machine being unable to locate it's C drive, I wonder if you could: a) switch on Options > Debug Mode b) run a load c) email the...
Thanks, I will try this. Can you detail what you have coded the "set rowcount" to do within AQT ... Sybase ... tearing ... had ... previous ... some ... Cursur...
This is described in the AQT Help. See Technical Information > Rowcount for SQL Server and Sybase. Basically, AQT will issue a "set rowcount n" every now and...
That all looks normal. AQT will show the Explain option if the Internal AQT Type is 3. I have no real explanation for what you are seeing. Maybe you can switch...
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.
