... It doesn't appear to be in this case though (I deliberatly typo'ed the 'procedure' key word). What I included was all I got, other tools manage to display...
Thomas Chiverton
thomas.chiverton@...
Oct 1, 2004 5:14 pm
1422
Hi Tom, Many of the Oracle specific tools do what you are describing. I do have on my todo list to build a more comprehensive PL/SQL-Stored Procedure ...
... Excellent news, that is exactly what I wanted to hear :-) -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email:...
Thomas Chiverton
thomas.chiverton@...
Oct 4, 2004 2:46 pm
1424
Hi, I have finished the first round of development of visual editing for security. I am still doing extensive testing and polishing up a few things, but...
Hi, I am evaluating Aqua Data Studio 3.7. It seems I can not see public database links and public synonyms when I browse around the schema tree. I'd like to...
Hi Yi, It seems that I must have missed this, but the PUBLIC schema doesn't return from the Oracle catalog tables. I have added the PUBLIC schema in the list...
Hi Yi, Oops, forgot the other question .... You can script the Table CREATE DDL SQL for a table by right-clicking on it for a popup menu then selecting Script...
Hi, i think i found a little bug: in index columns list (in index properties window) ADS shows for datetime fields type - "uniqueidentifier" MS SQL 2K ADS...
Krutyakov Roman
mark@...
Oct 6, 2004 4:15 pm
1429
I simply want to be able to copy the datastudio.jar file in to order to update the system. When I open up the zip file that is downloaded, everything bu the...
Al Schoen
alschoen@...
Oct 6, 2004 4:15 pm
1430
Hi Al, The datastudio_3_7_12.jar is the datastudio.jar file. You do not need to unzip it. All you need to do is rename it. There is no installation process...
I understand that. But when I click on the link, in the email, "http://www.aquafold.com/download/datastudio_3_7_12.jar", I end up downloading a...
Al Schoen
alschoen@...
Oct 6, 2004 9:30 pm
1432
Hi Al, Can you tell me what OS and Browser you are using? How your browser handles the default method of downloading and saving a file is dependant on the...
Al, Your download utility is assuming the ".jar" file is a zip file and making it the default file type. Just navigate to where you have the current jar file...
Hi Roman, Thanks for pointing this out. I have fixed the bug. You can the fix with this build ... http://www.aquafold.com/download/datastudio_3_7_12_2.jar ...
I am running Windows XP SP2 (the issue existed even with SP1) and IE 6. The filename that is displayed when I click on your link has the .ZIP extension. I did...
Al Schoen
alschoen@...
Oct 7, 2004 4:29 pm
1436
Hi John, I have a question. When I go into query analyzer and want to enter a table name in the 'FROM' section, I didn't know that it should also show you the...
Hi John, I am not 100% sure what your question is, but here is a quick explanation of the auto-completion ... Auto-completion tries to identify the position...
ADS 3.7.11, DB2 UDB 7.2 data See below; The depenencies of the table, shows a serie of 'codes' like 'LMS.P0023330'. The 'LMS' part is our schema name, but the...
Hi Marco, I have added the procedures to the dependancies. They needed to be joined with the sysdependancies and packagedep tables to get the full list. I...
Thanks John, This response speed is so unheard of in IT, very impressive!!! Found though that it looks like it is doubling up on the internal names and the ...
Hi all, I'm new to ADS I think that its great! Well done John and the team. Just one question though, does ADS support DB2 7.1 on OS/390? Frik ... From: John...
Lubbe, Frik
FLubbe@...
Oct 8, 2004 8:47 am
1442
Hi Marco, The list of dependancies is based off of the the following tables : syscat.constdep, syscat.indexdep, syscat.trigdep, syscat.viewdep, ...
Hi Frik, ADS's interface for DB2 is for DB2 Universal Database. Which is what I am assuming you are using. In this case you should be able to connect with...
Hi John, What would be really really handy is the following; In DB2 you cannot drop or insert a column. Therefore the table needs to be dropped, then rebuild....
Hi Marco, The ADS Table visual editor has support for dropping columns ... generating the SQL that is. The problem is that DB2 is the only database that does...
John, I am trying to modify permissions on tables in MSSQL and Sybase using GUI, but fail to see how to do it. Can you give a hint? Thanks, Michael ... for ......
Hi Michael, I you "Alter User" or "Alter Role" the general tab will have a button called "Object Permissions". If you click on this button it will give you...
Hi, just started to evaluate Aqua and i find it very nice to browse our Sybase 12.5.3 servers. but ... i found that program freezes when try to select anything...
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.
