Anything to wean fellow professionals off Oracle! :-)

1. Look at the syntax of the CREATE TABLE statement for Materialised Query
Tables, Automatic Summary Tables etc.
2. Ditto, DECLARE GLOBAL TEMPORARY TABLE
3. The IMPORT utility with the CREATE or REPLACE_CREATE options

Regards
Alex Levy
Sustainable Software Ltd

-----Original Message-----
From: Das Ashim K
[mailto:db2udbdba-ezmlmshield-x92881399.[Email address protected]
Sent: Friday, February 22, 2008 10:27 AM
To: LazyDBA Discussion
Subject: create table AS


Hi,
Is there a create table command in DB2 similar to Oracle where one can
create a table and populate the data in one step?

Eg. Create Table emp_bk as select * from emp.

Thanks,
Ashim.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page