Specifying how to load DEL data into the table columns

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

Fields and controls



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

  1. Open the Columns page of the Load notebook.
  2. Optional: Change the default method by which the data file columns are loaded into the table. When you use the default method, the data in the first file column is loaded in the first table column, and so on.

    You might want to change the default method to exclude a table column from being loaded with data or to specify the column position of the data for a particular table column (for example, to load the tenth data column into the first table column).

    To change the default method:

    1. Select the Include columns by check box.
    2. Select a table column and select the Change push button to open the Change window so you can exclude the table column from being loaded with data or specify the data column position.
    3. Repeat step b for each table column for which you want to change default values.
  3. 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.
  4. 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.
  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.


Related information