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:                    
    Type                                                     
    1  1. Character  -->  ,                
       2. Integer    -->  -1                  
       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.
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.

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