Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.

I'm migrating SQL Anywhere 6.0 database to the 12.0 version. I have unloaded the database structure using the Sybase Central 3.0. The unloading was successful. After that I created a new SQL Anywhere 12.0 database using the Sybase Central 6.1, and used loaded the database structure with iSQL using following command:

read c:\..\reload.sql;

I'm getting the following error:

Could not execute statement.
Invalid option 'describe_java_format' -- no PUBLIC setting exists
SQLCODE=-200, ODBC 3 State="42000"
File: "reload.sql" on line 11, column 34
You can continue executing or stop.

SET OPTION describe_java_format= 'binary'

How this should be fixed? Thanks

asked 19 Jan '12, 05:42

sam's gravatar image

accept rate: 0%

There are huge differences between v6 and v12, particularly with regard to Java. You need to do your unload using the facilities in v12, which will produce a reload file compatable with v12 - a v6 one (as produced by Sybase Central 3) won't be.

Have a look here for detailed instructions.

If you are using java features, you will need to have a look at the extensive Java changes by going through all the Behaviour Changes sections in the documentation for v6 > v7 > v8 > v9 > v10 > v11 > v12, see here for 10 > 11 > 12 changes & here for v6 > v7 > v8 > v9 > v10 changes.

Besides Java there are likely to be other changes that affect your application and database.

Good luck with the process. If you run into other problems I suggest posting them here as new questions.

permanent link

answered 19 Jan '12, 06:43

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 19 Jan '12, 05:42

question was seen: 2,725 times

last updated: 19 Jan '12, 06:43