View previous topic :: View next topic
|
Author |
Message |
ysuryawanshi_mcs Warnings : 1 New User
Joined: 25 Mar 2006 Posts: 15 Location: pune(India)
|
|
|
|
HI
COULD ANYBODY TELL ME HOW TO DESCRIBE THE TABLE
eg.IN ORACLE
DESC <TABLE NAME> DESCRIBES THE TABLE
MEANS IT SHOWS ALL ATTRIBUTES WITH THEIR DATATYPES AND CONSTRAINSTS. |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy ysuryawanshi_mcs,
there is not a similar command,
but you can query the sysibm.syscolumns table
then you will get the same result...
martin9 |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi,
use DRAW <tabname> in QMF . it will give you the same result as you asked.
Thanks
Rags |
|
Back to top |
|
|
lakhs
New User
Joined: 19 Jan 2006 Posts: 1
|
|
|
|
hi,
In QMF. write select * from <tabname> and press F9.. will give all the fields description.. |
|
Back to top |
|
|
martin9
Active User
Joined: 01 Mar 2006 Posts: 290 Location: Basel, Switzerland
|
|
|
|
hy ysuryawanshi_mcs,
go into the db2 administrator
and look at the table definition.
this you can find from ispf priamry option menu
with command g.d.2.a ok...
martin9 |
|
Back to top |
|
|
|