CRMQ (Create MQT for Table)

The CRMQ row command generates SQL to create a Materialized Query Table. This command is valid in table lists. When entering the command, the Edit Create MQT for Table outer and inner windows (see the following figure) display listing columns from the selected Table. You can refine the list of columns to be in the MQT, and define the other characteristics of the Materialized Query Table.

To generate CREATE SQL from multiple tables, use the CRMQ primary command.

Create MQT for Tables outer and inner windows