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...
Message search is now enhanced, find messages faster. Take it for a spin.

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 3908 - 3937 of 4213   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
3908
Hi All, This is the my first post. I do not know how to run the sp in sql window. I have done like this <sp_name>(id int, cur_our SYS_Cursor out) .... { call...
ananda krishndu
ananda_krish...
Offline Send Email
Jan 2, 2009
3:20 am
3909
The following should work: { call <sp_name> (100) } or { call <sp_name> (?) } Phil. ... type. please send some sample. Thanks in advance happy New Year 2009 ...
Phil Castle
cardettnz
Offline Send Email
Jan 3, 2009
3:39 am
3910
Any suggestions for running an aqt(current version) batch under a local service account. The process creates no log entries and hangs....
williamstandkeiii
williamstand...
Offline Send Email
Jan 6, 2009
2:44 pm
3911
Is it trying to access a database on the same or a different server? Have you tried running it under the network service account? In theory the local system...
Greg Palmer
gregorylpalmer
Offline Send Email
Jan 6, 2009
3:02 pm
3912
Without getting any sort of error message it's hard to know what the problem might be. AQT uses a couple of directories (the Default Directory and Query ...
Phil Castle
cardettnz
Offline Send Email
Jan 6, 2009
9:05 pm
3913
and can be downloaded from http://www.querytool.com/download.html For what's new in this release, see http://www.querytool.com/ whatsnew.html Phil....
Phil Castle
cardettnz
Offline Send Email
Jan 13, 2009
8:35 am
3914
I was using v 8.2.5 and was encountering an issue when in the Run SQL window. When I try to copy some of the text in the sql using CTRL-C it closes AQT. I...
andrewmason17
Offline Send Email
Jan 13, 2009
10:17 pm
3915
Hi, I haven't been able to reproduce this problem. I am able to copy over 7000 lines to my clipboard and paste it successfully. Is it possible you are reaching...
cardett_troy
Offline Send Email
Jan 13, 2009
10:44 pm
3916
I just re-installed AQT (8.2.1) on a new laptop. When I try to open AQT with a connection to an iSeries server I get the following message popping up. No icon...
russwion
Offline Send Email
Jan 14, 2009
7:35 pm
3917
This problem happens when AQT is looking at an old cfg file for DB2/ iSeries. To correct, go to Options > File Locations and check that "Location of config...
Phil Castle
cardettnz
Offline Send Email
Jan 14, 2009
7:40 pm
3918
*This is a minor problem. 1. Startup AQT 2. Connect to any databases. 3. Close inner windows.(Disconnect from all.) then, Menu strings are currupted. ...
yshin1018
Offline Send Email
Jan 19, 2009
6:23 am
3919
Could you send a screenshot to me at phil@... so I can see exactly what you are seeing? Thanks, Phil Castle....
Phil Castle
cardettnz
Offline Send Email
Jan 19, 2009
9:04 am
3920
Thanks Phil. It is working fine. Regards Anand ... From: Phil Castle <group@...> Subject: [aqt] Re: Fw: Ho to runn sp in sql window To:...
ananda krishndu
ananda_krish...
Offline Send Email
Jan 19, 2009
11:51 am
3921
In the "Export to Delimited File" page in HELP, it talks about a "Remove from strings" option, and then in the Description field, calls it a "Remove from...
glen.wenzel
Offline Send Email
Jan 22, 2009
4:02 am
3922
On the Export Options dialog, this is called "Remove delimiter character from strings". It is obviously referred to incorrectly in the Help - thanks for...
Phil Castle
cardettnz
Offline Send Email
Jan 22, 2009
4:18 am
3923
Hi Phil, When i try to select the data from a column that is defined as XML on a db2 table, AQT shows nothing. Even though i know there is data in the table....
kenneth larsen
kenneth_lars...
Offline Send Email
Jan 22, 2009
9:41 am
3924
This problem is fixed in the latest release, AQT v8.2.6. Phil. ... on...
Phil Castle
cardettnz
Offline Send Email
Jan 22, 2009
9:48 am
3925
Sorry Phil, I just saw the same thing when i clicked around your website. I have allready installed and tested. Works like a charm ;-) Thanks and regards ...
kenneth larsen
kenneth_lars...
Offline Send Email
Jan 22, 2009
9:53 am
3926
I verified that the location of the config files was set to C:\Program Files\Advanced Query Tool\cfg I also went in to Options/config files and added an entry...
russwion
Offline Send Email
Jan 22, 2009
6:05 pm
3927
Hello, I am using AQT to connect to an iSeries DB2 database. AQT connects to an iSeries server job QZDASOINIT and I am attempting to insert records to a...
hughb42000
Offline Send Email
Jan 22, 2009
7:33 pm
3928
I wonder if you can switch on Options > General > Debug Mode, sign onto the database, then email the debug file to me at phil@... Thanks, Phil. ... ...
Phil Castle
cardettnz
Offline Send Email
Jan 22, 2009
7:36 pm
3929
Hi there, if you are connecting to your DB2 database using Client Access Express, then you can specify a library list when you configure the datasource for...
Phil Castle
cardettnz
Offline Send Email
Jan 22, 2009
7:40 pm
3930
Thanks, That worked. ... of ... connects ... contain ... the...
hughb42000
Offline Send Email
Jan 22, 2009
7:49 pm
3931
Thanks very much Phil ! Is there any chance that a page could be added to HELP which would itemize all of the batch export parameters in one place ? For ...
glen.wenzel
Offline Send Email
Jan 22, 2009
8:46 pm
3932
There is, in Help > Scripting. See http://www.querytool.com/help/ 304.htm Though I have just noticed that REMDEL seems to have been omitted from this (will...
Phil Castle
cardettnz
Offline Send Email
Jan 22, 2009
9:02 pm
3933
Thanks again Phil. Glen ... would ... which ... incorrectly ... you ... about ... it ... export,file="C:\ExportData.txt",type=tab,filemode=replace,header=yes,p...
glen.wenzel
Offline Send Email
Jan 23, 2009
2:00 am
3934
Hello, I am trying to use AQT Loader to convert from DB2 to SQL Server 2005. I cannot figure out how to get it to convert DB2 timestamp data ...
tony_awbrey
Online Now Send Email
Jan 23, 2009
4:39 pm
3935
Saying <4:date> should work. Or, alternatively: <4:MASK(abcd-fg-ij lm*op*rs.uvw):trans(*,[colon]):NIS> Phil. ... 2005....
Phil Castle
cardettnz
Offline Send Email
Jan 25, 2009
2:05 am
3936
Thanks Phil this worked prefectly. Tony...
tony_awbrey
Online Now Send Email
Jan 26, 2009
2:50 pm
3937
One of our AQT users is having install problems with v8.2.6(new install, not an upgrade). During the installation, a pop-up window appears with the message: ...
wfsaqtuser
Offline Send Email
Jan 30, 2009
2:25 pm
Messages 3908 - 3937 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