A report author is considering which SQL syntax to use for accessing various Data sources.
What is the advantage of using one type of SQL syntax above another?
A report author is considering which SQL syntax to use for accessing various Data sources.
What is the advantage of using one type of SQL syntax above another?
With Pass Through SQL and Native SQL, the SQL may not work on a different database. This is because these types of SQL are designed to leverage the specific features and optimizations of the underlying database engine, which may not be compatible with other databases. Therefore, using Pass Through SQL and Native SQL can lock the SQL into the specific syntax and capabilities of a particular database, making it less portable.
incorrect. answer correct is B https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_fm.doc/t_change_sql_type.html