- To display a command prompt panel for exporting a table:
EXPORT TABLE ?
- To export a query from QMF temporary storage to a transient data queue:
EXPORT QUERY TO queuename (QUEUETYPE = TD)
- 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
- 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
- To export a table to a TS queue in IXF character format:
EXPORT TABLE KMMTABLE TO MYQUEUE
(QUEUETYPE=TS DATAFORMAT=IXF OUTPUTMODE=CHARACTER
[