Does AquaDataStudio have the ability to script out all users and groups in a database Sybase? It can do it one at a time in the server browser, but I need to...
Hi, In 6.5 you need to do it one at a time since they are not supported in the schema script generator. 7.0 will have the ability to script all of them at...
Okay - thanks. I just wanted to make sure I wasn't missing something. One at a time is kind of tedious for a couple hundred users, so for now I'll still to...
Hi, Not sure when the beta will be available. But surely there will be something to see by June-July. 7.0 is the biggest feature release we have had, so it is...
Hi John We do a bit of work with different character sets. In particular we are using the thai character set at the moment. Now if i select some data from a...
Hi, If the text displays correctly in the Text Results, but not the Grid Results, then the problem is the font. The font you are using for the Grid Results...
I'm scripting a whole bunch of stored procedures with ADS Schema script generator (which is great). And here's a small user interface request that could save...
Hi Pasi, Currently you can't do this, but this is a good point. I've added this to the list, to apply to all areas that have object selections. We are trying...
John Just another question. I often use the "script to window as execute bind" functionality from the function/procedure tree of the package node. Fantastic...
Hi, In the schema browser you can't change the ordering. We do have on the list to come up with a ordering/sorting mechanism for this. You can use the Detail...
John Detail view isn't too much use for what i want. Which is to generate a bind script from a package procedure/function. But the search looks pretty useful....
Just wanted to see if anyone else is having (or had) an issues where after installing and opening the ADS package, the application will close, without error....
Hi, Yes, once you type the name to match and it matches the first item, you can use up/down arrow to move through the next/previous matches. regards -John...
Excellent, thanks John, that's exactly what i need. I usually know the item i am looking for, but sometimes there are a few matches. So that will work well. ...
Thanks John, I tried loading the version of Java as you mentioned. At first I thought that may have worked, but after appx. 20-25 seconds of being open and...
In our environment, Data Architects are granted permissions via the "SELECT ANY DICTINOARY" for production environment. In AquaStudio, I am unable to to see...
Hi, I would recommend removing these two and see if ADS then works ... ... Also, do you have any non-Microsoft device drivers? Primarily Video or Network...
I've been using the autocommit feature in Aqua Data Studio, and ran into an interesting situation. I ran a pl/sql procedure to insert records in a table....
Hi, ADS queries for sequences with the query .. SELECT SEQUENCE_NAME FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = 'HR' ORDER BY SEQUENCE_NAME Can you issue this...
Hi, AutoCommit commits after each statement execution in a script. If you execute an Oracle Procedure, then a commit is done only at the end of procedure...
John, Thanks so much for your response. A DDL statement is a CREATE TABLE or ALTER TABLE, right? I don't have either of these statements in my procedure. I...
John, Is there an easy way to find what is the script ADS uses for generating a 'Pivot' view of result set? For ex: I can want to save a result set (Ctrl+R),...
Last Friday a new version of the ADS software was installed onto our Production Support group's desktops. Our main dataserver is a Sybase ASE 12.5.4 which the...
Hi, What was the previous version/build of ADS? What is the current version/build of ADS? I need to know the versions to delta. ... getting recorded in the...
Running the follwing queries (where OWNREF is the Schema): SELECT SEQUENCE_NAME FROM ALL_SEQUENCES WHERE SEQUENCE_OWNER = 'OWNREF' ORDER BY SEQUENCE_NAME / 0...
Hi, Well, the problem is with ALL_ and USER_ tables. It seems your security is setup where you need to use the DBA_ tables instead of the ALL_ tables....
Original version was 6.0 The upgrade was done so that we're now on version 6.5.9 As for the audited sql it's all the queries against the system tabls as well...
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.
