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...
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 ...
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...
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 ...
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...
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...
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...
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...
*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. ...
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...
On the Export Options dialog, this is called "Remove delimiter character from strings". It is obviously referred to incorrectly in the Help - thanks for...
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....
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 ...
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...
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...
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. ... ...
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...
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 ...
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...
Thanks again Phil. Glen ... would ... which ... incorrectly ... you ... about ... it ... export,file="C:\ExportData.txt",type=tab,filemode=replace,header=yes,p...
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: ...