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

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-417
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.