Hello, First of all thank your for this wonderful (and useful) application. I miss greatly this feature: will there be available soon Visual Explain for...
Hi Marian, This is on my todo list. The reason PostgreSQL is currently not supported is because the explain information provided by PostgreSQL is not in a...
Hi John, A slight annoyance with ADS and PostgreSQL. I first noticed this with ADS 4.5, currently running 4.6.10 on Mac OS 10.4.4, Java 1.5.0 06-99, PostgreSQL...
sp_help is a system proc that gives information about a DB object. when run at a plain ISQL prompt, it prints out various information in a logical order. When...
Hi Matthew, ... This is a limitation by the design of the JDBC drivers. The drivers provide the ResultSets or rows of the query and a list of warnings. ...
Hi I cannot have the qualified object to work . I have checked the entries in the option ==> script and checked all the qualify object but i still have only...
John, Great tool. I just changed my password on the AIX machine hosting the DB2 databases I connect to. When I went to change the password in Server...
John, I am really pleased with the SQL Formatting tool that you've incorporated. I have a request that would help in formatting. Could PLAN statements be all...
Hi, Can you tell me what database and version you are using? Is the problem with the Scripting from the schema browser or the Script Generator? -John...
Hi Matthew, ... Other then the warnings being previous to all results, I don't see any problems. Can you be specific? Also, you are using version 4.5.2 ......
Hi Jay, As of the latest build of ADS, the only restriction is that is can't start with "~'" and end with "'~" ... if it does, it indicates to ADS it is an...
Ok same thing. See my markers MOP>>>> below. There is one "rows selected" statement in the ISQL version and many more in the AD version. But they look...
Hi Kevin, Can you give me a full query example? I just tried a simple sample and it doesn't format in the way you describe. Can you also tell me your SQL...
Hi Matthew, They are different, but I wouldn't say they are wrong. ADS wasn't built to be an isql clone. The results that ADS is providing are more detailed....
Hi John, ADS fails to format this statement. I "Script Object to New Window as CREATE" and try to format as PostgreSQL returns the statement as a single long...
... Ok. ... Now that I've been able to think about it, I would argue that there should be no "rows selected" statements at all. These "result sets" are...
Hi Matthew, You are correct that the JDBC drivers don't allow to know the state of "set nocount" for resultsets. Although it does enable/disable the "rows ...
John, Thanks for a quick status on my minor issue. No rush from me as there is an easy fix on my end of changing my password :-) Jay ... can't ... ADS it ... ...
Hi Kevin, If you disable the "Wrap line at column - 80" it will format as you like. The plan in quotes is longer then your 80 line limit, so it is wrapping it...
Your correct in that it puts it on one line. However, it is still on the same line as that last sql statement before the PLAN clause. Could it be placed below...
For what it's worth, I would handle the "PLAN" and other similar keywords the same way as select/from/where, in this case (this settings) start a newline with...
... problem ... tohave the ... sequence ... <mailto:aquadatastudio-unsubscribe@yahoogroups.com?subject=Unsubscribe> ... however from the query analyser window...
Hi, You still have not specified what functionality of the Query Analzyer you are using. I am not aware of any feature in the Query Window that will generate...
Hi David, Here is a fix for the issue. The "~" through of the Formatter. http://download.aquafold.com/download/datastudio_4_6_10_7-Requires-Java-1.5.jar ...
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.
