Examples

  1. To display a command prompt panel for exporting a table:
      EXPORT TABLE ?
  2. If you use remote unit of work, you can export an object (table, form, procedure, query, or report) from the current location to a data set at the system in which QMF is executing.
      EXPORT PROC KATIE.PANELID TO dataset
  3. If your current location is DB2 supporting remote data access, you can export a table from a remote DB2 location by including the location qualifier in the object name:
      EXPORT TABLE VENICE.LARA.STATSTAB TO dataset
  4. If your TSO prefix is TOM and you use the TSO data set 'TOM.LOREN.QUERY(GAMMA)':
      EXPORT QUERY FIRSTQ TO LOREN (MEMBER=GAMMA

    If you have no TSO prefix, your TSO user ID is used.

    If your prefix is set to blank, nothing is prefixed to the TSO name.

  5. To export data in IXF character format:
      EXPORT DATA TO JBLP
       (CONFIRM=NO DATAFORMAT=IXF OUTPUTMODE=CHARACTER
  6. To export a form using the current session language:
      EXPORT FORM TO MYFORM (LANGUAGE=SESSION
  7. To copy the form FORMA at the current location to the data set FORMS at the system where QMF is executing:
      EXPORT FORM FORMA TO FORMS.FORM
  8. To export a table from a remote database that does not support three-part names, first connect to that database:
      CONNECT TO VENICE
    then export the table:
      EXPORT TABLE JULIA.STATSTAB TO NONSTD
  9. To copy the table OKAMOTO.STATUS at the DB2 database in TOKYO to the data set YOURDATA on the system where QMF is executing:
      EXPORT TABLE TOKYO.OKAMOTO.STATUS TO YOURDATA
[ Previous Page | Next Page | Contents | Index ]