The DRAW command creates a basic query for a table based on the description of the table in the database.
>>-- 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 | Specifies the correlation name to be associated with the table in the resulting query. It is ignored when TYPE=INSERT. There is no default. |
DRAW Q.STAFF (TYPE=SELECT