SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-51
Examples—SHOW PARAM
Examples—SHOW PARAM

This example displays two parameter values:
>> SHOW PARAM ?PNUM, ?ST;
?PNUM 4103
?ST TEXAS

This example displays the value of every currently defined parameter:
>> SHOW PARAM *;
SHOW PREPARED Command
SHOW PREPARED is an SQLCI command that displays prepared commands.
command-name
is the name you specified for the command when you prepared it.
*
displays all the currently prepared commands.
Example—SHOW PREPARED
This example displays a prepared command named SELALLCU:
>> SHOW PREPARED SELALLCU;
select * from sales.customer
>>
SHOW PREPARED { command-name [, command-name ] ... } ;
{ * }