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:
- Open the Import notebook.
- In the Import file field, type the name
of the input file that will populate your new table.
- Select the Integrated exchange format
(IXF) radio button from the Import file types box.
- 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.
- Select CREATE or REPLACE_CREATE from the Import mode box,
depending on which option you want.
- Optional: In the Commit records
field, type 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,
specify a number to specify how many SQL statements to execute 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 to 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.
- Click on the Columns tab to specify the
target table and column import options.
Related information