Does this mean that I should do some cleanup, such as getting rid of the cfg files in the main directory?? Anything else that should be moved or removed?? ......
When you migrate from v7 to v8, AQT will: a) move all *.cfg files to the cfg subdirectory b) move all *.udr files to the workfiles directory c) move...
and can be downloaded from http://www.querytool.com/download.html For information on what is new in this release, see http:// www.querytool.com/whatsnew.html ...
I updated the Wikipedia entry to indicate the new release: http://en.wikipedia.org/wiki/Advanced_Query_Tool We should probably update the entry to include the...
Hi Ad. Regarding you first problem (generates the wrong query for dropping the foreign key) this has been fixed and a new cfg file has been sent to you to fix...
Can some one help - I am run MS Access 2000 thru AQT, when loading a large table, I am getting an error that state OUT OF TEMPORARY STORAGE SPACE. How can I...
It should be included with AQT v8.1.5. Alternatively you can download it from the Files section of this group. Phil. ... dropping ... system ... deeln_atleten;...
Thanks, that was not clear. Mike Harris __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam...
Hi, I apologize in advance for the length of this. I am trying to understand the AQT licensing scheme and I am very confused. I am about to upgrade to v8 from...
Some little ideas for subtle improvements. Most of these are small, point release type changes. Posting them on the list will perhaps provoke other ideas...
Hi - Is there any support planned to display XML data types implemented in DB2 V9 (Linux, Unix, Windows). A select * is not showing the contents of XML...
When you display this in AQT you should get the data as you have inserted it (eg. <?xml version="1.0" encoding="UTF-8"?><greeting> Hello, World! </greeting>) ...
I just wanted to say thanks. I have been using the v8.1.5 for the last week and the two issues are working correctly. Since it was year end for our company, we...
Hi Phil, "Link to related tables" in the data display window looks like a great feature, but unfortunately it doesn't work on our DB2 z/OS. It produces way too...
I have been playing with the link to related tables stuff. It's great. I don't know why I haven't been using it more in months past, but now I am and, of...
I purchased the 8.0 upgrade Registration Key and when I try to change my display limits of the table from 50 to another number I can't. I states: "These...
Thanks. I've added these to our list of suggestions. The first two are straightfoward to do so I should be able to get in AQT v8.1.6. The third is a bit more...
A colleague is new to AQT and using the Build Query interface. We ran into an issue with AQT failing to translate a table join that uses an "or" statement....
Hi Phil, thanks for replying. Unfortunately, that doesn't seem to be the case. I'll e-mail you separately with some screenshots. Luc ... originally ... file ...
Sorry you didn't get my earlier reply (must have gotten lost somewhere). I presume you are referring to the fix whereby AQT will correctly interpret a join...
I am trying to convert a field which holds a proper name (all in uppercase) to the appropriate upper/lowercase. For example, I need to convert "MARY ANNE" to...
Most databases do not have an inbuilt function to do this. However if you let me know what type of database you are using, I'll be able to let you know for...
Utilizing DB2 (and the SAMPLE Database), Here is an example: SELECT RTRIM(SUBSTR(RTRIM(UCASE(SUBSTR(E.LASTNAME,1,1))||LCASE(SUBSTR(E.LASTNAME,2,14)))||', '|| ...
Thank you so much. This is the sql statement I used: UPDATE MSTR SET FIRST_NAME =                     UCASE(SUBSTR(FIRST_NAME,1,1)) ||...
DB2 doesn't provide an easy way to do this. The only real way to do this is to write a user-defined-function to convert the string to the capitalize case. You...
I suspected as much. Thanks so much for everyone's help. Coleen ... From: Phil Castle <group@...> To: aqt@yahoogroups.com Sent: Monday, February 5,...
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.
