Moving a table

 

Now that you have copied the INVENTORY_LIST table to the LIBRARY1 schema, move the SUPPLIERS table to LIBRARY1. To move a table, follow these steps:

1. From iSeries™ Navigator, expand the system that you want to use.

2. Expand Databases and the database that you want to work with.

3. Expand Schemas.

4. Double-click Tables.

5. Click SAMPLELIB.

6. Right-click SUPPLIERS and select Cut.

7. Right-click LIBRARY1 and select Paste.

You can move a table by dragging and dropping the table on the new schema. 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, you can move the table to the target system. However, you cannot delete the table from the source system, causing two instances of the table to exist.

 

Parent topic:

Copying and moving a table