SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-38
Examples—SET PARAM
Before executing the INSORD OBEY command file, you change the value of the
order number parameter and set values for the other parameters of the INSERT
command:
>> SET PARAM ?ONUM 600480, ?TODAY CURRENT_TIMESTAMP,
+> ?DDATE COMPUTE_TIMESTAMP (7/5/1988), ?REP 221;
>> OBEY INSORD;
These values are inserted in ORDERS:
After setting a different order number and customer number, you execute the
OBEY command file again:
>> SET PARAM ?ONUM 600481, ?CUSTNUM 123;
>> OBEY INSORD;
These values are inserted into ORDERS:
When you exit SQLCI, the values of ?ONUM and ?CUSTNUM are 400410 and
7654, respectively, as set initially by the PARAM command.
ORDERNUM 600480
ORDER_DATE (timestamp for current date and time)
DELIV_DATE (timestamp for 7/5/88)
SALESREP 221
CUSTNUM 7654
ORDERNUM 600481
ORDER_DATE (timestamp for current date and time)
DELIV_DATE (timestamp for 7/5/88)
SALESREP 221
CUSTNUM 123