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

It's not
RPGLE DDM
vs
RPGLE SQL
that's the issue here. The issue is trying to do an update to one system with data from another in a single statement. Granted RPGLE without SQL has no such concept. There is no
update rmtfile (read localFile);
statement in RPGLE without sql.
So DDM or SQL both require two separate parts. Local data then remote data
So this is fine
Select colA, colB, colC into :varA, :varB, varC from localfile where mykey = :keyvar;
Insert into rmtsystem.rmtfile values(:varA, :varB, :varC);
While this is not:
Insert into rmtsystem.rmtfile values(select colA, colB, colC from localfile where mykey = :keyvar);

You cannot even do:
select * from sysibm.sysdummy1
where ibmreqd in(select ibmreqd from gdi.sysibm.sysdummy1);
or you will get
SQL State: 56023 Vendor Code: -512 Message: [SQL0512] Statement references objects in multiple databases.

And, yes, it would be quite easy to write a UDTF to work around this.

Rob Berendt