Getting error "unknown database '_xxx' " when trying to run a query from an Oracle database linking to a Netezza database.
See below the complete error message:
Error:XX/XX/XXXX 00:00:00 0:00:00.000: Cross Query Database Error: Unknown database '_xxx'
The issue point to an ODBC link issue, from the error msg it seems Toad can not connect to the netezza db.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad for Data Analyst
Sample script
SELECT CONTACTOR.ID
, BSBCONTACTOR.ID
FROM
`Netezza - Prod (riz01)`.CM_ODS_DB.CM_DW_OWNER.CONTACTOR CONTACTOR
JOIN
`CHORDP (RIZ01)`.CCSOWNER.BSBCONTACTOR BSBCONTACTOR
ON (CONTACTOR.ID = BSBCONTACTOR.ID)
WHERE (CONTACTOR.ID NOT IN (BSBCONTACTOR.ID))
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy