Neoview Script Guide (R2.2)

Considerations
In the Neoview Script interface, you must enter the command on one line. The SHOW PREPARED
command can be executed only in SQL mode.
Examples
• This command shows all the prepared statements, by default:
SQL>show prepared
S1
select * from t1
S2
select * from student
T1
select * from test123
SQL> show prepared s%
S1
select * from t1
S2
select * from student
SQL> show prepared t%
T1
select * from test123
SHOW PROCEDURES Command
The SHOW PROCEDURES command displays the procedures (Stored Procedures in Java) in
the current schema of the Neoview Script session. If a pattern is specified, all procedures matching
the pattern are displayed. By default, all procedures in the current schema of the Neoview Script
session are displayed.
Syntax
SHOW PROCEDURES [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display procedures 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.
_
126 Neoview Script Interface Commands