Search the web
Sign In
New User? Sign Up
aqt · Advanced Query Tool Discussion Group
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
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.

Messages

  Messages Help
Advanced
Messages 3253 - 3282 of 4213   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
3253
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...
Jim Cramer
themezman50
Offline Send Email
Jun 1, 2007
4:56 pm
3254
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...
Phil Castle
cardettnz
Offline Send Email
Jun 1, 2007
9:32 pm
3255
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...
Jim Cramer
themezman50
Offline Send Email
Jun 1, 2007
10:41 pm
3256
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...
mikewizibmnet
Offline Send Email
Jun 3, 2007
11:22 pm
3257
I'm not sure what the problem might be. Could you switch on Options > General > Debug Mode, rerun the Load, then email the debug file to me at...
Phil Castle
cardettnz
Offline Send Email
Jun 4, 2007
6:13 am
3258
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,...
satish_srikakulapu
satish_srika...
Offline Send Email
Jun 5, 2007
10:55 pm
3259
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"...
cardett_troy
Offline Send Email
Jun 6, 2007
12:35 am
3260
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...
andreas.hotz@...
andreashotzde
Offline Send Email
Jun 12, 2007
7:36 am
3261
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...
Phil Castle
cardettnz
Offline Send Email
Jun 12, 2007
7:45 am
3262
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...
Phil Castle
cardettnz
Offline Send Email
Jun 13, 2007
12:59 am
3263
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...
ryoungbugs
Offline Send Email
Jun 15, 2007
7:22 pm
3264
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...
ryoungbugs
Offline Send Email
Jun 15, 2007
8:36 pm
3265
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...
Phil Castle
cardettnz
Offline Send Email
Jun 18, 2007
11:02 am
3266
... 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,...
ryoungbugs
Offline Send Email
Jun 21, 2007
12:22 pm
3267
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...
Phil Castle
cardettnz
Offline Send Email
Jun 21, 2007
9:04 pm
3268
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...
Jim Herrmann
jim_kcsr
Offline Send Email
Jun 21, 2007
10:18 pm
3269
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...
Phil Castle
cardettnz
Offline Send Email
Jun 21, 2007
10:33 pm
3270
That worked. Thanks. Could there maybe be an option or a button or something like that to do that automatically? Just a thought. Peace, Jim...
Jim Herrmann
jim_kcsr
Offline Send Email
Jun 21, 2007
11:37 pm
3271
... 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> ...
ryoungbugs
Offline Send Email
Jun 22, 2007
12:47 am
3272
... 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,...
ryoungbugs
Offline Send Email
Jun 22, 2007
9:25 pm
3273
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...
Phil Castle
cardettnz
Offline Send Email
Jun 24, 2007
10:11 pm
3274
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...
Daniel V Gomes
danvgomes
Offline Send Email
Jun 26, 2007
5:57 pm
3275
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. ...
cardett_troy
Offline Send Email
Jun 26, 2007
9:35 pm
3276
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? ...
ryoungbugs
Offline Send Email
Jun 27, 2007
11:52 am
3277
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...
mcbuerger
Offline Send Email
Jun 27, 2007
11:53 am
3278
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...
Phil Castle
cardettnz
Offline Send Email
Jun 27, 2007
12:00 pm
3279
Do I have any chance to run AQT v7 with Vista or do I need to upgrade to V8 ?...
godestalbin
Offline Send Email
Jun 29, 2007
10:59 pm
3280
Do I have any chance to run AQT v7 with Vista or do I need to upgrade to V8 ?...
godestalbin
Offline Send Email
Jun 29, 2007
11:00 pm
3281
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...
Phil Castle
cardettnz
Offline Send Email
Jun 30, 2007
1:40 am
3282
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...
andreas.hotz@...
andreashotzde
Offline Send Email
Jul 2, 2007
11:56 am
Messages 3253 - 3282 of 4213   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help