- 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 data format
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 on z/OS, 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