Examples

This command displays the value set for the markup option:

SQL>show markup

MARKUP RAW

SHOW MODE Command

The SHOW MODE command displays the operating mode of the current Neoview Script session. 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.

Example

This command shows that the mode of the current session is CS:

>show mode

MODE CS

For more information, see “MODE Command” (page 92).

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.

Syntax

SHOW MVGROUPS [wild-card-pattern]

wild-card-patternis a character string used to search for and display materialized view groups with names that match the character string. wild-card-patternmatches an uppercase string unless you enclose it within double quotes. To look for similar values, specify only part of the characters of wild-card-patterncombined 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 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.

 

 

116 Neoview Script Interface Commands