COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Framework Manager => Topic started by: BIengineer on 22 Oct 2020 04:10:04 am

Title: FM Pass-through SQL issues
Post by: BIengineer on 22 Oct 2020 04:10:04 am
The following query subject, utilizing two databases from each their own data source and running with Pass-Through SQL, with Oracle SQL on the DB side:

Select
   *
From
   CDB.PRODUCT as PRODUCTS
Where
   PRODUCTS.PRODUCT_ID not in (Select PRODUCT_ID from REPORTS.PROTECTED_ID);

Gives the following errors:

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'
UDA-SQL-0107 A general exception has occurred during the operation "prepare"
ORA-00933 SQL command not properly ended