DB2-1054-00-E UNION select list incompatible

The select lists of each query in a UNION are not the same length.
Restriction: This topic applies only when the AppMaster Builder AddPack has been installed, and applies only to Windows platforms.

Resolution:

Each query should return the same number of columns, with a corresponding sequence of column length and type. See UNION syntax, examples and other coding guidelines.