Re: Three part naming error connecting to a particular lpar.

Yeah, the i itself can have only 1 active connection - I think that's good-enough terminology.

You CAN do that if you have what is called a federated system. IBM® InfoSphere™ Federation Server provides this - it is not an IBM i product, though.

There is info at
https://www.ibm.com/support/knowledgecenter/en/SS2K5T_10.5.0/com.ibm.swg.im.iis.db.fed.overview.doc/topics/cfpint01.html

Here's an opening statement on that page -

With a federated system, you can send distributed requests to multiple data sources within a single SQL statement. For example, you can join data that is located in a DB2 table, an Oracle table, andan XML tagged filein a single SQL statement.

Sounds like a SPENDMONEY kind of thing, but it's possible. I don't know if there's another IBM (or other vendor) product that provides this.

Regards
Vern

On 7/16/2020 7:04 AM, Rob Berendt wrote:

I've not figured out a way to do it with one statement. I use a stored procedure for this.
Read from one system and store it into a variable. Use that variable to update the other systems.

CREATE PROCEDURE ROB.PROPAGATE_QLNKOMT()
LANGUAGE SQL MODIFIES SQL DATA
SET OPTION DATFMT = *ISO

P1 : BEGIN
DECLARE OMIT_LIST CHARACTER VARYING ( 32000 ) ;

SELECT FSXCMD INTO OMIT_LIST
FROM QUSRBRM . QA1AFS
WHERE FSNAME = 'QLNKOMT'
;
UPDATE RACK1HST . QUSRBRM . QA1AFS
SET FSXCMD = OMIT_LIST
WHERE FSNAME = 'QLNKOMT' ;
...

Rob Berendt