Using same table in a UNION multiple times
Use
Select X.Column1, X.Column2, Sum(X.Column3) AS Test, Types.&quot;Type&quot;
From Table X
CROSS JOIN ( SELECT &quot;First Query&quot; AS &quot;Type&quot;
             UNION ALL
             SELECT &quot;Second Query&quot;
             UNION ALL
             SELECT &quot;Third Query&quot; ) AS Types
Where X.Column1 = &quot;Fly&quot;
Group by X.Column1, X.Column2, Types.&quot;Type&quot;


Maybe SELECTs in Types needs additional FROM DUAL or similar, or DB2 uses some another method for to select scalar value - test.
UPDATE (copied from the comment)

You can shorten the CROSS JOIN part with:
CROSS JOIN ( values ('First Query'),('Second Query'),('Third Query')) types (type)

FWIW, Db2 also allows
CROSS JOIN ( values 'First Query','Second Query','Third Query') types (type)

but that's non standard I beleive – Lennart