HP NEOVIEW 544530-001 Manual do Utilizador descarregar pdf (Página 117)

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-pattern

is a character string used to search for and display materialized views

with names that match the character string. wild-card-pattern

matches an uppercase string unless you enclose it within double

SHOW MVS Command 117

1 2 ... 112 113 114 115 116 117 118 119 120 121 122 ... 141 142

Sem comentários

HP NEOVIEW 544530-001 Manual do Utilizador Página 117