Using SQL scripts in interactive console on ACS with different systems

The new system is V7.2 the old is V5.4.

I am trying to copy the systables on our old machine with the systables in
the new system to prove that all records restored.

I ran the following statements. The first completes normally whilst the
second fails for the local system.

create table dfreinkel1.systables_PRIN as (Select * from
prin.qsys2.systables ) with data;

create table dfreinkel1.systables.PRIN9 as (Select * from
D7006840.qsys2.systables) with Data ;

I have tried removing the system name D7006840 but still get this error.

SQL State: 56023
Vendor Code: -512
Message: [SQL0512] Statement references objects in multiple databases.
Cause . . . . . : The statement refers to objects that reside on multiple
databases. The objects could be either explicitly qualified object names
or alias names that are defined to reference a different database. This SQL
statement can only refer to a single database. A CREATE TABLE AS that
selects from a remote database cannot reference a table that has a
FIELDPROC defined. It cannot define a materialized query table. If the
remote database is not on an IBM i server, the INCLUDING clauses are not
allowed. Recovery . . . : Ensure all objects used in the statement
reside at the same database. Try the request again.

Questions:
1. Is this not possible to do?
2. What work arounds are there?

TIA

Darryl Freinkel