When using stored procedures I've found that you must have "DYNAMIC RESULT SETS 1" in the stored procedure. If you don't, it is assumed to be zero. When...
Hi Shawn, You are probably using the CALL command. This command is specific to the DB2 command tool, but isn't supported by DB2 the server. In ADS, if you...
I want to copy my configuration of servers that I have added from my computer to other computers. Is it stored in a file somewhere? I do not see it in the...
ADS-Settings are stored under your UserHome-directory: C:\Documents and Settings\<UserName>\.datastudio ... I want to copy my configuration of servers that I...
A related question. I once needed to recover a password from one of the connection files. Does anyone know if there is a way to decrypt these? Monty...
Hi, The encryption of passwords is to hide them. So, there isn't an "official" way of decrypting them. The reason is to prevent someone from taking the file...
Hi Shawn, Ok, I understand what you are doing. Let me explain what ADS does. When you execute "CALL <PROC>", ADS will execute this statement with the DB2 JDBC...
John, Yes we can. We can execute it correctly in the DB2 environment as well as a free product that we are currently using. The product is Query Tool. You...
Hi, Both the DB2 command tool and Query tool use the native drivers. ADS uses the JDBC driver. These drivers might work differently. I did a search for all...
Hi John, Thanks for putting in the 'Save' button in the procedure editor. Another 'cool' functionality that I know I would really appreciate would be to be...
Hello all, First, thanks for a great product. I'm starting to use ADS as my one-stop shop for MSSQL and Oracle database access. A question -- is it possible to...
Hi John, I am using Aqua 4.5.1 on Fedora core 3. I am connecting to a sybase database. I am trying to generate a create script using the script generator tool...
Hi Mailing List, I have problems connecting to my database since we moved it to another subnet. Previously it was running fine. The configurations are: Oracle...
Hi, I just looked into this. In Sybase, when creating a unique or foreign constraint, Sybase will create a supporting Index. ADS should not be scripting an...
Hi, When changing the IP address of an Oracle server you need to make sure that your hostname/ip DNS resolution is reconfigured in Oracle appropriately. I did...
Hello John, I used the 4.5.2 jar but I still get the following error - ... There is no unique constraint on the referenced columns in the referenced table...
Hi, Did you download the 4.5.2.1 build which I provided the link below? (not just the 4.5.2 build) http://www.aquafold.com/download/datastudio_4_5_2_1.jar Can...
I have a question about the format of the TIMESTAMP type. I've used the Options, Result Format to adjust the TIMESTAMP type to be returned as the follows:...
Does ADS support GUID's? I'm using SQL Server and we have columns that are defined as GUID's on our tables. When querying a table that has GUID we get the...
Hi Shawn, ADS does support GUIDs. Here is a screenshot with the table definition and results ... http://www.aquafold.com/screenshots/misc/SQLServer-GUID.jpg ...