Regresar
-
Título
Netezza table flagged as Invalid database object name in Cross connection query -
Descripción
Cross-Connection query set up to combine data from DB2 and Netezza and list order numbers that are only on Netezza. Pop-up error message says that:
"NZSQL (e328545), NZMK_PRD1_HUB'.ADMIN.ORDERHEADER is an invalid database object name."
Non-cross-connection query against this table works fine; DB2 table isn't flagged as invalid.
-
Resolución
In your cross-connection query statement, ensure a 4 part name like: `Connection`.database.schema.table