Use SQL to move data from prod400 to dev400, OS v7r2.

I'd like to use sql to refresh data for a file that resides on both our
dev & prod box.
(i want to move data from prod to dev box)

I've added RDB entries to both systems so they are cognizant of each
other.
(using wrkrdbdire, well, addrdbdire)

In interactive sql, I can use the-
connect to prod user myname using 'mypassword'
to connect FROM the dev to the prod box.

I successfully connect to prod, from dev and can perform select stmts
over prod data, from the dev session.

But, when connected to prod, i can't seem to reference the dev (local)
box.

for instance, i tried 3 part naming like below

insert into dev/jrpers/log
select * from prod/jrpers/log
this yields
Statement references objects in multiple databases.

Its sort of like - while connected to prod, from dev, access to the dev
data files
is unavailable to me. I've got to be missing some piece to the puzzle.

Any help from anyone who has done this successfully would be appreciated?
I've searched a lot for wrkrdbdire & addrdbdire and it's got me this far.

John

John Rusling
Senior Developer/Analyst
Quadion LLC
Minnesota Rubber & Plastics
952.927.1419
<br />
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it, is
prohibited and may be unlawful.