I want to make a copy of an existing table using IDS 9. This is how I would do it in Oracle. I would create a new table and select all data from the original table into my newly created table.

CREATE TABLE new_table AS SELECT * FROM old_table

Any ideas how I can do the same with IDS 9?

1. create table table_new
2. insert into table_new select * from table_old