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 for Me (Login required).

Search for additional results

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