Export Options (2 of 3) panel

Panel and field definitions

  Process   Options   Utilities   Help
 ────────────────────────────────────────────────────────────────────────────────
 ZDT/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.