EDWIN,

in db2 create table like , will create empty table / strarcture , 2nd
statement will load data
create table EMPLOYEE1 like EMPLOYEE;
insert into EMPLOYEE1 select * from EMPLOYEE;

try as above , let me know , if any questions


Thank You


Lekharaju Ennam


-----Original Message-----
From: edwinuy
[mailto:db2udbdba-ezmlmshield-x75823233.[Email address protected]
Sent: Wednesday, September 29, 2004 10:23 AM
To: LazyDBA Discussion
Subject: CREATE TABLE AS HOW TO


Hi gurus,

Am a newbie playing around with DB2, can you guys tell me what's wrong with
this:

CREATE TABLE EMPLOYEE1 AS
( SELECT * FROM EMPLOYEE ) ;

Also, what is the equivalent of Oracle's DESCRIBE and SQLServer's sp_help in
DB2, one that I can use to 'describe' the definition of my table's
columns/fields?

Cheers,

EDWIN ONG UY
UNIT 4,64 GRANGE ROAD
MT EDEN 1003
AUCKLAND, NEW ZEALAND
Email: [Email address protected]
Mobile: 64-021-622092

-------------------------------------
This email is intended solely for the named recipient/s and as such is
confidential and may contain information that is privileged. If you have
received it by mistake, please notify the sender. You must not use, copy,
distribute or disclose its contents to anyone other than the addressee. This
email and any attachments might not be free from computer viruses or other
defects.



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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