SAP Knowledge Base Article - Preview

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


When upgrading SQL Anywhere 5.0/9.0/10.0 (version lower than 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

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



  • SQL Anywhere lower than


SAP Sybase SQL Anywhere 12.0


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.