It works for me. I have statement Delimiter ';' (semicolon) set and "Use GO as delimiter for Sybase/SQL Server". ________________________________ Von:...
Hi DBAs I m getting Persistent Lock In my Databse Suggest me how to solve this error. ... Yahoo! Personals Single? There's someone we'd like you to meet. Lots...
Hi there, Could you provide us with more details of what you are doing. For instance what SQL are you running - are you running a query or an update SQL? If...
I was just reading about the new look of AQT Version 8, that is due to come out in mid 2006. Has the pricing structure been decided? Will it be a free upgrade...
We haven't decided yet on this. Phil. ... to come out in mid 2006. Has the pricing structure been decided? Will it be a free upgrade for owners of version 7 or...
Sorry for not replying to this earlier. This is a quirk in AQT. AQT actually accesses details of the function by using the Specific Name, as there can be more...
You can download a fix for this from http://www.querytool. com/sybasee_adm.zip Phil. ... about the empty brackets! (incorrect syntax near the word 'as')! ... ...
Now it works fine! Thanks for your quick response! ________________________________ Von: aqt@yahoogroups.com [mailto:aqt@yahoogroups.com] Im Auftrag von Phil...
Hi, We are using AQT for both DB2 for AIX and DB2 for z/OS. When using the "Table/Views within Database" display against a DB2 for z/OS system, it does not...
Hi, When running an SQL query againts a table that contains a column with LOB (CLOB/BLOB) data, AQT supports a nice way to display the contents of the LOB by...
This is a new requirement. When the LOB comes back as a query-result, it is written to a file. It is a different interface when the LOB comes back as an output...
Hi there, information on default values is a bit complicated for DB2 z/OS. When DEFAULT is Y, this means the default is NULL if NULLS=Y, otherwise the default...
Yes, the database design in the DB2 for z/OS catalog is not the very best, but it is at least documented... SYSIBM.SYSCOLUMNS.DEFAULT can have 18 different...
The Format SQL command could do better with CASE statements. It currently just strings them all together as one long string. I would be nice to have the WHEN...
Ah yes, there is an error in the query that works out whether it is a generated column. It checks for SYSIBM.SYSCOLUMNS.DEFAULT being A, D or I. Should also...
Also subqueries are not formatted in the same manner as normal queries. The fields are in the same line. also at the join on ... and ..and new lines for each...
Yes, I actually found query 20 that missed out the 'J' and changed it. Now when I've downloaded your version it seems like you also did some work on the matter...
I haven't yet decided whether to keep the (default) there, for the reason you have noticed. The Simple DDL generator has many limitations - it certainly can't...
Hi Phil, Here are two suggestions for the rename-function for the windowsbar: 1) The text in the Dialog "Rename Tab" / field "new name" is truncated after 15...
Phil, 7.1.6 extended i took an export script which has been working fine for CSV exports (type=tab) and changed it to type=insert, as this was what the client ...
Export as inserts has a few extra parameters, which aren't used in csv export. One of these is: insert_tab=tabname which specifies the table name to be used in...
Not too difficult to preserve the tab-name through a Refresh. As for a longer name - don't really want the tab name to be too long, as the tab would then be...
Thank you for your anwer! Hers the reason why 15 characters ar too short in our constellation: The defaultname is build by the rule <schemaname>.<tablename> ...
well, of course, RTFM. which leads to a second question: for Oracle, TO_DATE wraps the date data. in this case, i'm going from UDB/8.1 to SqlServer2000; it...
i did RTFM this time, but still don't know how to fix it. while the client was here with his laptop and SS2000, i was able to generate DDL (7.1.6EE) using a...
I'm not familiar with this error. What exactly are you doing when you get this error - running some DDL? If you can send me a debug file of this error, this...
... doing the Extended Edition DDL generation. since we're about to get a blizzard, i won't be in the office until Monday. i'll run a debug then. thx, robert...
and can be downloaded from http://www.advancedquerytool.com/aqt716.zip For information on what is in this release, see http://www.querytool. com/whatsnew.html ...
Hi Phil, after downloading the file, i get error-messages when trying to unzip the file: WINZIP: ======= warning [I:/Downloads/aqt716.zip]: extra 7352 bytes...
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.
