Examples

  1. To display a command prompt panel for exporting a table:
      EXPORT TABLE ?
  2. To export a query from QMF temporary storage to a transient data queue:
      EXPORT QUERY TO queuename (QUEUETYPE = TD)
  3. To export DATA to a transient data queue with a dataformat of IXF:
     EXPORT DATA TO queuename (QUEUETYPE=TD 
    CONFIRM=NO DATAFORMAT=IXF

    You can abbreviate the command keywords:

      EXP DATA TO queuename (QUEUET=TD CONF=N DATA=IXF
  4. If you are running under CICS/MVS and 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 queuename (QUEUETYPE = TS
  5. To export a table to a TS queue in IXF character format:
      EXPORT TABLE KMMTABLE TO MYQUEUE
       (QUEUETYPE=TS DATAFORMAT=IXF OUTPUTMODE=CHARACTER
[ Previous Page | Next Page | Contents | Index ]