Hi all,
I'm a newby db2 dba, but a little expert from oracle..
I'm simply tring to create a new table from another pre-existing one using a statement like this:

create table tab_name
as select * from other_table

But db2 give me the classic syntax error sql0104n..

The questions are:

Can I create a table from an existing one with same structure and data like in oracle?

If so, what is the right syntax?

Thanks in advance
downtown

Please anybody can help me?

In DB2 you need to do it as a two step process. First create the table, then insert the data.

CREATE TABLE MyTable2 like MyTable1
INSERT INTO MyTable2 select * from MyTable1;

HTH

Andy

Thank you so much Andy