Hi, How did you create the "test" table? The problem you are having is that the test table has column names with caps. I am assuming you did this with the...
John, Turning off the quote identifier for visual editing gave me what I was looking for... I realize that I lose the column case information on the import...
Hi, I have some problem with datas on Oracle. I use AMERICAN_AMERICA.AL32UTF8 charset both on server and client side. With sqlplus, I have a good result but...
The data was inserted with an ETL with AL32UTF8 charset (as the database charset). The only way to ADS to see correctly the text is to set ETL to use ...
Nicolas PASCALE
nicolas.accor@...
Jun 5, 2008 3:44 pm
6395
Hi, I isolate the problem I need some more information: 1. Can you use ADS to INSERT and SELECT the correct information independent of any other tool? 2. What...
John, Is there anyway to make this feature optional in version 7? Also, is there an option some where to ignore left and right parenthesis when showing the...
Hi, ... I've up it on the list. ... parenthesis when showing the matching the paired (open/close) parens of a statement? File->Options->SQL Editor->Highlight...
Hi 1. yes I can use ADS to insert correct information 2. I use "Oracle" connection type 3. We are using OpenText Genio 6.1 (hummingbird) with native connection...
Nicolas PASCALE
nicolas.accor@...
Jun 6, 2008 2:28 pm
6399
John, Thanks. But I did not need to turn on Highlight matching brace option, rather I want the option to ignore braces that may be part of a string literal...
Hi, You are using two different connection configurations for each tool. I would suggest using ADS with the "Oracle OCI" so that you are using the same...
Hi Jason, I guess I'd consider this a bug. It seems this has always been the behavior in the editor for matching brackets. This is part of the editor...
Thanks for the answer. I'll try this monday morning Best regards ... Thanks for the answer. I'll try this monday morning Best regards 2008/6/6 John LH <...
Nicolas PASCALE
nicolas.accor@...
Jun 6, 2008 6:13 pm
6403
Hi, When i select the table with Oracle OCI, it crash ADS # # An unexpected error has been detected by Java Runtime Environment: # #...
Nicolas PASCALE
nicolas.accor@...
Jun 9, 2008 2:40 pm
6404
Hi, You need to update the Oracle Drivers in Aqua Data Studio with the Oracle driver that comes with your Oracle Client installation. Here are docs on how to...
I am talking about ads 6.5. i see that a stored procedure can be used in conjunction with .variable. i just cannot find anywhere in the documentation that...
Hi, If you right click on the procedure in the schema browser you can Script Object to Window->EXECUTE BIND. This will give you an example. regards, -John...
Hi, This is undoubtedly a silly question that I should know the answer to but... When using ADS to perform updates and having Auto-commit turned off, one is...
Hi John, With autocommit turned off ADS gives those choices after performing an UPDATE statement. Clicking 'Rollback' rolls it back, 'Commit' commits the...
Hi, This prompt is happening because you have enabled the File->Options->General->Query Windows->Prompt for commit when auto-commit is OFF. Ignore means that...
Does that mean though that after hitting 'Ignore' that I can use another query window to test out those uncommitted results to see if I want to rollback or...
Hi, ... another query window to test out ... No. You can not see the changes from another query window or connection until you commit them. Uncommited...
OK thanks John. I was hoping I could do it in another window for simplicity but I can simply do my first testing, 'select' query before updating in another...
While running a Sybase query with a compute clause, I get ... JZ0P9: A COMPUTE BY query has been detected. That type of result is unsupported and has been...
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.
