Using QMF

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:

• Tablename is the name of the table to which you are adding data
• value1, value2, value3 is the data you are adding to each column.

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.