- To display a command prompt panel for exporting a table:
EXPORT TABLE ?
- 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
- 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
- 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.
- To export data in IXF character format:
EXPORT DATA TO JBLP
(CONFIRM=NO DATAFORMAT=IXF OUTPUTMODE=CHARACTER
- To export a form using the current session language:
EXPORT FORM TO MYFORM (LANGUAGE=SESSION
- 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
- 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
- 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