DB2 graphic  QMF Version 8

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.SALARY, S.COMM                        
      FROM Q.STAFF S
  2. If your table names or column names contain: The DRAW command surrounds the names with double quotes.
      DRAW MYTABLE

    Here is the result:

      SELECT NORMALNAME, KEYWORDFOLLOWS, "UNION"
           , "HAS BLANKS IN IT", "SPECIAL+CHARS_IN!"                     
           ,  "Mixed_Case_%S" FROM USER.MYTABLE 
  3. When using the DRAW command in a QMF procedure, you must use delimited identifiers (double quotes) to continue a query object name across more than one line within a QMF linear procedure. All continuation lines must have a plus sign (+) in column one:
    Figure 5.
    PROC                                       MODIFIED LINE    1
    
     RESET QUERY
     DRAW
     +"LOCXXXXXXXXXXXX"."AUTHXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
     +XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"."OBJXX
     +XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
     +XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"


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