I need to store the data from a view into a table.

I am using this syntax to create the table and select the data from the view.

Create table sch.t1 as (select * from sch.v1).

This works in oracle but not in DB2.

Can somebody help ?


thanks

That would be a two-step process with DB2:
You can find more details here:
http://publib.boulder.ibm.com/infoce...n/r0000927.htm

thanks so much.

You can also use the EXPORT and IMPORT commands. If you use IXF data format and use the REPLACE_CREATE option with the IMPORT, the table will be created if it does not already exist and the primary keys and indexes will be recreated the same as the source table (unlike CREATE TABLE LIKE ...). The only thing not created are the foreign keys (which is obvious since the other tables may not exist).

If you are IMPORTing a file with a lot of rows, be sure to use the COMMITCOUNT option (1000 is fine) to do intermediate commits to avoid filling up the log.

db2 "create table xa1 as (select * from employee) definition only in DMS_16K_TS1 partitioning key...." SO on....

This above command is more flexible to create a COPY of a table.

-Raj