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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.