PowerBuilder will not validate the syntax after the UNION keyword, while PowerServer will. If the syntax after UNION is invalid, PowerServer will fail to convert the DataWindow to a model.
For example, if a space is missing between "SELECT" and ":as_test",
SELECT :as_test test1, Dept.ID, Dept.Name FROM Dept
union
SELECT:as_test test1, Dept.ID, Dept.Name FROM Dept
The PowerServer project deployment process will report the
following error: Incorrect syntax near ':'.
