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

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

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

Sem comentários

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