DB2 Help

This box lists the path names to the data files that contain the large object (LOB) data to be loaded. Use the Add push button to add a path name to this box. You can also select a path name to be changed, removed, or rearranged.

The names of the LOB data files are stored in the data file column that will be loaded into the table's LOB column.

This box is available only when the Retrieve large objects (LOBs) from the specified paths (LOBSINFILE) check box is selected.

Add

Click on this push button to open the Add window so you can add the name of a LOB path to the LOB paths box.

The new entry is added to the list following the entry that is currently selected. If no entry is selected, the new entry is appended to the list.

Change

Click on this push button to open the Change window so you can change the name of the selected LOB path in the LOB paths box.

This push button is available only when a name is selected in the LOB paths box.

Remove

Click on this push button to remove the selected LOB path names from the LOB paths box. (The actual LOB files are not removed from the system.)

This push button is available only when one or more names are selected in the LOB paths box.

Click on this push button to move up one position the name of the selected LOB path in the LOB paths box.

This push button is available only when a name is selected in the LOB paths box.

Down

Click on this push button to move down one position the name of the selected LOB path in the LOB paths box.

This push button is available only when a name is selected in the LOB paths box.

Do not recognize character x'1A' as the end-of-file character (NOEOFCHAR)

Select this check box if you want to specify that the optional end-of-file character

x'1A'

is not to be recognized as the end of the file. It will be seen as a normal character.

Truncate trailing blank spaces when loading into variable-length database field (STRIPTBLANKS)

Select this check box to drop the trailing blanks after the last nonblank character when loading the data into a variable-length table column.

Truncate trailing nulls (0x00 characters) when loading into variable-length database field (STRIPTNULLS)

Select this check box to drop the trailing 0x00 characters when loading the data into a variable-length table column.

Suppress warnings about rejected rows (NOROWWARNINGS)

Select this check box to stop DB2 from issuing warnings when rows are rejected during the load process.

Insert an implied decimal point on decimal data (IMPLIEDDECIMAL)

Select this check box to specify that the location of an implied decimal point is determined by the column definition, and is not at the end of the value. For example, the value 12345 is loaded into a DECIMAL(0,2) column as 123.45 and not 12345.00.

Allow numeric data to be in binary format (BINARYNUMERICS)

Select this check box to allow binary data values to be loaded into NUMERIC table columns. Binary data includes INTEGER, SMALLINT, FLOAT, and REAL data.

If you select this check box, you must also select the Record length in characters check box and specify the length of the records. Also, the Do not recognize character x'1A' as the end-of-file character (NOEOFCHAR) modifier is implicitly assumed, even if you do not select that check box.

The following rules apply for binary data values that are loaded into NUMERIC table columns:

No conversion between data types is performed, other than for INTEGER and SMALLINT data.
Data lengths must match their target column definitions.
FLOAT data values must be in IEEE Floating Point format.

Allow numeric data to be in packed decimal format (PACKEDDECIMAL)

Select this check box to allow packed decimal data values to be loaded into NUMERIC table columns. Packed decimal data is the binary format for DECIMAL data.

Data lengths of packed decimal data values to be loaded must match their target column definitions.

Allow numeric data to be in zoned decimal format (ZONEDDECIMAL)

Select this check box to allow zoned DECIMAL data to be loaded directly.

Data lengths of zoned decimal data values to be loaded must match their target column definitions.

Supported values for the sign nibble are

+ = 0xC 0xE 0xF
- = 0xD 0xB

Supported values for digits are 0x0 to 0x9, inclusive

Supported values for zone are 0x3 and 0xF.

Perform reduced sanity checking on user supplied column values (FASTPARSE)

Select this check box to enhance performance of the load utility by reducing the amount of data checking that is done on user-supplied column values. Even with the reduced amount of data checking, the loaded table is guaranteed to be architecturally correct and the load utility is guaranteed to perform sufficient data checking to prevent a segmentation violation or trap. Data that is in a correct form will be loaded correctly.

Use default values on defaultable columns when missing input data (USEDEFAULTS)

Select this check box to specify that if an input value is missing for a particular table column and that table column has a default defined on it, the default value will be inserted in place of the missing value.

Record length in characters

Select this check box to specify a number of characters to be read in for each row. If you select this check box, a new-line character is not used to indicate the end of a row.

Specify the number of characters by using one of these two methods:

Select the up or down arrows to spin through the available choices.
Type in a value.

Percentage of free space in each data page (PAGEFREESPACE)

This field contains the percentage of each data space that is to be left as free space. To change this percentage, use one of these methods:

Select the up or down arrows to spin through the available choices.
Type in a value.

For example, if you specify 50, then 50% of each data page is left as free space. The default value of 0 specifies that no space in each data page will be specifically left as free space.

If you specify an invalid value because of the minimum row size (for example, a row that is at least 3000 bytes long and a page free space of 50), the row will be placed on a new page. If you specify 100, each row will reside on a new page.

Percentage of total free space reserved in the table (TOTALFREESPACE)

This field contains the percentage of the total pages in the table that is to be appended to the end of the table as free space. To change this percentage, use one of these methods:

Select the up or down arrows to spin through the available choices.
Type in a value.

For example, if you select 20 and the table has 50 pages, then 10 additional empty pages will be appended. The total number of data pages for the table will be 60.

The default of 0 specifies that free space will not be appended to the end of the table.

Character used to denote null value (NULLINDCHAR)

Optional: Type a single-byte character to be used as the null indicator flag for this data file. In a given row in the data file, this character is specified in a null indicator column to denote a null value.

The character Y is the default null indicator flag.

Code page of data in input data set (CODEPAGE)

Enter the name of the code page for the data in the input data set.

Exception file to which rejected rows are written (DUMPFILE)

In this field, enter the name of the file to which you want the rejected rows to be written.

Custom date format

Use this field to specify that you want to load a customized date format. The date format can include the following elements. A default value is assigned for each element that is not specified.

YYYY

A string to indicate the year. You must use four digits to indicate the year.

MM, M

A string to indicate the month. You can use either one or two digits.

DD, D

A string to indicate the day. You can use either one or two digits.

DDD

A string to indicate the placement of the day within the year. You must use three digits to indicate the placement of the day.

Note:

You cannot use DDD if you use MM with DD.

Field separator

The field separator that you want to use to separate the different elements of the customized date format. The field separator is optional if no ambiguity exists regarding where one element of the date format ends and the next element begins. You can use any character as the separator except for the letters a to z (or A to Z), and digits. The field separator should not be the same as the character delimiter. Some characters, such as the double quotation mark (") and the back slash (\) must be preceded by a back slash escape sequence.

Some examples are as follows:

D-M-YYYY
MM.DD.YYYY
YYYYDDD
DD/MM/YYYY

Custom time format

Use this field to specify that you want to load a customized time format. The time format can contain the following elements. If an element is not specified, the value for that element defaults to 0 (zero).

HH, H

A string to indicate the hour. You can use one or two digits.

MM, M

A string to indicate the minute of the hour. You can use one or two digits.

SS, S

A string to indicate the second of the minute. You can use one or two digits.

SSSSS

A string to indicate the second of the day since midnight. You must use five digits. The valid range of values is 0 -- 86399.

Note:

You cannot use SSSSS if you use HH with MM and SS.

TT, AM, or PM

A string to indicate the meridian. You can, optionally, include periods (.).

Field separator

The field separator that you want to use to separate the different elements of the customized time format. The field separator is optional if no ambiguity exists regarding where one element of the time format ends and the next element begins. You can use any character as the separator except for the letters a to z (or A to Z), and digits. The field separator should not be the same as the character delimiter. Some characters, such as the double quotation mark (") and the back slash (\) must be preceded by a back slash escape sequence.

Some examples are as follows:

HH:MM:SS
HH.MM TT
SSSSS
H:MM:SS TT

Custom timestamp format

Use this field to specify that you want to load a customized timestamp format. The time format can contain the following elements. If an element is not specified, the value for that element is set to its default. The default is 1 for YYYY, MM, DD, and DDD, and 0 (zero) for all other elements.

YYYY

A string to indicate the year. You must use four digits to indicate the year.

MM, M

A string to indicate the month. You can use either one or two digits.

DD, D

A string to indicate the day. You can use either one or two digits.

DDD

A string to indicate the placement of the day within the year. You must use three digits to indicate the placement of the day.

Note:

You cannot use DDD if you use MM with DD.

HH, H

A string to indicate the hour. You can use one or two digits.

MM, M

A string to indicate the minute of the hour. You can use one or two digits.

SS, S

A string to indicate the second of the minute. You can use one or two digits.

SSSSS

A string to indicate the second of the day since midnight. You must use five digits. The valid range of values is 0 -- 86399.

Note:

You cannot use SSSSS if you use HH with MM and SS.

UUUUUU

A string to indicate the microsecond of the second. You must use six digits. The valid range of values is 000000 -- 999999.

TT, AM, or PM

A string to indicate the meridian. You can, optionally, include periods (.).

Field separator

The field separator that you want to use to separate the different elements of the customized timestamp format. The field separator is optional if no ambiguity exists regarding where one element of the timestamp format ends and the next element begins. You can use any character as the separator except for the letters a to z (or A to Z), and digits. The field separator should not be the same as the character delimiter. Some characters, such as the double quotation mark (") and the back slash (\) must be preceded by a back slash escape sequence.

Some examples are as follows:

YYYY/MM/DD
HH:MM:SS:UUUUUU
YYYY-MM-DD HH