Re: Updating DB2 table from one IBM i to Another IBM i

[Charles Wilt <charles.wilt@xxxxxxxxx>]

on the old box...

INSERT INTO library.table1
 SELECT col1, col2, col3 FROM newprod.library.table1

Charles

On Wed, Aug 7, 2019 at 12:00 PM Brian Piotrowski <
bpiotrowski@xxxxxxxxxxxxxxx> wrote:

> Hi All,
>
> Not sure if this belongs in this list, but I'll start here.
>
> We're having problems with one of our PLCs connecting to our new Power9
> box (long story, but there's a PMR open with IBM on it).  However, the PLC
> can still connect to our old Power7 box successfully, but there's no
> updated data on it (since it's the old box).  So with that, I need to
> temporarily transfer data from our Power9 to the Power7 until this PMR is
> resolved.  I was hoping to do it through an SQL statement to save the
> trouble of running a backup/restore job since it's running so frequently.
> Basically I have this (IP addresses are arbitrary - the real ones are
> something else):
>
> NEWPROD (IP 10.10.10.2)
> TABLE1 -> Data
>
> OLDPROD (IP 10.10.10.1)
> TABLE1 -> Data
>
> (NEWPROD was an Option 21 backup/restore of OLDPROD, so all library/member
> structures are identical).
>
> I know there must be a way to transfer data through an SQL statement, but
> I'm having trouble trying to remember what I need to do.
>
> From a pseudocode perspective I need to execute an "INSERT INTO
> oldprod/table1 (SELECT col1, col2, col3 FROM newprod/table1)" statement to
> move the data.
>
> I'll probably just write a trigger statement to transfer the data once it
> sees a change.  But if someone would be so kind as to give me a hand on
> what I need to do I would appreciate it.
>
> Thx.
>
> /b;
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com