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.

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.

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.

Use ISO date format (DATESISO)

Select this check box to use International Standards Organization (ISO) format for all date data values:
yyyy-mm-dd

Prefix positive decimal values with a blank (DECPLUSBLANK)

Select this check box to use a blank space as a prefix for positive decimal values.

Preserve leading and trailing blanks in each field (KEEPBLANKS)

Select this check box to preserve the leading and trailing blanks in each field. If you do not select this option, all leading and trailing blanks that are not inside character delimiters are removed, and for all blank fields, a null value is inserted into the table.

Suppress recognition of double character delimiters (NODOUBLEDEL)

When this check box is checked, double character delimiters will not be recognized.

Prioritize character string delimiter over record delimiter (DELPRIORITYCHAR)

When this check box is checked, the character string delimiter will be prioritized above the record delimiter.

Column delimiter

This box contains the single-byte character that is used in the data file to signal the end of a column. To change this character, click on the down arrow to display a list of valid characters and select one.

Character string delimiter

This box contains the single-byte character that is used in the data file to enclose character strings. To change this character, click on the down arrow to display a list of valid characters and select one.

Decimal point character

This box contains the character that is used in the data file to signify a decimal point. To change this character, click on the down arrow to display a list of valid characters and select one.

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.

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 or the field 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 or the field 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 or the field 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