on 2011 Aug 01 6:51 PM
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
Request clarification before answering.
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]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.