DISPLAY and PUNCH Syntax › DISPLAY and PUNCH Operations

DISPLAY and PUNCH Operations

The DISPLAY and PUNCH operations produce as output the SQL statements that describe the named entity. DISPLAY and PUNCH operations do not update the entity description. You can choose to display or punch all the entity occurrences defined within an entity or only specific entity occurrences.

The location of the output depends on which verb is used and whether you are using the online or batch command facility:

• DISPLAY displays online output at the terminal and lists batch output in the command facility's activity listing.
• PUNCH writes the output to the system punch file. All punched output is also listed in the command facility's activity listing.

Benefit

With the DISPLAY and PUNCH support for SQL DDL entities, you can easily display or punch entity definitions and change them, or migrate their definitions from one environment to another. For example, you can migrate definitions from one schema to another in the same catalog, and from one catalog to another in the same or different Central Version.