I also have a need for accessing different data sources with a single query. Most of my data is on a SQL Server. However, I get a lot of spreadsheets that I...
In the AQT Beta 8.04 at the explorer screen, (the one with three windows), I am connecting to a DB2 390 with a Neon odbc driver, I've named the database...
I need to be able to access data in a sybase database and a MS SQL database and do a join on them to do a report. Is this possible in AQT. Before I spend the...
Garry~ Let me start by saying I find AQT very helpful, and much more powerful than Access for manipulating data. But there are times when I need to combine...
Phil Many times I have to squeeze all columns of a query result order to have all coloumns on one page. Is it possible to have a function ( like in excel...
Hi there, no, AQT cannot run queries across databases of different types. The only product I know of that can do this is MS Access. See the other recent...
You can fit all the columns into a single page by specifying a low value for Options > Display Options > Maximum Column Width. In AQT v8 I have some of what...
True. But then adding a command such as this to your query would be a chore. What I was thinking of is, when you run a query and save the layout, it saves that...
phil, thanks the save layout wordks fine. I played around with the report header, i changed the height to an higher value, now i get the message "runtime error...
I see... your advantage is, to have no work, mine would be, to be more flexible: I would be able to save more than one Layout, and to choose the one which I...
Phil, Thanks for the info. I did a search but not sure if I used the right terminology as I got into an area I was not familar with. David ... SQL ... in ... ...
Phil, I already foud the registry setting, and repaired it. What I did is changed the header height from 900 to 2900 . and than you get this error, and you're...
Have for some time tried to understand how parameter markers can be used in DB2 for z/OS (ver. 7) to avoid full prepare. Is the use of parameter markers...
IBM has Information Integrator, which used to be called Data Joiner, until they decided they needed a fancier name with more syllables. I looked but couldn't...
I have a developer that gets the following message when he is closing AQT 8.0.4: aqt800.exe - Application Error The instruction at "0x6aaaee9b" referenced...
Well, there is one other product that can do it, Crystal Reports Regards, Jim _____ From: aqt@yahoogroups.com [mailto:aqt@yahoogroups.com] On Behalf Of Phil ...
That's interesting. These products work by pulling the entire result-sets into memory then doing a join there. Works well for small amounts of data but would...
Good point about the potential slowness Phil. I have seen cases where Crystal Reports can get pretty slow, even when not using relatively large amounts of...
I have seen this once or twice. I'm not sure of the circumstances in which this happens. Does this happen all the time, or only from time to time? If it...
This is a complicated area. By default, AQT does a Prepare then an Execute. In most cases, the DB2 ODBC Driver uses Deferred Prepare, so will not pass the...
See http://www.querytool.com/upgrade.html and http://www.querytool. com/pricing.html In a nutshell: . AQT v8 will cost the same as AQT v7 . current AQT users...
Thanks for the answer. Have tried what you suggested but cant' see any result in my DB2 trace (KPD-DYN PREPAVOID) ,it's still zero. Regardless of what I do! ...
When you configure your client (using the DB2 Configuration Assistant ), there is a setting DeferredPrepare. Make sure this is enabled. I'm not entirely sure...
Because we are used to paying exhorbanant fees for "enterprise" software, AQT has been an incredible bargain for us. Smaller companies may not see it the same...
Strikes me as a real bargain for the upgrades personally, especially in light of how many versions it's been since you charged for an upgrade. I'd pretty much...
Hi Phil, I have a script (see below) which runs perfectly when the delimiters are semicolons but fails with SQL Server 2000 when I use the GO delimiter. I'm...
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.
