Its fine, & for describe statement you can use,

db2 "describe table <tablename>"



----- Original Message -----
From: "edwinuy" <db2udbdba-ezmlmshield-x75823233.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, September 29, 2004 7:53 PM
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
>
>
> ---NOTICE---
> This E-mail, including the attachment/(s) if any, has been scanned for
viruses and dangerous content before delivering to
> your Mailbox. For any problem please contact Technical Support Cell -
Mumbai. [Email address protected]
>



Top Headlines from www.timesofindia.com and www.economictimes.com
Wanted: A diva for Bollywood
http://timesofindia.indiatimes.com/articleshow/868210.cms
When romance becomes sexual harassment
http://economictimes.indiatimes.com/articleshow/868173.cms


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