SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
R-15
Examples—RESET PARAM
parameter has no value after the EXECUTE command terminates because the
value is assigned only temporarily.
4> PARAM SAL 140000
5> PARAM
DEVICE^TYPE .2.
SAL .140000.
6> SQLCI
SQL Conversational Interface - T9191D20 - (01JUN93)
COPYRIGHT TANDEM COMPUTERS INCORPORATED 1987-1994
>> SHOW PARAM *;
?DEVICE^TYPE 2
?SAL 140000
>> SET PARAM ?ENUM 557;
...
>> SET PARAM ?STATE "CALIFORNIA", ?SAL 45000;
>> SHOW PARAM *;
?ENUM 557
?STATE CALIFORNIA
?SAL 45000
>> EXECUTE FINDSUP USING ?ENUM = 45;
...
>> SHOW PARAM *;
?ENUM 557
?STATE CALIFORNIA
?SAL 45000
>> RESET PARAM *;
>> SHOW PARAM *;
>>EXIT
End of SQLCI Session
7> PARAM
SAL .140000.