*

Prints the current plan.

name

One‑ to seven‑character name of a plan definition.

WITH VERIFICATION

This clause collects data on the generate plan process for the specified plan without updating the DB2 plan tables or performing the DB2 BIND command.

It automatically prepares the programs in the specified plan and creates the BIND command that bind the plan to the application and produces an impact report. Use the GENERATE PLAN command to prepare the program and perform the bind.

VER is the minimum abbreviation.

DESTINATION

Specifies the output destination.

MAIL 'email‑id' A delimited 1‑ to 60‑character name of a [assign the value for emailp in your book] destination.

LIBRARY Output library.

SYSTEM name System printer name.

NETWORK name Network printer (not available in batch).

COPIES nn

Number of copies to print on a system or network printer, online only. This clause is ignored in batch.