three part name in queries

Srini S Rajan

three part name in queries
all

when i tried to use three part names to compare objects between sub
systems,

using the following query:

SELECT NAME, DBNAME FROM SYSIBM.SYSTABLES A
WHERE A.NAME NOT IN (SELECT B.NAME FROM rem1.SYSIBM.SYSTABLES B)
WITH UR;

I get the following error
SQLCODE = -512, ERROR: STATEMENT REFERENCE TO REMOTE OBJECT IS
INVALID

Is there any workaround ?

Srini S Rajan (Known As Sundar)

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ava Collins

Re: three part name in queries
(in response to Srini S Rajan)
Since remote and local tables can't be joined, one workaround is to build a
temporary table with the remote row(s). The local and temp table can be joined.

Jacquie

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Ava Collins

Re: three part name in queries
(in response to Ava Collins)
Since remote and local tables can't be joined, one workaround is to build a
temporary table with the remote row(s). The local and temp table can be joined.

Jacquie

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


*************************************************************************************
The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.
*************************************************************************************


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Campbell

Re: three part name in queries
(in response to Ava Collins)
Have a look at DB2 Information Integrator Classic Federation for
z/OS, might do the trick:

http://www-306.ibm.com/software/data/integration/iicf/


James Campbell

On 9 Dec 2003 at 16:40, Srini S Rajan wrote:

> all
>
> when i tried to use three part names to compare objects between sub
> systems,
>
> using the following query:
>
> SELECT NAME, DBNAME FROM SYSIBM.SYSTABLES A
> WHERE A.NAME NOT IN (SELECT B.NAME FROM rem1.SYSIBM.SYSTABLES B)
> WITH UR;
>
> I get the following error
> SQLCODE = -512, ERROR: STATEMENT REFERENCE TO REMOTE OBJECT IS
> INVALID
>
> Is there any workaround ?
>
> Srini S Rajan (Known As Sundar)
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm