DB2 graphic  QMF Version 8

Creating a copy of a table

You can create a table by copying the data from an existing table into a new table. 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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004