DB2临时表：不存储或不存储信息

I'm an MSSQL guy, but I'm working on a DB2 query that needs to create a temp table, insert into it, and do stuff with it. As a much-shortened test, I'm using the following query, which is providing the same result.. I'm an MSSQL guy, but I'm working on a DB2 quer