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.


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