Neoview Script Guide (R2.2)

SHOW SQLTERMINATOR Command
The SHOW SQLTERMINATOR command displays the SQL statement terminator of the current
Neoview Script session.
Syntax
SHOW SQLTERMINATOR
Considerations
• In the Neoview Script interface, 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.
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 58).
SHOW SYNONYMS Command
The SHOW SYNONYMS command displays all or a set of the synonyms in the current schema
of the Neoview Script 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 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.
_
Considerations
• In the Neoview Script interface, 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 you do not specify a wild-card pattern in a SHOW SYNONYMS command, Neoview
Script displays all the synonyms that exist in the current schema.
• If you specify a wild-card pattern in a SHOW SYNONYMS command, Neoview Script
displays only the synonym names that match the wild-card pattern.
SHOW SQLTERMINATOR Command 131