Considerations

•In the Neoview Script interface, you must enter the command on one line. The command does not require an SQL terminator.

•If you do not specify a wild-card pattern in a SHOW MVGROUPS command, Neoview Script displays all the materialized view groups that exist in the current schema.

•If you specify a wild-card pattern in a SHOW MVGROUPS command, Neoview Script displays only the materialized view group names that match the wild-card pattern.

•You can execute this command only in SQL mode.

Examples

•This command shows all the materialized view groups in the current schema, PERSNL:

SQL>show mvgroups

MATERIALIZED VIEW GROUP NAMES

-------------------------------------------------------------

MVGROUP1 MVGROUP2 EMPLOYEEINFO SQL>

•This command shows all the materialized view groups in the current schema, PERSNL, that have “GROUP” in their names:

SQL>show mvgroups %group%

MATERIALIZED VIEW GROUP NAMES

-------------------------------------------------------------

MVGROUP1 MVGROUP2 SQL>

•This command shows all the materialized view groups in the current schema, SALES, that are named “PART” followed by one character:

SQL>show mvgroups "PART_"

MATERIALIZED VIEW GROUP NAMES

-------------------------------------------------------------

PART1 PART2 PARTS SQL>

SHOW MVS Command

The SHOW MVS command displays all or a set of the materialized views in the current schema of the Neoview Script session.

Syntax

SHOW MVS [wild-card-pattern]

wild-card-patternis a character string used to search for and display materialized views with names that match the character string. wild-card-patternmatches an uppercase string unless you enclose it within double

SHOW MVS Command 117