Moving a file
You can move a database file from one library to another using iSeries™ Navigator or the Move Object (MOVOBJ) command.
Moving a file (table) using iSeries Navigator
To move a file (table) to a different library, follow these steps:
- From iSeries Navigator, expand the system you want to use.
- Expand Databases.
- Expand the database and schema that you want to work with.
- Click the Tables container.
- Right-click the table and click Cut.
- Right-click the schema you want to move the table to and click Paste, or drag the table and drop it on another library on the same system or a different system.
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 iSeries Navigator to actually move or copy the table. If the operating system on the source system is running Version 4 Release 4 or later and if the operating system on the target system is running Version 4 Release 2 or later, the operation is performed using DDM over TCP/IP. Otherwise the operation is performed using DDM over SNA. For a move or copy operation using DDM over SNA, the names by which iSeries 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 operation 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 iSeries 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.
Parent topic:
Basic operations for managing database files
Related concepts
Distributed data management
Control language
Related reference
Move Object (MOVOBJ) command