DB2 graphic  QMF Version 8

Examples

  1. To display a command prompt panel:
    ERASE ?
  2. To erase the table PATTI.TABLEONE:
    ERASE TABLE PATTI.TABLEONE
  3. To erase a query named JBQUERY and display a confirmation panel.
    ERASE JBQUERY (CONFIRM=YES
  4. To erase the table PATTI.TABLETWO at the DALLAS location while your local location is BOISE, you must first connect to DALLAS:
    CONNECT TO DALLAS
    then issue the ERASE command:
    ERASE TABLE PATTI.TABLETWO
  5. When using the ERASE command in a QMF procedure, you must use double quotes to continue an authorization ID across more than one line within a QMF linear procedure. All continuation lines must have a plus (+) sign in column one.
    Figure 6. Continuing an authorization ID across more than one line using the ERASE command
    PROC                                                           MODIFIED LINE   1
     ERASE QUERY 
     +LOCATION12345678"."LONGOWNERID123456789012345678901234567890123456789012345678
     +9012345678901234567890123456789012345678901234567890123456789012345678"."LONGN
     +AME012345678901234567890123456789012345678901234567890123456789012345678901234
     +56789012345678901234567890123456789012345678"


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