Example 5
SELECT FROM(BOOKS) TO(PUBLISHR) ON(29,10,CH) FIRST -
DISCARD(SAVEREST)
This example creates the same PUBLISHR data set as Example 4. In
addition, it creates a SAVEREST data set that contains all of the
records not written to the PUBLISHR data set. The SAVEREST data set
might look as follows (several records are shown for illustrative
purposes):
How to Talk to Your Amoeba Brent Animals
What Buzzards Want Davis Animals
Birds of Costa Rica Davis Animals
.
.
.