This radio button specifies that, for each table column,
data is loaded according to start and end positions in the data file.
This radio button is selected and unavailable if the Nondelimited
ASCII format (ASC) radio button on the File page is selected.
Method L is the only method available for ASC files.
When this radio button is selected, the following fields are displayed in
the Table column box:
- Table column
- Specifies the name of a column in the table that you are loading data
into.
- Include
- Specifies whether data will be loaded into this table column.
Possible values are Y (data will be loaded) or N (data will not be
loaded).
- Start position
- Specifies the byte location in the load file of the beginning of the data
column that you want loaded into the table column.
- End position
- Specifies the byte location in the load file of the end of the data column
that you want loaded into the table column.
- Null indicator
- Specifies the data file column (by byte location) that contains the null
indicator flag for the data being loaded into the table column. The
default value is zero (0), specifying that the data column is not nullable
(which means there will always be data to be loaded into this table
column).
You can change the values of the Include, Start
position, End position, and Null indicator fields
by selecting a table column and clicking on Change. The
Change window opens.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]