What is the restriction on using UNION in embedded SQL ?
It has to be in a CURSOR
cannot be used in Embedded SQL
No restrictions
None of the above