SQL/MX 2.x Reference Manual (G06.24+, H06.03+)
SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-255
Examples of VALUES
•
This VALUES statement displays the results of the expressions and the row 
subquery in the lists:
VALUES ('a','b',UPSHIFT('c')), 
 ((SELECT jobdesc FROM job WHERE jobcode=300),'d',NULL);
(EXPR) (EXPR) (EXPR) 
------------------ ------ ------ 
a b C 
SALESREP d ? 
--- 2 row(s) selected.










