Using QMF

Creating a copy of a table

You can create a table by copying the data from an existing table into a new table. You use SQL statements or QMF commands to create a copy of a table.

To create a copy of a table using QMF commands:

1. Enter DISPLAY TABLE tablename where tablename is the name of the table you want to copy.

   For example, if you want to create a new table from a copy of the CALENDAR table, enter DISPLAY TABLE CALENDAR.

   The table you want to copy displays.

2. Enter SAVE DATA AS tablename, where tablename is the name of the new table.

   For example, enter SAVE DATA AS MYCAL, to name the new table MYCAL.

   QMF creates a new table with the same data as the old table. In this example, MYCAL and CALENDAR both exist in the database with the same data.