XQuery Global Variables

SQL does not have a construct equivalent to XQuery's global variables. When an XQuery global variable is set to values from the database, DataDirect XQuery generally inlines the variable in the statement created for the query body.

declare variable $users := collection('USERS')/USERS;
for $u in $users
return $u/LASTNAME

SELECT ALL
nrm5."LASTNAME" AS RACOL1
FROM
"PEPPINO"."USERS" nrm5
WHERE
nrm5."LASTNAME" IS NOT NULL