This is not all that easy, as the full info on FKs is not in the catalog in an easy way. SYSRELS has the referenced (FK) tables, and SYSFOREIGNKEYS has the...
Hi, Just downloaded version 6.1 and found out that one thing is still not working, generating ddl for Sybase(I use version 12.5.1): One trigger should look...
I quickly installed the much anticipated Version 6 final release of AQT. Overall it seems very solid. Thanks, Phil! I found a small quirky issue in the...
Thanks. This is a problem I've been having with Sybase. I get the trigger (and procedure) source as a series of lines from syscomments. The issue is that the...
You are right. Will fix. Phil. ... AQT. Overall it seems very solid. Thanks, Phil! ... directory in "Location of Config Files" and another directory in ...
I was reviewing the options in V6, and I was looking at Syntax Highlighting colors. I understand "Keywords", but what purpose is served by "Keywords 2" and...
actually this could just be a simple error in the config file. Could you go to http://www.querytool.com/download.html and download the "Config file update"....
actually, I don't know. This file is used by the (third-party) syntax highlighting edit control I use (http://www.studioware.com/). They don't provide any...
I've just had a play (shouldn't have been too hasty with my previous reply). In the Keywords file, you can add another section [Keywords2]. The keywords...
After installing version 6 I noticed several groups that are on one of ours DB's weren't displaying when I clicked "Users and Groups". The only group that does...
Sybase is really messy as their are 4 types of objects - users, groups, roles and application roles. To add to the confusion, Sybase sometimes refers to roles...
If i query Db2/400 using aqt 6.1/db2 connect pe 8.1 ODBC driver I receive this error: 57017(-332)[IBM][CLI Driver][AS]SQL0332N There is no available conversion...
All, Revisiting the additional keywords syntax highlighting issue, I thought I would share with the list what I have done. I added the lists below to my...
Phil, While we're talking about syntax highlighting, put this on your forever growing list of things to look into. How about an option to make parenthesis a...
I too have often thought this would be a good idea, as I have struggled to debug a complex SQL statement. However none of the syntax-highlighting controls I...
Looks like your Sybase is not recognising the concat operator I am using, which is ||. What version of Sybase are you running? Perhaps I should have used +...
When working with tablespaces in version 6 and 7 of DB2 on ZOS, there is a problem with system query numbers 42 and 43. They either return a -301 or no rows...
I've had an enhancement request to make an option available to hide the information at the bottom of the Run SQL window. The keyword, column list, values,...
Phil, Changing the || to + on query #75 didn't work. I now get a different error: SqlErrMsg;SQLExecute;S0022;207;S0022(207)[INTERSOLV][ODBC SQL Server ...
I purchased a license for AQT several months ago. The Generate DDL feature worked fine. I have now upgraded to version 6 and the Generate DDL feature no longer...
The V5 DDL Generator has been replaced by the more powerful DDL generator in the Extended Edition of V6. However we have now realise that many users of the...
... i'm using the same configuration, but only v6. i get the tables back for tablespaces with the shipped db2390.cfg. we have the convention of one table per...
when displaying (v6 extended) an Oracle(8.1.6)/AIX database, the tablespace grid has the BufferPool column, and displays the name of the BP (DEFAULT). but...
Several other people have asked for this too. So I'll put this in V6. 1.1 - will be a menu item (View>Full Screen). Phil. ... the information at the bottom of...
The queries as you have amended them should work fine, though will run a bit slower than the ones we supply (which access SYSTABLES by dbid, which is an...
Hi, Is there a way to save the option settings. To make control on the data for my users, I update a tmp table with all the inconsistencies identified in the...
I would like to make simpler for my users to run AQT queries. I just find out in the help that I could create batches to run SQL statement not interactively. ...
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.
