In the Query Builder, when visualizing a query, all the calculated fields with NULL disappear. e.g.
Paste a SQL statement into the the Query tab of the Query Builder. Then click the 'Visualize the SQL statement in the Query Tab'
SELECT COL1,
COL2,
NULL AS COL3,
NULL AS COL4
FROM tablename
Only shows COL1 and COL2 in the diagram
WORKAROUND
Cast the column i.e.
CAST (NULL AS INTEGER) AS COL3,
CAST (NULL AS VARCHAR(10)) AS COL4
STATUS
Waiting for fix in a future release of Toad for DB2