Hello Phil, I have recorgnised by your answer you have wade through my whole list of results... It's enormous! To your notes: a) I also have seen the generated...
Sorry, sorry.... One of the result is really still puzzling to me.... +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1.) ON AQT-Option...
There's no point in AQT supressing the generation of the OPTIMIZE and FETCH when you have coded the WITH UR. This is because the DB2 ODBC Driver doesn't look...
Hello Phil, thank you for your answer. I can agree with your statement, that AQT is not supressing the generation of the options and therefore the statements...
Hi Phil, Few weeks ago, I've come across a crash problem when exporting to Excel 2003 and finally found out this was caused by supplying a worksheet name...
Yes, I have noticed this problem too. AQT defaults the worksheet name to the name of the table you are exporting. However there seems to be some table names...
Phil, I work with as/400 physical files which naming convention is very restrictive as opposed to SQL tables. For instance, file names should be less or...
Stranger and stranger. Computers! - who'd ever have one! I'll put a comment in AQT so that, when you get this generic MS error in the Export, one possible...
Hi Phil, I'm using SQL2000. AQT v7.13 When I have a table selected, and choose the option to Rename Columns, no columns are displayed. The status bar...
Phil: i don't do this often enough to remember. luckily, i had a UDB instance to fix it. the problem: EEE version of DB2 z/OS allows only (near as i can...
I'm not sure if I understand what you are saying. What do you mean by "the CSV data was orphaned"? Are you trying to import into DB2 z/OS, or export from it? ...
... import. EEE on z/OS won't LOAD or IMPORT from text files; at least from a client (haven't tried it from the console). have to be the DB2 ixf format....
Hi Phil, When executing the following steps, AQT crashes without any saving, dialog, question or something else. The process is simply finished. I've tried to...
This is due to an error in the admin cfg file. You can download a corrected one from http://www.querytool.com/sqlserver_adm.zip Phil. ... Columns, ... rows ......
Are you saying that the AQT data loader cannot load data into DB2 z/OS EEE? AQT just does a bunch of Insert statements, so should run OK irrespctive the EEE...
You are right. Very interesting. At this point you are in the IBM-supplied DB2 Driver setup program, so I would say that the crash is happening in this....
... z/OS ... ah. no. just tried the DB2 IMPORT and LOAD statements, Run as DB2 Command option using the exported file. rather a large table, so using AQT...
Hi Phil, I've found a bug in the SQL-Window: This bug only happens when having long lines without Blanks. In this special case the internal linefeeds are not...
1. There is not a AQT graphical interface when creating a new view. 2. When I create the view in SQl 2000 and copy the SQL statement to AQT create view window...
There are two ways of creating a view. a) Once you have built a query in the GUI query builder, go to the Options tab, select Statement Type and change to...
Why do fields which contain all spaces display as 'Text Length is No bytes'? I cannot tell whether there is one space or no spaces or more actually in the...
This is true. AQT trims the trailing spaces of fields, so a field of multiple blanks will appear empty. In a future release we will put in an option to govern...
I had to have my computer rebuilt. In trying to reinstall and get the lastes, the below message is what I received. Thanks, Rhonda 404 Error -- File Not Found ...
Yes, sorry for not replying. We managed to reproduce this effect. There are a few other similar effects - they just appear to be repaint problems. The control...
Has anyone encountered a formatting error particular to built Oracle insert SQLs (using TO_DATE function) on a DATE datatype column where some (older) data is...
... Oracle ... where ... adds ... TO_DATE ... NULL, 'Xxxxxxxxxx - ... 625, ' X ... TO_DATE ... One additional piece of info - I'm running AQT 7.1.3 and using ...
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.
