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

Thanks Vern.  They might be willing to SPENDMONEY, but I'm not sure. This is a stopgap measure to move one application from v5r4 to v7r3, but that app will have to utilize files that remain on the v5r4 system for awhile.  It would probably depend on the $ and how complicated it is to set up a federated system.


On 7/16/2020 5:53 AM, Vernon Hamberg wrote:

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