Specifying file options

Use the File page of the Import notebook to specify the file and type of file that you want to import.

Fields and controls

Authorities and privileges



To specify file options:

  1. Open the Import notebook.
  2. In the Import file field, type the name of the file that contains the data you want to import.
  3. Specify the type of file to import by selecting one of the following radio buttons:
  4. Optional: Specify file type modifiers by clicking on the corresponding Options push button. The Options window for that format opens.
  5. Select the Import mode you want to use. The available import modes vary depending on the file type you selected.
  6. Optional: In the Commit records field, specify the number of records to import before the changes are committed.
  7. Optional: In the Restart field, specify the number of records in the file to skip before beginning the import.
  8. Optional: In the Compound field, type a number to specify how many SQL statements will be executed (in an executable block).
  9. Optional: Select the Insert an implied decimal point on decimal data (IMPLIEDDECIMAL) check box.
  10. In the Message file field, type the name of the file that will contain warning and error messages that occur during import.
  11. Optional: Click on the Large Objects tab to specify that large objects be retrieved into separate files.
  12. 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