No. You must create the table first. However, you can "cheat"! hehe.
Go into the Control Center (GUI) and highlight the applicable table,
then right click on the applicable table and click "Copy". This process
actually does an export and import for you.






Please take a few minutes to provide feedback on the quality of service you received from our staff. The Department of Education values your feedback as a customer. Commissioner of Education Dr. Eric J. Smith is committed to continuously assessing and improving the level and quality of services provided to you.Simply use the link below. Thank you in advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----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

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