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

SQL>show markup
MARKUP RAW
Elapsed time:00:00:00:078
SHOW MODE Command
The SHOW MODE command displays the operating mode of the current NCI session. The default
is SQL.
Syntax
SHOW MODE
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Example
This command shows that the mode of the current session is CS:
>show mode
MODE CS
Elapsed time:00:00:00:078
For more information, see “MODE Command” (page 106).
SHOW MVGROUPS Command
The SHOW MVGROUPS command displays all or a set of the materialized view groups in the
current schema of the NCI 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 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:
Use a percent sign (%) to indicate zero or more
characters of any type. For example, %art% matches
SMART, ARTIFICIAL, and PARTICULAR but not smart
or Hearts. "%art%" matches smart and Hearts but
not SMART, ARTIFICIAL, or PARTICULAR.
%
Use an asterisk (*) to indicate zero or more characters
of any type. For example, *art* matches SMART,
ARTIFICIAL, and PARTICULAR but not smart or
Hearts. "*art*" matches smart and Hearts but not
SMART, ARTIFICIAL, or PARTICULAR.
*
SHOW MODE Command 135