12.4. The DB2 IMPORT Utility
The import utility inserts data from an input file into a table or a view. The utility performs inserts as if it was executing INSERT statements. Just like normal insert operations, DB2 validates the data and checks against the table definitions, constraints (such as referential integrity and check constraints), and index definitions. Triggers with satisfying conditions are also activated.
The utility supports options and import modes that let you customize its behavior. The syntax diagram of the import command is very long; Figure 12.10 shows only a portion of it. Please refer to the DB2 Command Reference for the complete syntax diagram.
Figure 12.10. Simplified syntax diagram of the import command
>>-IMPORT FROM--filename--OF--filetype--------------------------> ... |
Get Understanding DB2®: Learning Visually with Examples now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
