If I open up a script and then choose Format Script from the right- click menu, then click Edit > Undo, the editor window goes blank. If I click Edit > Undo a...
John, SQL 2005 has a cool feature when you've defined a column as XML. When you query the table you get back the information in the XML defined column in Blue...
Hi, This seems to be a functionality of the editor component. We are upgrading the component in 7.0, so I've logged this as an issue to resolve for the...
Yes, I'm able to perform this action. When I do this an XML Editor window opens up and it shows all of the XML on one line. Is there a way to get it to be...
Hi, The XML you have doesn't have any line feeds. The ADS XML Editor currently doesn't support line wrapping. We are looking into supporting this as many have...
If I run the press the script parser button all I get is a single row containing Begin, End, Type, Statement Begin=1 End=185 Type=DML Statement=My Entire SQL...
Cool. Thanks so much. Shawn Hevel, API, AIT Lead Programmer Analyst Information Technology Department South Carolina Farm Bureau Insurance Companies Phone:...
One other thing on this topic. Since you have to make changes to support line wrapping, it would be pretty cool if you could change the color to blue in the...
Hi, The script parser only parses the script and shows you the raw SQL that will be executed as individual statements. It doesn't do any syntax checking as...
Hi: I'm trying to load a file into Sybase IQ using ADS and am running into issue. As far as I tell the problem is occurring with ADS not recognizing the...
Hi, Aqua Data Studio has an Import Tool. On the first Tab is an option "Platform" which determines the "newLine" character to use for the file. What OS was...
Hi John, Thanks for the quick reply. I'm trying to write a script that will be executed by another group, so using the import tool is not an option. The file...
Hi, I am not sure what part of ADS you are having problems with. The Import Tool allows you to generate a script of INSERT statments. Can you be more detailed...
Hi John, I figured it out. :) It seems its an issue with the ODBC drivers. The application called AQT works because it is using the older Sybase IQ Driver....
I have noticed that when using ALT-Tab to change programs in windows. If I am in ADS when I use ALT-Tab, when I return to ADS the menu is still highlighted and...
Hi, This was a bug in Java 1.5, but doesn't exist in Java 1.6. ADS is bundled with Java 1.6. What version of Java are you running ADS with ... what value do...
I am using java.version 1.6.0_02 java.runtime.version 1.6.0_02-b06 java.specification.version 1.6 ... have ... windows. ... is ... window to ... only a ... you...
Hello- I hope you all can help! I am testing the import/export features using files no more than 10 rows. I am finding that both the import and export "elapsed...
Hi, Not sure if the bug existed in that version. Can you update to the this ... 1. Rename <ADS_INSTALL>\jre to jre_old 2. Unzip this file into <ADS_INSTALL>...
Hi, Can you provide more information? Maybe a screenshot of the 3 screens before the export starts so we know what options you are choosing. Also, can you run...
... Hi Can't help you much, apart from saying that I'm regularly exporting 100k rows and importing 250k rows from/into an sqlserver db with no problems ...
Hi John, After changing my oracle password, I've been unable to logon to my production oracle database from ADS. My development and testing environments...
John, I have a DB2 stored procedure that I want to execute through ADS and one of the input parametes of this stored proc is a schema name. Is there some...
Hi, The error message you are getting is from the Oracle database. I don't think this is specific to Aqua Data Studio. Here is a description of the Oracle...
John, You're correct. The problem was from the connection string. Our DBA changed the host name of the database without updating the tnsnames.ora file where...
Hi, When I execute the following in Oracle's SqlDeveloper, everything works fine: set serveroutput on declare begin print_table('select * from settleaccount...
Hi, SqlDeveloper supports the SQLPlus client syntax. Aqua Data Studio doesn't support SQLPlus commands. I believe the reason you are getting the error below...
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.
