Hi, I had aqt 8.16 running fine for a long time under Server 2003 Service Pack 2 and on a VMWare virtual host. Our admins moved the virtual host with aqt to a...
The most probable cause of this is something called Data Execution Protection, that comes with MS Terminal Server 2003 SP2. This is a feature that is designed...
Hi Phil, Thanks for the very fast and very correct response. You were entirely correct and your resolution for the problem worked. Thanks, once again, for the...
Hi - I enjoy your product immensely and use it nearly every day. Lately, I have run into a problem with the loader. I am populating an AS/400 (DB2) file with...
Hi, We use AQT to compare tables across different Schemas and different DB2 Sub-systems. The output of the compares looks good when we open it in the notepad,...
Hi Satish, I will need some more information to work on this problem. When you say: "compare tables across different Schemas" are you doing a "Compare Object"...
AQT Version 816 Hi Phil, Using a german Windows with AQT a wrong default directory is used: Options -> File Locations -> default directory for files created by...
Ok thanks. Presumably similar for other languages. I'll check it out. Phil. ... AQT -> now use the button 'default' -> a directory 'Application Data' is used...
Turns out I needed to use a different Windows API to get the app data directory. Should now be fixed - see http://www.querytool.com/ aqt817e.zip I would...
Don't know whether it's 8.1.6 or moving on up to XP/sp2 (from w2k/spX), but now those nasty HIGHVALUES on z/OS DB2 don't translate. This was working on...
Two other bits of info: Unicode is not enabled (wasn't before). The echo of the query in the status bar at the bottom of the screen, shows the query mangled...
Sorry about not replying earlier. This is an awkward thing for me to test - I'll see if I can develop a test case for this. To my knowledge, nothing has...
... And sorry about not noticing that the z/OS system had been upgraded to 8.1.5. Last I knew it was at 8.1.1, and all was well. That likely is significant,...
Just to clarify things.... is the problem with displaying x'FF' characters in AQT? Or is the problem with getting x'FF' characters from AQT into DB2 z/OS? The...
I created duplicate tables from a DB2 z/OS V7 on a SQL Server 2005 data base. When I try to use AQT Data Loader, to load data from the mainframe to the SQL...
Dates are such a pain, as every database has different format for how they are specified, so they often do not convert easily. With the data loader if you...
... well, sort of. the <alt-159> key combo generates the <Y-umlaut> character (hex(9F)) in the AQT editor. so: select blah from foo where blah = <alt-159> ...
... I double clicked on the status echo of the query, lo and behold, it came up in its own window. With a Font menu item. Which said MS San Serif (well,...
You can set the font for the Run SQL window with Options >Syntax Highlighting. In the popup menu you got when clicking on the status-bar - if you change the...
Hi Phil, AQT v 7.1.4 I have a question on the filtering of output data that is populated when the SQL statement is executed. Let say I am looking for the names...
Hi Dan, The easiest way would be to display the rows where state_cd = AA in your where clause. Another way would be to use the "Find" on the grid results. ...
Found a colleague, who did the same test, with the same result. And then I found this on the 390/APAR site: http://www- 1.ibm.com/support/docview.wss? ...
I use AQT v8.1.6 (Extended Edition) and watch out for a way to transfer some data from a table in an Informix db to a table in SqlServer. ODBCs are available...
There are two ways of doing this: 1. the Data Loader will do this for you. This allows you to load your SQL Server table from a Query run against the Informix...
A good question. I haven't tried. AQT itself should run OK with Vista. Where the problems were (with v8) were installation problems. Some of the components...
AQT 816 Sybase SQL Anywhere (ASA) Hi Phil, tables and views are shown as different icons in lists. Could you show a different icon, if a table is a proxy table...