Importing columns using the Location method

Use the Columns page of the Import notebook with the Location (method L) radio button selected to import columns from nondelimited ASCII format (ASC) input files to the target table. The starting and ending locations of the data column in the input file are used as the mapping method.

Before you begin...

To import columns using the location method:

1. Open the Import notebook, specify options on the File page, and open the Columns page.

2. Click on the Location radio button in the Include columns by box.

3. Select a column in the Table column box.

4. Click on the Change push button and change the column values.

5. Repeat steps 3 and 4 for every column.

6. Click on OK. The import process begins.

Related information

• Using default settings (method D)
• Mapping column positions (method P)
• Mapping column names (method N)
• Specifying the target table and columns when creating a table

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

[ DB2 List of Books | Search the DB2 Books ]