CODEWITHSUNDEEP
databaseibm-midrange
user10191234
user10191234

Reputation: 637

Copy tables between databases in AS400

I have 2 DB2 databases (testing and production). In order to move tables between them, some users have a (probably coded by an admin) function called ftpfile from inside the emulator. I do not have access to the said emulator, my account has *INITIAL_MENU_NAME = 'SIGNOFF' but I can connect from third party tools like DBeaver. Is there a way to move tables between environments?

Upvotes: 0

Views: 401

Answers (1)

Charles
Charles

Reputation: 23793

It would seem very unlikely for you to have the authority to "move tables".

You might be able to copy the data.

The easiest way would be something like so, while connected to the destination system.

delete from library.table
with nc;

insert into library.table
  select * from system2.library.table  
  with nc;

But being able to do that requires that the systems and your user profile be configured to allow it.

Really the right answer here is for you to contact your admin/security team and get the access required to do your job.

Upvotes: 2

Related Questions