Export Options (2 of 3) panel

You use the Export Options (2 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 (2 of 3) panel
  Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 FM/Db2 (DFG2)             Export Options - (2 of 3)            Global Settings

 Null Indicators:
    Usage               Placement           Type                Indicator
    1  1. Separate         1. Before        2  1. One byte        Char
       2. None             2. After            2. Two byte      -1     Integer
                           3. User defined

 CSV Options            
    Enter "/" to select option           Separator character    
       Include column headers             1  1. Character    -->  , 
       "ASIS" encapsulation                   2. Integer     -->  -1
       Quoted values
       Single quotes                     Null indicator
       Leading zeros                      1  1. Character    -->    
    /  Include leading blanks                    2. Integer  -->  -1
       Include trailing blanks                   3. None     -->    
  
          
 Command ===>                                                                   
  F1=Help      F2=Split     F3=Exit      F7=Backward  F8=Forward   F9=Swap
 F10=PrvPage  F11=NxtPage  F12=Cancel
Usage
For nullable columns, determines whether fields in the exported data correspond to the null indicator:
Separate
A null indicator is output, taking into account the settings for Placement, Type and Indicator.
None
No fields in the exported data correspond to the null indicator.
CSV, use NI char
If you opt for CSV records (data format 5), this option outputs a null indicator as the separator.
The default is 1 (Separate).
Placement
Determines where the null indicator is placed:
Before
The null indicator is placed before the data for the column to which it applies.
After
The null indicator is placed after the data for the column to which it applies.
User defined
A 1-byte (character format) or 2-byte (signed integer format) null indicator is placed somewhere in the output record. Placement depends on mapping the null indicator to a corresponding field in the output record.

The default is 1 (Before).

Type
Determines the type of null indicator to be used:
One byte
1-byte (character format) null indicator.
Two byte
2-byte (signed integer format) null indicator.

The default is 2 (Two byte).

Indicator
Determines the value of the null indicator:
Char
The character used as the 1-byte (character format) null indicator. The default is blank.
Integer
The integer used as the 2-byte (signed integer format) null indicator. The default is an integer value of -1.
CSV Options
The following options are available when the Delimited variables (CSV) data format option is specified on the Export Options (1 of 3) panel.
Include column headers
Select this option to produce comma-delimited column headers as the first export record. The default is not selected.
"ASIS" encapsulation
Determines whether automatic encapsulation of column data is disabled. Select this option when the data has already been encapsulated in a user-defined character, prior to storage in Db2®. The default is not selected.
Quoted values
Select this option to enclose the CSV output field value in either double or single quotes. By default, output fields within a CSV file that contain an embedded delimiter, and fields consisting only of blanks, are enclosed in quotes. For single quotes, additionally select the Single quotes option.
Single quotes
Select this option to enclose output field values in single quote instead of double quotes.
Leading zeros
Select this option to format all numeric fields with leading zeros.
Include leading blanks
When the Delimited variables (CSV) data format option is specified on the Export Options (1 of 3) panel, Db2 CHAR or VARCHAR data containing leading blanks include the blanks when written to the exported file. If the Db2 data contains only blanks and no other characters, then choose both "Include leading blanks" and "Include trailing blanks" to cause all of the blanks to be written to the exported file. The default is to include leading blanks.
Include trailing blanks
When the Delimited variables (CSV) data format option is specified on the Export Options (1 of 3) panel, Db2 CHAR or VARCHAR data containing trailing blanks include the blanks when written to the exported file. If the Db2 data contains only blanks and no other characters, then choose both "Include trailing blanks" and "Include leading blanks" to cause all of the blanks to be written to the exported file. The default is to not include trailing blanks.
Separator character
The character or integer used to separate data when the Delimited Variables (CSV) option is specified. The default separator character is a comma.
Null indicator type
Character
A character used to represent a null value when the Delimited variables (CSV) data format option is specified on the Export Options (1 of 3) panel. If Type 1 is specified, the default character used to represent a null value is underscore.
Integer
An integer used to represent a null value when the Delimited variables (CSV) data format option is specified on the Export Options (1 of 3) panel. If Type 2 is specified, the default value used to represent a null value is -1.
None
When the Delimited variables (CSV) data format option is specified on the Export Options (1 of 3) panel, and Type 3 is specified, null values within the Db2 data are represented by an empty field in the exported file.

Parent panels

Child panels

To display this panel… Use/do this
Export Options (1 of 3) panel Press the PrvPage function key (F10)
Export Options (3 of 3) panel Press the NxtPage function key (F11) (the data format option 4. User defined, and the Data type format option, on the Export Options (1 of 3) panel must be selected).

Related tasks