SQL/MX 2.x Reference Manual (H06.04+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
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);