SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-49
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);