cancel
Showing results for 
Search instead for 
Did you mean: 

DB upgrade issue 9.0.2.3044 DB to 11.0.1.2405

Former Member
0 Kudos
2,916

Hi

I'm having a problem upgrading from 9.0.2.3044 to 11.0.1.2405.

These are the steps I'm performing.

  1. Unload 9.0.2.3044 DB using the Sybase 11 DBUNLOAD Utility to file reload.sql.
  2. Initialize a new DB using the Sybase 11 DBINIT Utility
  3. Reload the Data from reload.sql using Sybase 11 dbisqlc

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

Accepted Solutions (0)

Answers (1)

Answers (1)

johnsmirnios
Advisor
Advisor

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]

Former Member
0 Kudos

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