SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

MXCI Commands
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
4-65
Examples of SET PARAM
•
The PROJECT table has a SHIP_TIMESTAMP column. This UPDATE statement
uses the character literal in the ?SHIP parameter to set the value:
SET PARAM ?SHIP '1998-04-03 21:05:36.143';
UPDATE persnl.project
SET ship_timestamp = CAST (?SHIP AS TIMESTAMP(3));
•
The PROJECT table has an EST_COMPLETE column. This UPDATE statement
uses the character literal in the ?EST parameter to set the value:
SET PARAM ?EST 60;
UPDATE persnl.project
SET est_complete = CAST (?EST AS INTERVAL DAY);