Symptom
Since SAP IQ 16.1 SP05 PL16, Query_Plan_Command_Line option is added newly.
The default setting shows OFF on IQ.
(DBA)> select * from sysoptions where [option] = 'Query_Plan_Command_Line'
user_name option setting
-----------------------------------------
PUBLIC Query_Plan_Command_Line OFF
(1 rows)
However, IQ document shows default setting is ON.
Which is correct setting ?
SAP IQ SQL Reference
https://help.sap.com/docs/SAP_IQ/a898e08b84f21015969fa437e89860c8/52b085ffa4bc43f382f27224a0bfae88.html?version=16.1.5.0
QUERY_PLAN_COMMAND_LINE Option
Allowed Values
ON, OFF
Default
ON
Read more...
Environment
SAP IQ 16.1 SP05 PL16
Product
Keywords
Query_Plan_Command_Line, sp_iqcheckoptions, default , KBA , BC-SYB-IQ , Sybase IQ , 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.
SAP Knowledge Base Article - Preview