DB2 Query -512 error

[YL5956]

I'm running a query that select rows from a db2 subsystem and then cross-referencing those rows to a table on a different db2 subsystem.

My query is running into a -512 error. Does anyone know why I'm getting this error?

Select Pkg_name from RMS.COMPONENT
where pkg_name is not in
(select pkg_name from RTD.CM_BSLN_TRACKING)

The RMS.COMPONENT table is in the DB2X subsystem while the RTD.CM_BSLN_TRACKING table is in the DB2Y subsystem.

Any help would be greatly appreciated. Thanks.

 

[MarcLodge]

I think that if you are referencing tables across different db2 subsystems you will need to fully qualify the table ie subsystem.owner.name. Taking your example, you would have to say:

SELECT PKG_NAME FROM DB2X.RMS.COMPONENT
WHERE PKG_NAME IS NOT IN
(SELECT PKG_NAME FROM DB2Y.RTD.CM_BSLN_TRACKING)

Hope this helps,
Marc