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

Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• You can execute this command only in SQL mode.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Example
This command shows that the SQL terminator for the current session is a period (.):
SQL>show sqlterminator
SQLTERMINATOR .
For more information, see “Setting and Showing the SQL Terminator” (page 48).
SHOW STATISTICS Command
The SHOW STATISTICS command displays if statistics has been enabled or disabled for the
current session.
Syntax
SHOW STATISTICS
Considerations
• You must enter the command on one line. The command does not require an SQL terminator.
• The SHOW STATISTICS command works in all modes.
• If the SET TIMING command is set to ON, the elapsed time information is displayed.
Example
This command shows SHOW STATISTICS disabled and then enabled:
SQL>show statistics
STATISTICS OFF
SQL>set statistics on
SQL>show statistics
STATISTICS ON
SHOW SYNONYMS Command
The SHOW SYNONYMS command displays all or a set of the synonyms in the current schema
of the NCI session.
Syntax
SHOW SYNONYMS [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display synonyms with names that match the
character string. wild-card-pattern matches an uppercase string unless you enclose it
SHOW STATISTICS Command 141