Examples

1. To draw a SELECT query for the table Q.STAFF uniquely identified by S:

     DRAW Q.STAFF ( TYPE=SELECT IDENTIFIER=S

   Here is the result:

     SELECT S.ID, S.NAME, S.DEPT, S.JOB, S."YEARS"  -- S
          , S.SALARY, S.COMM                        -- S
     FROM Q.STAFF   S

2. If your table names or column names contain:
   • special characters
   • QMF reserved words
   • IBM SQL reserved words
   • DB2 reserved words
   The DRAW command surrounds the names with double quotes.

     DRAW MYTABLE

   Here is the result:

     SELECT NORMALNAME, KEYWORDFOLLOWS   -- USER.MYTABLE
          , "UNION" , "HAS BLANKS IN IT"                     -- USER.MYTABLE
          , "SPECIAL+CHARS_IN!", "Mixed_Case_%S"  -- USER.MYTABLE
     FROM USER.MYTABLE