Table of ContentsPreviousNext

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer DB2 Migration overview.

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.


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.

LOAD CLIENT FROM customers.txt OF del MESSAGES customers.log INSERT INTO customers 

Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.