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       -+

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	The correlation name to be associated with the table in the resulting query. It is ignored when `TYPE=INSERT`. There is no default.

Examples

DRAW Q.STAFF (TYPE=SELECT