Import utility

Import overview
The import utility populates a table, typed table, or view with data using an SQL INSERT statement. If the table or view receiving the imported data already contains data, the input data can either replace or be appended to the existing data.
Privileges and authorities required to use import
Privileges enable users to create or access database resources. Authority levels provide a method of grouping privileges and higher-level database manager maintenance and utility operations. Together, these act to control access to the database manager and its database objects.
Importing data
The import utility inserts data from an external file with a supported file format into a table, hierarchy, view, or nickname.
Additional considerations for import

Parent topic: Data movement utilities and reference