Again if you ever need to work on DB2, here is a shorthand syntax to create a physical table based on the SQL query you’ve already built.
create table myschema.tblMyTableName as ( myQuery ) definition only in myTableSpace
Tags: SQL CHALLENGE,