Neoview Script Guide (R2.2)

Considerations
In the Neoview Script interface, you must enter the command on one line. The SHOW
PROCEDURES command can be executed only in SQL mode.
If you do not specify a wild-card pattern, Neoview Script displays all procedures that exist in
the current schema.
If you specify a wild-card pattern, Neoview Script displays only the procedure names that match
the wild-card pattern.
Examples
This command shows all the procedures, by default:
SQL>show procedures;
PROCEDURES NAMES
-------------------------------------------------------------------------------------------
ADJUSTSALARY DAILYORDERS EMPLOYEEJOB HELLO
HELLOSTRING LOWERPRICE MONTHLYORDERS MYPROC
N0101 N0122 N0124 N0200
N0202 N0209 N0210 N0211
N0212 N0213 N0216 N0226A
N0302 N4210 N4260 N4261
N4264 N4267
SHOW SCHEMA Command
The SHOW SCHEMA command displays the current schema of the Neoview Script session.
Syntax
SHOW SCHEMA
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 current schema of the session is PERSNL:
SQL>show schema
SCHEMA PERSNL
For more information, see “Setting and Showing the Current Schema” (page 59).
SHOW SCHEMAS Command
The SHOW SCHEMAS command displays all or a set of the schemas that exist in the default
catalog of the current Neoview Script session.
Syntax
SHOW SCHEMAS [wild-card-pattern]
wild-card-pattern
is a character string used to search for and display schemas with names that match the
character string. wild-card-pattern matches an uppercase string unless you enclose it
SHOW SCHEMA Command 127