Loading data into a table, view, alias, or nickname

Use the Import or Load task assistant to load data into an object. The data is loaded from a file on the DB2 server file system, which can be local or remote.

Before you begin

The Database Administration feature must be installed. A connection to the database with the object to load data must exist.

About this task

You can use Import task assistant data to load data into a table, view, alias or nickname. You can use the Load task assistant to load data into a table or alias.

Procedure

  1. In the Object List, find the object that you want to load data into. You can use the Objects Name Search field to search for the object.
  2. Right-click the object, and click Load > With Import Utility or Load > With Load Utility.

    The task assistant for that you selected for Import or Load opens.

  3. In the Settings section, click each of the tabs to specify the setting and options with which to run the command, including the name and location for the input file. If the data to load contains large object (LOB) or XML data, you can specify separate directories for the location of the LOB data and of the XML data.
  4. Click Preview Command to expand the Command section, and then review the generated commands.
  5. Click Run to run the commands that are displayed in the Command section.
  6. In the Messages section, monitor the progress of the commands that are being run and review any messages that are issued. The results of running the commands are also displayed in the SQL Results view.

Results

The data is loaded into the object that you specified.

Feedback