DB2 graphic QMF Version 8

DRAW command

The DRAW command creates a basic query for a table based on the description of the table in the database.

Syntax

>>-- DRAW TableName -----------------------------------------------------<<
                     +- ( --- TYPE = --- SELECT -----+
                           |          +- INSERT -+   |
                           |          +- UPDATE -+   |
                           +- IDENTIFIER = CorrName -+

Parameters

Table 39. DRAW Command Parameters
Parameter Description
TableName The name of the table for which to create a query.
TYPE Specifies the type of SQL query to create. The default is SELECT.
IDENTIFIER Specifies the correlation name to be associated with the table in the resulting query. It is ignored when TYPE=INSERT. There is no default.

Example

DRAW Q.STAFF (TYPE=SELECT


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