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

First off there's sql naming (system.schema.table) then there's system naming (system/library/file). This is "3 part naming". Never tried it with system naming, only sql naming.

See also WRKRDBDIRE. Ensure that both systems show up here, on both systems.

See also ADDSVRAUTE, DSPSVRAUTE, CHGSVRAUTE. Alas no WRKSVRAUTE. It helps to have whomever runs this feed in here.

I think having system value QRETSVRSEC set to 1 helps.

Then it becomes really simple to pull data from another system with stuff like the following:
insert into rob.barf
(select * from gdihq.erplxf.rco)
;


Rob Berendt