DB2 graphic  QMF Version 8

Examples

  1. To display a prompt panel for the QMF IMPORT command:
      IMPORT ?
  2. To copy a CMS file called REPORT7 QUERY A into the database and give it the name FIRSTQ:
      IMPORT QUERY FIRSTQ FROM REPORT7
  3. To add data (NEW ROWS) to a table (MYTABLE):
      IMPORT TABLE MYTABLE FROM NEW ROWS A (ACTION=APPEND
  4. To import a table to a remote database server (VENICE), first connect to that location:
    CONNECT TO VENICE
    then import the table:
      IMPORT TABLE JEAN.STATSTAB FROM YOURFILE
  5. If your current location is a DB2 UDB for z/OS server, and you wish to copy a file (STATS TABLE G) from the system where QMF is executing to an existing table (OKAMOTO.STATUS) at a remote database location (TOKYO):
      IMPORT TABLE TOKYO.OKAMOTO.STATUS FROM STATS TABLE G
  6. QMF Administrator (QMFADM) importing a form for another user (JEAN):
      SAVE FORM JEAN.REPORT12 (COMMENT=(12 MONTH FORMAT)


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