HP (Hewlett-Packard) 544530-001 Manuale Utente
Examples
This command displays the value set for the markup option:
SQL>show markup
MARKUP RAW
MARKUP RAW
SHOW MODE Command
The SHOW MODE command displays the operating mode of the current Neoview Script session.
The default is SQL.
The default is SQL.
Syntax
SHOW MODE
Considerations
In the Neoview Script interface, you must enter the command on one line. The command does
not require an SQL terminator.
not require an SQL terminator.
Example
This command shows that the mode of the current session is CS:
>show mode
MODE CS
MODE CS
For more information, see
.
SHOW MVGROUPS Command
The SHOW MVGROUPS command displays all or a set of the materialized view groups in the
current schema of the Neoview Script session.
current schema of the Neoview Script session.
Syntax
SHOW MVGROUPS [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display materialized view
groups with names that match the character string.
wild-card-pattern
groups with names that match the character string.
wild-card-pattern
matches an uppercase string unless you
enclose it within double quotes. To look for similar values, specify
only part of the characters of wild-card-pattern combined with
these wild-card characters:
only part of the characters of wild-card-pattern combined with
these wild-card characters:
Use a percent sign to indicate zero or
more characters of any type. For example,
%art%
more characters of any type. For example,
%art%
matches SMART, ARTIFICIAL,
and PARTICULAR but not smart or
Hearts
Hearts
. "%art%" matches smart and
Hearts
but not SMART, ARTIFICIAL,
or PARTICULAR.
%
Use an underscore to indicate any single
character. For example, boo_ matches
BOOK
character. For example, boo_ matches
BOOK
and BOOT but not BOO or BOOTS.
"boo_"
matches book and boot but not
boo
or boots.
_
116
Neoview Script Interface Commands