create table as 
Author Message
 create table as
i try to use the same sql statement which works on db2 as400 v5r2, but
it doesn't work on db2 udb v8.1 (NT), can anyone tell me the
workaround?

CREATE TABLE daisy.ARP1  as  (SELECT * from hd1100pd/arpmcus  ) with
data

CREATE TABLE daisy.ARPM  as  (SELECT arno01,arnm01 from
hd1100pd/arpmcus ) with definition



Sun, 31 Jul 2005 00:10:54 GMT
 create table as

2 statements on DB2 UDB v8.1 on Windows:

    CREATE TABLE ADDRESS2 LIKE ADDRESS

    INSERT INTO ADDRESS2 SELECT * FROM ADDRESS

Quote:

> i try to use the same sql statement which works on db2 as400 v5r2, but
> it doesn't work on db2 udb v8.1 (NT), can anyone tell me the
> workaround?

> CREATE TABLE daisy.ARP1  as  (SELECT * from hd1100pd/arpmcus  ) with
> data

> CREATE TABLE daisy.ARPM  as  (SELECT arno01,arnm01 from
> hd1100pd/arpmcus ) with definition



Sun, 31 Jul 2005 02:16:14 GMT
 create table as
xixi wrote on Tuesday 11 February 2003 17:10:

Quote:
> i try to use the same sql statement which works on db2 as400 v5r2, but
> it doesn't work on db2 udb v8.1 (NT), can anyone tell me the
> workaround?

> CREATE TABLE daisy.ARP1  as  (SELECT * from hd1100pd/arpmcus  ) with
> data

> CREATE TABLE daisy.ARPM  as  (SELECT arno01,arnm01 from
> hd1100pd/arpmcus ) with definition

From the SQL Referenc:

CREATE TABLE abc AS ( SELECT ... FROM ) WITH NO DATA

CREATE TABLE abc AS ( SELECT ... FROM ) DATA INITIALLY DEFERRED REFRESH
IMMEDIATE

CREATE TABLE abc AS ( SELECT ... FROM ) DATA INITIALLY DEFERRED REFRESH
DEFERRED

And then you have the REFRESH TABLE statement to initially populate the
summary table with the data.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena



Sun, 31 Jul 2005 02:39:19 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Create table creates invisible table

2. How to execute a Create table or alter table table everytime before a data load

3. CREATE TABLE or Import results in new table being flagged as SYSTEM table

4. Creating Identity Colum when Creating table through Code in VB

5. When creating table how do you create an variable array

6. creating a cursor using a dynamically created table name

7. drop default constraint created at creating table time**

8. Vanishing Create Table when creating new SP

9. Strange phenomena with CREATE DATABASE / CREATE TABLE

10. creating SP from create table script

11. create table or create trigger error

12. Creating a job in a trigger causes intermittent Can not CREATE TABLE error


 
Powered by phpBB® Forum Software