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.

Fields and controls

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 the table contains an identity column, you can use the Identity column behavior drop-down box to specify how you want data to be loaded into the identity column.
6. If the table contains one or more generated columns, you can use the Generated column behavior drop-down box to specify how you want data to be loaded into them.

   Notes:

   1. If you want to load data into a table that contains a generated column, the table must be in the check pending state before the data is loaded.

   2. You cannot load data into a generated column if the column is also an identity column.
7. 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.

Related information

• Loading data into a table
• Turning off constraint checking for a table
• Turning on constraint checking for a table and checking the data
• Turning on constraint checking for a table without checking the table data