Examples
• This SHOW PREPARED 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 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 55).
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]
120 Neoview Script Interface Commands