Author Topic: FM Pass-through SQL issues  (Read 121 times)

Offline BIengineer

  • Full Member
  • ***
  • Join Date: Sep 2020
  • Posts: 9
  • Forum Citizenship: +0/-0
FM Pass-through SQL issues
« 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