Column numbers (method P)

This radio button specifies that, for each table column, data is loaded according to the position of the data column in the data file.

This radio button is selected if either the Delimited ASCII format (DEL) or Integrated exchange format (IXF) radio button on the File page is selected. This radio button is available only if the Include columns by check box is selected. Method P is valid only for files that are in delimited ASCII (DEL) or integrated exchange (IXF) file formats.

If 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 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).

Column position

Specifies the position (1=first, 2=second, and so on) of the data file column to be loaded into this table column.

You can change the values of the Include and Column position 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 ]