When using a SQL object, what is the property SQL syntax by default?
When using a SQL object, what is the property SQL syntax by default?
When using a SQL object, the property SQL syntax by default is IBM Cognos. Cognos software generates SQL by default as Cognos SQL to ensure compatibility with the data source and its functions. Users can change this to Native SQL or other formats if needed, but the default setting is set to IBM Cognos SQL to facilitate the initial operations and compatibility.
A is correct
Answer is B. "By default, the query information is generated as Cognos SQL. From the Query information type menu, you can change the viewing options to Native SQL or Query response." A bit tricky question, in Report Query default, is Native SQL rest in Cognos SQL.
A) is correct The default value is Native SQL https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/t_wrs_prps_en_SQLSyntax.html
Incorrect. By default, the query information is generated as Cognos SQL. From the Query information type menu, you can change the viewing options to Native SQL or Query response. https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ca_mdlg.doc/ca_mdlg.pdf