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

SQL>show sqlterminator
SQLTERMINATOR .
For more information, see “Setting and Showing the SQL Terminator” (page 64).
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
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 STATISTICS Command 145