Hi, Here is a fix ... http://www.aquafold.com/download/datastudio_4_0_12_7.jar I have added support for IMMUTABLE | STABLE | VOLATILE - CALLED ON NULL INPUT |...
Hi, I've added support for "Execute Procedure" in the Procedure Editors for DB2, SQL Server, Sybase Anywhere, PostgreSQL and Informix which were disabled until...
Would be handy and cool to have a better openbase support. While jdbc connection is handy for row queries, some basic features would come handy. info and...
Hello John, First, i must say ADS is one of the best Database Tools i have seen. I'm evaluating it since a couple of month, and there are only a few rather...
Hi, I've added OpenBase to my list. There are a few database that users want support for. http://www.aquafold.com/download/futurefeatures-post-v5.txt thanks ...
Hi Stefan, I guess I should have been a little more detailed in my description. If you add jConnect6.0 into the path, then ADS will use jConnect6.0 for both...
Hi John, I am in the annoying position of having to write documentation for several changes someone made without writing them down and whilst I figured out how...
Hi Marcel, As far as I can tell, you can distinguish between a UDDT and a system type from the System Catalogs. Here is the query that ADS uses ... select...
this is the script extract with aqua data studio 4.0.1: ALTER TABLE cev_progressivi_ldv ADD CONSTRAINT ( CHECK )) CONSTRAINT flag_istanza ) GO ALTER TABLE...
Hi, Can you give me an example of the original DDL for the table and constraints so that I can reproduce it here? I tried this example and the scripting works...
John, A SQL Server box that I need to connect to uses named instances of SQL Server. The JTDS site suggests appending an "instance" property to the connection...
Hi Mike, You can make a connection to a named instance in ADS using the format described in the ADS docs ... http://www.aquafold.com/docs-register.html The...
I hit the following error even I don't use Postgres. I tried to sign on to Oracle 9i. Exception in thread "Thread-4" java.lang.NoClassDefFoundError: ...
Hi, You are probably getting this error because you have upgraded to ADS 4.0.12 (or above) on an ADS 3.x installation. If you install ADS 4.0 and upgrade you...
Hi John, I think I may have asked incorrectly for what I was after. I am after a list of user defined composite types that are used to define the output for...
Hi I figured out a way to get the info I am after, I am not sure how robust it is but it got the job done. It would still be nice to have this sort of info...
Hi john, i downloaded the latest 4.0.13 build and problem is fixed. The script is correct, thank very much. Santo. ... this is the script extract with aqua...
i have informix 7.3 installed on HP/UX. i am using aqua data studio 4.0.13. i'm connecting via native informix not informix-odbc. but i can't see stored...
Is there a way to connect to a DB2 OS/390 subsystem running DB2 v7.1? I can't figure out how to setup the server appropriately in the Aqua Data tool. I have...
McClendon, Rick
rmcclendon@...
Jun 8, 2005 2:46 pm
2124
Hi, This should work. Can you script the CREATE of the procedure? Is it that all procedures don't work, or just specific ones? Can you send me a sample DDL...
Hi Rick, The ADS "DB2 7.x" connection type doesn't support OS/390 or AS/400, only DB2 UDB (windows, linux, solaris). If you can connect with an ODBC tool, then...
Duh! I'm very new to the tool and never realized there is a "Generic ODBC" option! I also figured out how to apply the filtering properly so things are looking...
McClendon, Rick
rmcclendon@...
Jun 8, 2005 6:42 pm
2127
Hi, Ok, I have added to my todo list to add support "composite" datatypes. ADS currently doesn't list them. thanks -John...
Hi again,
The problem occurs for every procedure. Scripting of the create of the
procedure also don't work. But it does not give any message either.
A sample...
I've typed a very simple SQL query in the Query Analyzer. When I hit the Execute button, the results show up just fine in the text window (split-pane view)....
Hi Brian, Can you tell me the database type and version you are working on? and what version/build of ADS you are using? It could be a capitalization issues....
Hi Abdullah, I tried your example below and it worked for me. I am able to script and bring up the editor for the function. The query that ADS uses to ...
Hello, The big thing holding me back from using ADS is that when I edit a record, if the table doesn't have a key, it won't let me save the changes to the...
Hi Chris, If your table doesn't have a primary key, then you can click on the "Primary Key" tab and select the columns you want the Table Editor to use as the...
John, A minor quirk, but is there a reason that, when looking at the Grid Results pane, if there are 2 result sets, you can change the height of the grid by...
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.
