Using QMF

DRAW command

The DRAW command creates an example table or adds a COMMENTS box, CONDITIONS box, or target table to a QBE query.

If you specify the DRAW command by itself (or press the Draw function key), an empty table appears. DRAW has the following forms:

• COMMAND ===> DRAW
  

• COMMAND ===> DRAW name
  

• COMMAND ==> DRAW COMM
  

• COMMAND ==> DRAW COND
  

DRAW

Draws an empty target table.

| | | | | -----------+-----------+-----------+-----------+-----------| | | | | |

DRAW name

Draws an example table with the name of the table or view in the first column.

If name specifies an existing table or view, QMF draws an example of that table or view. The example table has the same number of columns with the same column names as the table or view name has. The width of each column in the example table depends on the data type for each column.

For example, DRAW Q.STAFF produces this example table:

Q.STAFF | ID | NAME | DEPT | JOB | YEARS | SALARY | COMM | --------+----+------+------+-----+-------+--------+------| | | | | | | | |

If name is qualified with an owner and a location, and if your database supports 3-part names, QMF draws an example table with the fully-qualified name in the table-name column. For example:

VENICE.Q.STAFF | | | | | -----------------+-----------+-----------+-----------+-----------| | | | | |

If name specifies a nonexistent table, QMF draws an example table with the name specified appearing in the table-name column. For example, if there is no table in the database that is named EMPTYBOX, DRAW EMPTYBOX produces this example table:

EMPTYBOX | | | | | ------------+-----------+-----------+-----------+-----------| | | | | |

DRAW COMM

Adds an empty COMMENTS box:

| COMMENTS | |--------------------------| | |

DRAW COND

Adds an empty CONDITIONS box:

| CONDITIONS | |--------------------------| | |