SAP Knowledge Base Article - Preview

2081666 - Do not delete PUBLIC option from sysoptions system table - SAP IQ


  • Do not delete PUBLIC option from sysoptions system table.
  • PUBLIC options that do not exist in sysoptions system table cannot be set as a user option.
  • When you set a user option, you receive the following error.

(DBA)> set option dba.Aggregation_Preference=1;
Could not execute statement.
  Invalid option 'Aggregation_Preference' -- no PUBLIC setting exists
  SQLCODE=-200, ODBC 3 State="42000"
  Line 1, column 39
  set option dba.Aggregation_Preference=1
Press ENTER to continue...



SAP IQ All versions


SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7


12.6, 12.7, 15.0, 15.1, 15.2, 15.3, 15.4, 16.0, sys table , KBA , BC-SYB-IQ , Sybase IQ , How To

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.