2399976 - Get "Invalid option 'NON_KEYWORDS' " when running dbunload to rebuild SQL Anywhere 10 or lower versions

Symptom

When upgrading SQL Anywhere 5.0/9.0/10.0 (version lower than 10.0.1.4310) to SQL Anywhere 12.0/16.0/17.0, you need to run dbunload to rebuild the database first.

Then you may get SQL error: Invalid option 'NON_KEYWORDS' -- no PUBLIC setting exists when running dbunload.

For example:

>dbunload -c uid=***;pwd=***;dbf=***.db -an test.db

Adaptive Server Anywhere Unload Utility Version 9.0.2.3508

***** SQL error: Invalid option 'NON_KEYWORDS' -- no PUBLIC setting exists.

Environment

SQL Anywhere lower than 10.0.1.4310

Product

SAP Sybase SQL Anywhere 12.0

Keywords

dbunload, upgrade, sql anywhere, NON_KEYWORDS, no public setting, invalid option, sql error , KBA , sql anywhere , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.