Hi All,
I need to create a new table from already existing table. I tried the following syntax, but it doesn't work.

create table new_table as select * from old_table;
create table new_table like old_table;

Thanks
Sarwan

Informix do not have this syntax...
you must execute a dbschema -d <database> -t <table> <-ss>
and alter the table name...

I am not a regular Informix user, but I think the following should work:

the correct syntax is :
select * from old_table into TEMP new_table

and this way you will create just a temporary table...
unfortunately must use the dbschema to do this job...