NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-52
Examples—SHOW PARAM
Examples—SHOW PARAM
•
The following command displays two parameter values:
>> SHOW PARAM ?PNUM, ?ST;
?PNUM 4103
?ST TEXAS
•
The following command 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.
Examples—SHOW PREPARED
•
The following command displays a prepared command named SELALLCU:
>> SHOW PREPARED SELALLCU;
select * from sales.customer
>>
SHOW PREPARED { command-name [, command-name ] ... } ;
{ * }