Create table with data from subquery

[new2db2]

Hey everyone,
How can I create a table with a subquery that contains the structre of the query and the data? In other DBMS systems, like Teradata, I would use something like "with data" in place of "definition only". Is this possible in DB2? Thanks in advance.

The below code only creates an empty table, which is expected with the definition only parameter. I am having no success finding the include data patameter.

create table test as (select * from other table) definition only;

 

[gregsimpson]

new2db2,

I haven't managed to get it working in DB2. Used it in other DBMS's no problem. I ended up doing the following

drop table asn.copy_captrace;
create table asn.copy_captrace like asn.ibmsnap_captrace;
insert into asn.copy_captrace select * from asn.ibmsnap_captrace;

Cheers
Greg

 

[new2db2]

Yeah, that was my solution as well. Thanks.