Understanding DB2®: Learning Visually with Examples

Chapter 12

A1:	The load utility supports CURSOR as the input. The cursor must be already declared before the load utility is invoked. The entire result of the query associated with the specified cursor will be processed by the load utility.
A2:	When the load utility is invoked in INSERT mode, one needs INSERT privileges on the target table. If REPLACE mode is used, INSERT and DELETE privileges on the target table are also required.
A3:	Rows that do not comply with the table definition will not be loaded and placed in the dump file. Therefore stockdump.dmp contains: 20, "BBB", - 40, "EEE", x
A4:	Rows that violated the unique constraint will be deleted and inserted into the exception table. Therefore stockexp has the following row: 30, "DDD", 4 ...