DB2 graphic  QMF Version 8

Saving and appending to a table

To save your table in the database, enter:

SAVE DATA AS tablename

If you want to append the table to an existing table, enter:

SAVE DATA AS tablename (ACTION=APPEND

Where tablename is the name of the table to which you want to append the new table.

For example, to append a table that is called NEWAPPTS to the existing table CALENDAR, enter:

DISPLAY TABLE NEWAPPTS
SAVE DATA AS CALENDAR (ACTION=APPEND

The new table must have the same number of columns and the same data types as the existing table.


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