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

SHOW PARAM Command
The SHOW PARAM command displays the parameters that are set in the current NCI session.
Syntax
SHOW PARAM
Considerations
• 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 the SET TIMING command is set to ON, the elapsed time information is displayed.
Example
• This command shows that parameters that are set for the current session:
SQL>show param
lastname GREEN
dn 1500
sal 40000.00
• This command shows that when no parameters exist, the SHOW PARAM command displays
an error message:
SQL>show param
No parameters found.
For more information, see “Displaying the Parameters of the Session” (page 55).
SHOW PREPARED Command
The SHOW PREPARED command displays the prepared statements in the current NCI session.
If a pattern is specified, all prepared statements matching the prepared statement name pattern
are displayed. By default, all prepared statements in the current session are displayed.
Syntax
SHOW PREPARED [stmtNamePattern]
Considerations
• 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 the SET TIMING command is set to ON, the elapsed time information is displayed.
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
134 NCI Commands