2399976 - Get "Invalid option 'NON_KEYWORDS' " when running dbunload to rebuild SQL Anywhere 10 or lower versions | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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.


Read more...

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 ONE Support launchpad (Login required).

Search for additional results

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