2081666 - Do not delete PUBLIC option from sysoptions system table - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

  • 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...


Read more...

Environment

SAP IQ All versions

Product

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

Keywords

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.