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
- 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.
- Right-click the object, and click or .
The task assistant for that you
selected for Import or Load opens.
- 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.
- Click Preview Command to expand
the Command section, and then review the generated
commands.
- Click Run to run the commands that
are displayed in the Command section.
- 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.