Hi, I have added two new features ... 1. Visual Explain Diagram - You may execute an "Execute Explain" to get a Visual Explain Tree result, then you may right...
John, Visual Explain Diagram is *very, very* neat!!! A quick question though. Any chance you'll be incorporating Sybase into 'execute explain', aka set...
Ioffe, Dimitry
Dimitry.Ioffe@...
Feb 9, 2004 4:38 pm
933
Hi Folks, I'm new to this group. I stumbled on this wonderful application and i would like to say a big thank you to the developers. I installed the studio...
Hi, ... into 'execute explain', aka set showplan on? I initially looked into supporting Sybase Explain Plans, but the problem with Sybase is that it doesn't...
Hi Debola, ... changed the ... application again. ... Program terminated." A similar error message/problem was once reported to me, and the result had...
Thanks John. It worked. I'm grateful. would keep checking to know when the new version comes up. it would also look nice if one can right click on a table and...
Hi, ... browse the content. You can use the table editor to browse/edit the table content ... http://www.aquafold.com/docs-tableeditor.html I do have on my...
Hi John, i believe in 12.5.1 you can do it with abstract plans; however, i have not looked into it deep enough to fully understand all it can do. I'll take a...
Ioffe, Dimitry
Dimitry.Ioffe@...
Feb 9, 2004 8:33 pm
939
Hi Dimitry, I've been looking through the Sybase Abstract Plan documentation. It looks as if the abstract plan has enough support to build an explain tree....
Hi John, below find response from one of the developers re. 'set showplan on' for sybase 11.x. Pls. let me know if it's something you've already looked at and...
Ioffe, Dimitry
Dimitry.Ioffe@...
Feb 12, 2004 4:53 pm
941
Hi, ADS currently prints out the warnings. So, if you execute a query with showplan on, it will print out the plan. The problem is that showplan does not...
John, in order to provide additional info you can do: set statistics io on What exactly are you looking for in terms of data to parse? One of the options is...
Ioffe, Dimitry
Dimitry.Ioffe@...
Feb 13, 2004 3:53 pm
943
Hi, Ideally, Sybase would provide a resultset with the basic info of (NODEID, PARENTID, OPERATION NAME, SUBTREE COST) which is what Oracle, DB2 and SQL Server...
John, That's fair. Let me talk to sybase and see if anything as such is in the works. I'll keep you posted if anything of use will come out of my discussion...
Ioffe, Dimitry
Dimitry.Ioffe@...
Feb 13, 2004 7:31 pm
945
Does Aqua Data Studio support Sybase IQ, or are there any plans to in the future? Thanks. Don...
Hi Dimitry, ... Well, the Explain Graph/Tree is ready to go ... it just needs the information from Sybase. If Sybase implements something like SQL Server I...
Hi Don, Although I haven't specifically tested against Sybase IQ, I did have a conversation with a user who is using ADS with Sybase IQ ... connecting with the...
John: I don't have Sybase IQ access yet, when I do I will try connecting with the Sybase 12.5 connection type and let you know how it goes. ASIQ is the Sybase...
Hi Debola, Visual Explain currently doesn't support MySQL. If you try to execute explain you should get a message saying this. The reason for initially not...
Hi John, I am unable to extract stored procedures and user defined functions from MS SQL server. At the same time I am able to extract tables from MSSQL...
Hi Michael, I am able to script procedures and udfs from my SQL Server 7.0 and SQL Server 2000 server with the below versions. 2000 @@version -- Microsoft SQL...
John, Here is the information from SELECT @@VERSION: Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft...
Hi Michael, To isolate the problem and figure out if the problem is at the server, database or object level, can you try the following ... If you have the...
John, I successfuly was able to create procedure in all three databases as well as I was able to extract the requested SP from Northwind. Obiovisly the problem...
Hmm, There is one scenario that I can imagine that this problem can occur. If you create an object with a user who is not the database owner, and then you...
John, The user id I am using to login is the name, used to create all procedures in the database. The user is also has the db_owner role. All procedures are...
Hello John, I'm new to the list and the app -- great work so far. Just wanted to report that auto-completion doesn't work with aliases (at least not against...
Hi, I put out a new build which has a new Tools menu with an "Import Tool". I've tested the tool with every database, version and datatype all looks well, but...
Hi, Here are some basic steps and instructions on how to import data ... 1. Select Tools->Import Data from the Menubar. This will prompt you to choose a...
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.
