Specifying file options when creating a new table

Use the File page of the Import notebook to specify the input file that will populate the new table and other options.

The table that you selected in the contents pane does not affect importing a file into a new table; rather, the table in the contents pane is selected only to open the Import notebook.

When you create a new table using the CREATE or REPLACE_CREATE import modes, you must specify: an input file, message file, and new table name (on the Columns page). After this input is provided, the OK button is enabled.

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 input file that will populate your new table.
  3. Select the Integrated exchange format (IXF) radio button from the Import file types box.
  4. Optional: Specify the file type modifiers for the Integrated exchange format (IXF) options by clicking on the corresponding Options push button. The Import IXF File Type Modifiers window opens.
  5. Select CREATE or REPLACE_CREATE from the Import mode box, depending on which option you want.
  6. Optional: In the Commit records field, type 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, specify a number to specify how many SQL statements to execute 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 to 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. Click on the Columns tab to specify the target table and column import options.


Related information