Use the File page of the Import notebook to specify the file and type of
file that you want to import.
Before you begin...
To specify file options:
- Open the Import notebook.
- In the Import file field, type the name
of the file that contains the data you want to import.
- Specify the type of file to import by selecting one of the following radio
buttons:
- Optional: Specify file type modifiers by clicking on the
corresponding Options push button.
The Options window for that format opens.
- Select the Import mode you want to
use. The available import modes vary depending on the file type you
selected.
- Optional: In the Commit records
field, specify the number of records to import before the changes are
committed.
- Optional: In the Restart field,
specify the number of records in the file to skip before beginning the
import.
- Optional: In the Compound field,
type a number to specify how many SQL statements will be executed (in an
executable block).
- Optional: Select the Insert an implied
decimal point on decimal data (IMPLIEDDECIMAL) check box.
- In the Message file field, type the name
of the file that will contain warning and error messages that occur during
import.
- Optional: Click on the Large Objects tab to specify that large objects be retrieved into separate
files.
- Optional: Click on the Columns tab
to specify column import options.
Click on OK, to accept the parameters specified in this notebook
and begin the import process.
Related information
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]