Export Options (1 of 3) panel

You use the Export Options (1 of 3) panel to set various options that affect the way in which FM/Db2 operates. These options are saved in your ISPF profile and persist from one FM/Db2 session to the next.

Panel and field definitions

Figure 1. Export Options (1 of 3) panel
  Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)             Export Options - (1 of 3)            Global Settings

 Data Format:
    1  1. FM/Db2 (SQLDA) format        Enter "/" to select option
       2. Db2 UNLOAD format            /  Native unicode processing
       3. DSNTIAUL format
       4. User defined
       5. Delimited variables (CSV)

 Execution options:
    Select option
    2  1. Online                       Enter "/" to select option
       2. Batch                   -->     Batch data set creation
       3. Batch, using Db2 UNLOAD -->     Edit Db2 UNLOAD options

 More Options:
    Enter "/" to select option
    /  Null indicators / CSV options   (For user-defined, CSV data formats)
       Data type format                (For user-defined data format)
 Command ===>                                                                  
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F11=NxtPage  F12=Cancel
Data format
The format in which Export Utility unloads data:
  • FM/Db2 (SQLDA) format. Db2® internal format. This is the default.
  • Db2® external (or unload) format.
  • Db2® DSNTIAUL unload format. This is the format used by the Db2® DSNTIAUL sample program.
  • User-defined format.
  • Delimited Variables (CSV) format.

    FM/Db2 writes the data to the output file as a comma-delimited (CSV) file.

    The data for each column appears in the output record in column number order, and each data value is separated from the next by a separator character.

    Db2® data exported in this way cannot be imported using Import (option 3.6). The data is intended for use by a spreadsheet application program.

Native unicode processing
Determines how FM/Db2 processes Unicode encoded data when exporting data from a table to a dataset. Normally data stored in Db2® in Unicode is converted automatically to the CCSID of the Db2® plan, typically CCSID 37. This automatic translation results in conversion errors when a Unicode character does not have an equivalent code point in CCSID 37. When data is exported in "native Unicode" format, the automatic translation of data from unicode to the CCSID of the Db2® plan is suppressed. This ensures that there are no data conversion errors, but means the data is not directly visible using z/OS® utilities such as the editor. Use this option if the data is to be transferred to other systems that support Unicode data. When the option is not enabled, the option has no effect; that is, the default processing is used. When the data being exported is not Unicode encoded, the option has no effect, even if enabled.
⁄
Process Unicode data natively.
(blank)
Do not Process Unicode data natively. This is the default setting.
Execution Options
Online
The export is run in foreground.
Batch
Builds the necessary JCL to perform the Export utility in a batch job, and displays it in an edit session so that you can review the JCL prior to submitting the job.
Batch, using Db2® utility
Selecting this option runs the export using the Db2® UNLOAD utility.

Generates the JCL for the UNLOAD job, and displays it in an edit session so that you can review the JCL prior to submitting the job.

The default is Batch.

Batch data set creation
This option only applies when batch execution is selected, and is ignored for online execution. You use this option to defer the creation of the export data set to batch job execution time. When this option is not selected, FM/Db2 determines whether the export data set exists before generation of the batch job JCL. If the data set does not exist, you are prompted to create it.

The default is not selected, which means that export data set creation is not deferred to batch job execution time. When you set the execution option to Batch, using Db2® utility, this option is automatically selected and cannot be changed.

Edit Db2® UNLOAD options
Used in conjunction with option 3 Batch, using Db2® UNLOAD. The UNLOAD Options panel is displayed after you press the Exit function key (F3). The default is not selected.
More Options
Null indicators / CSV options
If selected, you can navigate to the Export Options (2 of 3) panel by pressing the NxtPage function key (F11).

This option is only selectable if you have also selected either the data format option 4. User defined or 5. Delimited variables (CSV)

When this option is displayed, the default is not selected.

.
Data type format
If selected, you can navigate to the Export Options (3 of 3) panel by pressing the NxtPage function key (F11).

This option is only selectable if you have also selected the data format option 4. User defined.

When this option is displayed, the default is not selected.

Parent panels

Child panels

To display this panel… Use/do this
Export Options (2 of 3) panel Select the Null indicators / CSV options option (data format option 4 or 5 must also be selected), and press the NxtPage function key (F11).

Related tasks