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
23.2k9132272

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.9k377112
accept rate: 39%

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
×99
×54

question asked: 01 Aug '11, 17:51

question was seen: 1,274 times

last updated: 15 Mar '13, 17:59