Hello, I was wondering if there is a way to see the line number in AQT where an error occurred in my SQL query. I am running AQT on Oracle database and when...
Phil, Is there a reporting capability in the latest version of AQT? Is it a third party reporting tool or is it implemented by AQT? Can you send the results of...
Yes I agree, this would be nice. However it is not possible. The position of the error is not part of the information returned to AQT by the Oracle ODBC...
There is no real reporting tool as part of AQT. There are various options about formatting the query-results, however I would not describe this as a reporting...
I am using AQT to connect to Oracle database. I was wondering if there is somewhere in the help section where I can see the syntax of all PL/SQL functions. I...
Hi, AQT is a multi-database tool that handles many DBs. I will pass you suggestion on to Phil (development manager), but I suspect it would be out of the scope...
Just tried Simple Compare on two DB2/V8.2 z/OS schemas in the same instance. Got this error message in the Result pane. Don't remember that before. The...
This problem is now fixed. You can download fix from: http://www.querytool.com/aqt824a.zip Regards. -- Troy Pascoe Technical Support Cardett Associates Ltd ...
Just been through using the Data Loader to load a bunch of worksheets from an Excel file. The file pick list never gets populated, so one has to go to the ......
I have tried mulitple times on multiple PCs to download the 8.2.3 version of AQT and each time, WinZip 11.1 returns a message indicating that the zip file is...
I recently posted about a problem with the downloaded zip being reported by WinZip as corrupt. The issue was NOT with the AQT site but the "Full install (from...
Hi, Should be an easy fix. We will have a look at it and let you know when it is fixed. The "Run as DB2 Command" will not work with xdb. Regards. -- Troy...
Hi @ all, i try to export using a dynamic filename. I code the following statements: --aqt queryparm,parm=anz,value=999999,desc=Anzahl auszugebender ...
Hi there, i`m running AQT with DB2/390. If i try to run a 2nd Statment i get the error: "Cannot process SQL as a query is already in process" Why is that? Is...
AQT can currently only run a single statement at once. There are a number of technical reasons why this is the case. This will be corrected in the next...
It is not really a product question, it is appreciated if you can answer it for me. I have a table like this in informix, User Contract ModifiedDate Person1...
You could try SQL such as: SELECT user, contract, create_dt from contract_audit a, (SELECT contract, min(create_dt) as create_dt, FROM contract_audit WHERE...
42601(-104)[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "First 10000 Rows Only" was found following "LS.PNPDATA_TBL Fetch". Expected tokens may...
Hi, Can you check that Options > Run SQL > Technical Parameters > For DB2, add FETCH FIRST x ROWS clause – is unchecked? Also, can you tell me what version...
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.
