Use this field to indicate the type of import mode that
will be used. The available modes vary depending on the file type you
selected. Use one of these methods:
- Select the up or down arrows to spin through the available choices.
- Type a value into the field.
The valid modes are:
- CREATE
- Creates the table definition and row contents. If the data was
exported from a database manager table, indexes are also created. This
option can be used only with IXF files.
- INSERT
- Adds the imported data to the table without changing the existing table
data.
- INSERT_UPDATE
- Adds rows of imported data to the target table, or updates existing rows
(of the target table) with matching primary keys.
- REPLACE
- Deletes all existing data in the table and inserts the imported
data. The table definition and the index definitions are not
changed. This option can be used only if the table exists.
- REPLACE_CREATE
- If the table exists, deletes all existing data in the table and inserts
the imported data without changing the table definition or the index
definitions.
If the table does not exist, creates the table definition and row
contents. If the data was exported from the database manager, indexes
are also created.
This option can be used only with IXF files.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]