Specifying how to load ASC data into the table columns

Use the Columns page of the Load notebook to specify how to load the columns in the ASC data file.

To specify how to load the ASC data file columns into the table columns:

1. Open the Columns page of the Load notebook.

2. Select a table column and click on the Change push button to open the Change window.

3. Use the Change window to specify:
   • Whether to load data into this table column. The default is to load data into every table column (Include=Y).
   • The start position of the data column to be loaded into this table column.
   • The end position of the data column to be loaded into this table column.
   • The null indicator column for the data loaded into this table column.

   You must specify a start and end position if you are loading data into the table column (Include=Y).

4. Repeat steps 2 and 3 for each table column.

5. If you have specified all required information for the load process, you can start the load process now by clicking on OK. Otherwise, to specify required or optional information, or to change default values, go to one of the other notebook pages.

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

[ DB2 List of Books | Search the DB2 Books ]