Moving a file
You can move a database file from one library to another using System i® Navigator or the Move Object (MOVOBJ) command.
Moving a file using System i Navigator
To move a file (table) to a different library (schema), follow
these steps:
- From System i Navigator, expand .
- Expand the database that you want to work with.
- Expand Schemas and the schema that contains the table that you want to move.
- Click Tables.
- Right-click the table that you want to move, and click Cut.
- Right-click the schema to which you want to move the table, and click Paste. Or drag the table to another schema on the same system or a different system.
Note: Moving a table to a new location does not always remove it from
the source system. For example, if you have read authority but not delete
authority to the source table, the table is moved to the target system; however,
it is not deleted from the source system, causing two instances of the table
to exist.
Distributed data management (DDM) is used by System i Navigator to actually move the table. The move operation is performed by using DDM over TCP/IP. TCP/IP must be enabled between the source and target systems in a way as they are known to System i Access.
Moving a file using the Move Object (MOVOBJ) command
The Move Object (MOVOBJ) command removes an object from its currently assigned library and places it in a different library. The type of the object moved is specified in the OBJTYPE parameter.