<<<<>>>>DRAW command<<<<>>>>

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

Syntax

>>--DRaw-tablename-+---------------------------+--<<
                  (+-Type=Select/Insert/Update-+
                   +-Identifier=corrname-------+

Uppercase letters in the diagram show the minimum set of letters required to issue the command.

Parameters

The following parameters can be specified for the DRAW command:

TYPE: Specifies the type of the query that you are creating. The default value is Select.
IDENTIFIER: Specifies the correlation name that will be associated with the table in the resulting query. This parameter is ignored when the value of the Type parameter is set to Insert.

Examples

DRAW Q.STAFF (Type=Select

DR Q.STAFF (Identifier=A