|
Hi I'm having a problem upgrading from 9.0.2.3044 to 11.0.1.2405. These are the steps I'm performing.
On step 3 I'm getting the error Missing closing quote at Position 0 in command If I edit the reload.sql file and do a find for %% and replace it with //%% I can reload the file fine but I do nto understand why I'd need to edit this in order to get it to work? Am I doing something wrong or have I missed something? Are there any switches I can use to resolve this without needing to edit the file? TIA KIWI |
|
To upgrade to v11 you should use v11 software. See http://dcx.sybase.com/index.html#1101/en/sachanges_en11/v10upgrade-up-sql-any-123456.html The following describes the behaviour you are seeing with the %-signs. http://dcx.sybase.com/index.html#1201/en/sachanges/sa11-deprecated-features.html percent_as_comment In previous releases, the percent sign (%) could be used as a comment marker depending on the setting of the percent_as_comment database option. Now, SQL Anywhere treats the % sign as a modulo operator. See MOD function [Numeric] Thanks for the information and the suggestion to try dbisql. The problem seems to be due to a comment in a trigger that contained the word [don't]. At Tyson's suggestion I tried dbisql and I'm happy to report that I do not have a problem if I use dbisql to reload the data and the upgrade completes successfully. Thanks for your help. Cheers KIWI
(02 Aug '11, 11:13)
UkiwiS
|
Do you receive the same error if you use dbisql (the Java version)?