No one has followed this question yet.
You executed this command to create a temporary table: (inside) What is true about the rows inserted into the REPORT_WORK_AREA table during a transaction after commit?
command for storing result from a query to a temporary table in db2
How do I create a row for each hour between a time range
how to get results in ascending order when creating table
Query times using table variables, vs temp tables, when using MS CLR vs SMSS