Create a table with a subset of data

CREATE TABLE mylib.cust_new AS (                          
   SELECT * from prodlib.customer                         
   WHERE dob < 19741231 
 ) WITH DATA

Remove/delete a table using SQL DROP statement

DROP  TABLE mylib.cust_new