**************************************************************************

Note: This e-mail is subject to the disclaimer contained at the bottom
of this message.

**************************************************************************
:

Joe,

Try:
CREATE TABLE schema.name LIKE schema.name;

David Chapman,
IBM Certified DBA for DB2 UDB on OS/390, Linux, Unix and Windows.



|---------+--------------------------------------------------------->
| | Joe Philip |
| | <db2udbdba-ezmlmshield-x53898925.[Email Address Removed] | azyDBA.com> |
| | |
| | 16/06/2004 13:53 |
| | |
|---------+--------------------------------------------------------->
>----------------------------------------------------------------------------------------------|
| |
| To: LazyDBA Discussion <[Email address protected] |
| cc: |
| Subject: easiest way to create a backup a table in Db2 UDB |
>----------------------------------------------------------------------------------------------|



What is the easy way to create a copy of a table? In oracle, I used to do
this:
create table tab_copy as (select * from tab1);

I could not get it working for DB2 to create an exact copy of the table. Is
there a better way to do this?



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: db2udbdba-[Email address protected]






:
********************************************************************************

The information transmitted in this message and attachments (if any)
is intended only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon this information, by persons or entities
other than the intended recipient is prohibited.

If you have received this in error, please contact the sender and delete this
e-mail and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or
distribute the information contained in this e-mail and any attached files,
with the permission of the sender.

This message has been scanned for viruses and cleared by MailMarshal.

********************************************************************
:

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