12.12. Review Questions

1:Which data movement utility supports the CURSOR input file type?
2:What other privileges are needed to load a table if the person already has LOAD authority?
3:Bob creates the stock table: 
								CREATE TABLE stock ( id        INTEGER NOT NULL
								, name      VARCHAR(10)
								, bandlevel INTEGER NOT NULL
								, PRIMARY KEY (id) )

He then loads the table with this load command:

								load from stock.del of del
								modified by dumpfile=stockdump.dmp
								messages stock.out
								replace into stock
								for exception stockexp

The input file stock.del looks like this:

10, "AAA", 30
20, "BBB", -
30, "CCC", 3
30, "DDD", 4
40, "EEE", x

After the load command is executed, which rows will be stored in the stockdmp.dmp file?

4:With the same target table definition, load command, and ...

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.

Start your free trial