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

 Delimited Variables (CSV):            Separator character
    Enter "/" to select option            Type
       Include column headers             1  1. Character  -->  , 
       "ASIS" encapsulation                  2. Integer    -->  -1

 CSV Null Indicator:                    Leading and Trailing Blanks
    Type                                   Enter "/" to select option                  
    1  1. Character  -->  ,                /  Include leading
       2. Integer    -->  -1                  Include trailing
       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.
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.
Separator character
The character used to separate data when the Delimited Variables (CSV) option is specified. The default separator character is a comma.
Include column delimiters
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.
CSV Null indicator type
Character
A character used to represent a null value when the Delimited Variables (CSV) option is specified. 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) option is specified. If Type 2 is specified, the default value used to represent a null value is -1.
None
When the Delimited Variables (CSV) option is specified, and Type 3 is specified, null values within the Db2 data are represented by an empty field in the exported file.
Leading and Trailing Blanks
Include Leading
When the Delimited Variables (CSV) option is specified, 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, choosing this option causes all of the blanks to be written to the exported file. The default is to include leading blanks.
Note: In previous releases, strings containing only blanks and no other characters were written to the exported file as an empty field.
Include Trailing
When the Delimited Variables (CSV) option is specified, 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, choosing this option causes all of the blanks to be written to the exported file. The default is to not include trailing blanks.

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