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

[Peter Dow <petercdow@xxxxxxxxx>]

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