Phil, We have rolled out V6.1.2 to all our DB2 developers, and the response has been very good. I had a one hour training class last week to introduce the new...
In the data loader, there is an option to choose what your column delimiter is such as a comma. I have a file that is delimited by tabs. (It actually is a...
I'm new to the forum. Has anyone gotten this feature to work? I tried deleting the registry entries as suggested but still doesn't work. When I test with...
This looks like a bug in AQT. We have replied to Steve with details on how to circumvent. Malcolm ... tried ... When I ... or Anyone ... subscript ... Micro...
For some reason we missed out putting in a mechanism for specifying tabs. Will correct in the next point release. If this is very urgent for you, we can get...
One feature of QMF that we sometimes miss is the ability to save the results of a query as a table. It occurs to me that this would not be such a stretch for...
In our database,MS SQL Server 2000, we can just do a "SELECT * INTO your_new_table_name FROM original_table" and it creates a table with allt the elements and...
Hi Phil, using Data loader from basic edition 6.1.2 gives me some problem. I'm trying to load data from an excel worksheet, it seem like AQT is reading badly...
My idea on this is to use the existing facilities of the databases for this. For instance in DB2/UDB, in the Run SQL window you can do Create ... a (summary)...
i'm going into a meeting in the next few minutes (isn't it always thus). the client has been having problems using an application importing facility. i'd...
There is no limit as such. I have used it to load over a hundred thousand rows. However I think you will find it very slow for large imports - this is because...
... well, i was dis-invited. oh well. copying the file and using Import from their UDB Command Center was something i considered. thanks, robert ... there ...
Is it possible to speed this up? I like the AQT load feature a lot because it has so much flexibility. But I'm aware of the performance limitations. ... ...
is it possible to add a column with a specific value for all results in a sql query... for instance i have: select firstname, city from CUSTOMERS output ...
Yes, just go: select firstname, city, 'ABC123' AS "KeyCode" you almost had it - you just has the single and double-quotes the wrong way around. In the AQT...
Hello Phil, We have migrated from BD2 UDB-client Vers. 7 to Vers. 8.1. Now my queries are not longer executed asynchronous. That means, in the status line...
Hello, using aqt 6.1.2 against a DB2 V7.1, i try to validate values with the 'Sum Cell Values' Feature. I got wrong results, i assume even float, double,...
I have the exact same problem with DB2 Connect V8, when V7 worked correctly. My VB developers tell me it's something that the application has to do. Phil,...
I've had a close look at this and put on several traces. It does seem that the async feature doesn't work with the DB2 V8 client, but does with the DB2 V7...
Yes, but I have this set already, and it still doesn't work. I guess I'll open a ticket with IBM. I'll also have a VB coder here do a basic test to see if he...
My async seems to be working. When I run SELECT * from large table, it updates the rows retrieved by 1000 at a time and I am able to hit escape to stop it....
A bit more info - I always get count increment by 1000, always can always ESC, always have abort button. Even if I set AQT tech parm option to NO. 1st time I...
When you run a query, it runs in two phases a) "executing" the Select SQL statement b) fetching the rows (one at a time). The async issue only relates to the...
I'll also post the Google group, which often gets good answers. A C program will also test it. I use native ODBC calls which aren't normally done from VB. He...
I am using AQT 6.1.2 and maybe I just haven't figured out how to do it yet, but.. At the 'build query' screen, you bring a table to the sceen, then join it to...
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.
