Neoview Command Interface (NCI) Guide (R2.3)

Use an underscore (_) to indicate any single character.
For example, boo_ matches BOOK and BOOT but not
BOO or BOOTS. "boo_" matches book and boot but
not boo or boots.
_
Use a question mark (?) to indicate any single character.
For example, boo? matches BOOK and BOOT but not
BOO or BOOTS. "boo?" matches book and boot but
not boo or boots.
?
Considerations
• 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, NCI displays
all the materialized view groups that exist in the current schema.
• If you specify a wild-card pattern in a SHOW MVGROUPS command, NCI displays only
the materialized view group names that match the wild-card pattern.
• You can execute this command only in SQL mode.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
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 NCI session.
Syntax
SHOW MVS [wild-card-pattern]
136 NCI Commands