DB2 graphic  QMF Version 8

Writing your own query to add rows

You can write your own insert query by using SQL statements.

To create an insert query, use the SQL INSERT statement. The syntax of the INSERT statement is:

INSERT INTO tablename
  VALUES (value1, value2, value, ...)

Where:

To write an insert query:

  1. Enter:
    RESET QUERY (LANGUAGE=SQL
    The SQL query panel displays.
  2. Use the SQL INSERT statement to add data to each column.

    If you do not specify data for a column, QMF adds a null value.

  3. Press the Run function key to run the query.

QMF adds the new row to the table.

Repeat these steps to add additional rows to the 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