![]() ![]() ![]() |
Ispirer SQLWays Database Migration Software
LOAD Command
The IBM DB2 LOAD utility moves data from files, named pipes, or devices into a IBM DB2 table. The load utility is faster than the import utility, because it writes formatted pages directly into the database, while the import utility performs SQL INSERTs.
Options
Requirements: IBM DB2 7.1 or later
Specifies that the data to be loaded resides on a remotely connected client. If this option is not specified the data must reside on the server.
For example, the following command allows you to load an ASCII text file located on the client to a remote IBM DB2 database.
![]() ![]() ![]() |