DB2 graphic QMF Version 8

EXPORT command

The EXPORT command copies objects from the database or temporary storage to a file.

Syntax

For a target object in the database:

>>-- EXPORT --- QUERY --- ObjectName TO FileName ------------------------<<
             +- PROC --+                          +- ( CONFIRM = YES/NO -+

>>-- EXPORT FORM ObjectName TO FileName ---------------------------------->


>------------------------------------------------------------------------<<
  +- ( --- CONFIRM = YES/NO -----------+
        +- LANGUAGE = ENGLISH/SESSION -+


>>-- EXPORT TABLE ObjectName TO FileName --------------------------------->
                                          +- ( --- CONFIRM = YES/NO -+
                                                +- DATAFORMAT = IXF -+

For a temporary target object:

>>-- EXPORT --- QUERY --- TO FileName -----------------------------------<<
             +- PROC --+               +- ( CONFIRM = YES/NO -+


>>-- EXPORT FORM TO FileName --------------------------------------------<<
                              +- ( --- CONFIRM = YES/NO -----------+
                                    +- LANGUAGE = ENGLISH/SESSION -+


>>-- EXPORT DATA TO FileName --------------------------------------------<<
                              +- ( --- CONFIRM = YES/NO -+
                                    +- DATAFORMAT = QMF/IXF/TEXT/HTML/CSV -+
                                    +- OUTPUTMODE = BINARY/CHARACTER/PC -+
                                    +- LOBSINFILE = YES/NO -+
                                    +- LOBSTO = path1;path2; -+
                                    +- LOBFILE = basefile1;basefile2; -+


>>-- EXPORT REPORT TO FileName ------------------------------------------<<
                                +- ( --- CONFIRM = YES/NO --+
                                      +- DATAFORMAT = QMF/HTML/TEXT -+

Parameters

Table 41. EXPORT Command Parameters
Parameter Description
ObjectName The name of the object to export from the database.
FileName The name of the file to which to export the object.
CONFIRM Specifies whether or not to display a confirmation dialog before replacing an existing file. If CONFIRM is not specified or is NO, the corresponding resource limit is used.
LANGUAGE Specifies whether a form is exported in English or in the current session language. A form that is exported in English can be run in any NLF session. A form exported in the session language can only be run in a session of the same language. The default value is provided by the DSQEC_FORM_LANG global variable.
DATAFORMAT Specifies the file format of the exported data. If you omit this parameter, the DSQQW_EXP_DT_FRMT global variable supplies the format to be used.

The file format can be:

  • 0 = Text format
  • 2 = HTML format
  • 3 = CSV format
  • 4 = IFX format

    If you specify IXF, the DSQQW_EXP_OUT_MDE global variable can be set to either '0' for character mode System/370 IXF or '1' for PC/IXF.

For Reports

QMF format is not supported in the Windows environment. HTML format adds the <PRE> tag. TEXT is for a text-based file.

OUTPUTMODE Specifies the output format of the data.
LOBSINFILE Specifies whether or not LOBs are included in the exported data.
LOBSTO Specifies the location to save the LOBs.
LOBSFILE Specifies the base name of the exported LOBs.

Example

EXPORT QUERY USER1.QUERY TO C:\Queries\query1.qry


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004