Neoview Script Guide (R2.2)

SQL>show list_count
LISTCOUNT 0 [All Rows]
• This command shows that the maximum number of rows to be displayed by SELECT
statements in the session is five:
SQL>set list_count 5
SQL>show list_count
LISTCOUNT 5
SHOW MARKUP Command
The SHOW MARKUP command displays the value set for the markup option.
Syntax
SHOW MARKUP
Considerations
In the Neoview Script interface, you must enter the command on one line.
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 97).
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]
122 Neoview Script Interface Commands