Copy a table

Copying a table to different schema creates two instances of the same table. To copy a table to a different schema:

  1. In the System i Navigator window, expand the system you want to use.
  2. Expand Databases.
  3. Expand the database and schema that you want to work with.
  4. Click the Tables container.
  5. Right-click the table and select Copy.
  6. Right-click the schema you want to copy the table to and select Paste.

Distributed data management (DDM) is used by System i Navigator to actually move or copy the table. If the source system is Version 4 Release 4 or later and if the target system is Version 4 Release 2 or later, the operation will be performed using DDM over TCP/IP. Otherwise the operation will be performed using DDM over SNA. For a move or copy using DDM over SNA, the names by which System i Access knows the systems must be the same as the remote location names specified in the APPC or APPN device descriptions used by DDM. For a move or copy using DDM over TCP/IP, TCP communications must be enabled between the systems. For TCP/IP, it is important to note that TCP/IP must be enabled between the systems as they are known to System i Access.