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

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 69).
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.
142 NCI Commands