Data Movement Utilities Guide and Reference

Chapter 2. Import

This section describes the DB2 UDB import utility, which uses the SQL INSERT statement to write data from an input file into a table or view. If the target table or view already contains data, you can either replace or append to the existing data.

The following topics are covered:

• Import Overview
• Privileges, Authorities, and Authorization Required to Use Import
• Using Import
• Using Import with Buffered Inserts
• Using Import with Identity Columns
• Using Import with Generated Columns
• Recreating an Exported Table
• Importing Large Objects (LOBs)
• Importing User-defined Distinct Types (UDTs)
• Table Locking During Import
• IMPORT Command
• Import API
• File Type Modifiers (Import)
• Character Set and NLS Considerations
• Example Import Sessions
• Optimizing Import Performance
• Restrictions and Limitations
• Troubleshooting.

For information about importing DB2 Data Links Manager data, see Using Import to Move DB2 Data Links Manager Data. For information about importing data from typed tables, see Moving Data Between Typed Tables. For information about importing data from a file on the DB2 Connect workstation to a DRDA server database, and the reverse, see Moving Data With DB2 Connect.