Is their a direct equivalent in DB2 to create a table with a select ?

in Oracle it goes somethng like this:

create table newtable as Select * from mytable;

This was discussed recently. I don't recall all the options, but you can do it with these 2 SQL statements using begin atomic (if needed):

Create table new_table like old_table;
Insert into new_table select * from old table ... ;

Thanks ! Learning DB2...

Following should also work

db2 "create <NEWTABLE> as (select * from <EXISTINGTABLE) definition only "

db2 "create <NEWTABLE> as (select * from <EXISTINGTABLE) WITH NO DATA"