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
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.
- 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 used to separate data when the Delimited variables (CSV) data format option is specified on the Export Options (1 of 3) panel. 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). |