SAP Knowledge Base Article - Preview

3726211 - The default setting for Query_Plan_Command_Line option - SAP IQ

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

SAP IQ 16.1 ; SAP IQ 16.2

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.