The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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

asked 01 Aug '11, 17:51

UkiwiS's gravatar image

UkiwiS
46237
accept rate: 50%

edited 15 Mar '13, 17:59

Mark%20Culp's gravatar image

Mark Culp
22.3k9129262

Do you receive the same error if you use dbisql (the Java version)?

(01 Aug '11, 17:57) Tyson Lewis

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]

permanent link

answered 01 Aug '11, 23:22

John%20Smirnios's gravatar image

John Smirnios
8.7k377106
accept rate: 40%

edited 01 Aug '11, 23:26

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×137
×95
×51

question asked: 01 Aug '11, 17:51

question was seen: 1,214 times

last updated: 15 Mar '13, 17:59