IBM Books

Include columns by

Click on one of the following radio buttons to specify the column method by which all input file columns will be imported into the table. All input file columns are selected from the input file and imported in the table.

The available methods vary depending on the file type and import mode you selected on the File page:

Default (method D)
Indicates that when data is being imported, the first column of the file is imported into the first column of the table you selected, and so on, in the natural order of the input file. If the input file contains more columns than the target table, the additional columns at the end of the input file are dropped.

Position (method P)
Indicates that each data column will be specified by the number of its position (for example, 1 for first column) in the input file.

Location (method L)
Indicates that each data column will be specified by its starting and ending column locations in the input file.

Names (method N)
Indicates that each data column will be specified by its name in the input file.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]