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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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