Use the Columns page of the Import notebook to specify the table that will
be created and populated by the import, to specify table space options, and to
specify column import options.
Fields and controls
Authorities and privileges
To specify the target table and column import options:
- Open the Import notebook, specify options on the File
page, and open the Columns page.
- Select the Default (method D) radio button in the Include columns by box.
Location (method L), Position (method P), and
Names (method N) are not available for this action.
- Specify the schema type for the new or existing target table in the
Table schema field.
- Type the name of the new or existing target table into the Table name field.
If you chose REPLACE_CREATE as the import
mode on the File page and the table already exists, the table's rows are
deleted and repopulated by the input file.
- Optional: Use the Table space box
to select a table space in which to create the table.
Select a REGULAR DMS table space other than the default table space if you
want to specify an index table space or long data table space.
- Optional: Use the Index table space
box to select a table space in which to create any indexes on the
table.
- Optional: Use the Long data table
space box to select a table space in which to store the values of
any long columns.
- Optional: Add the column names you want created in
the target table into the Column names
box by clicking on the Add push button.
If you do not add column names, all of the columns in the input file are
imported with existing column names.
- Click on OK. The import process begins.
Related information