|
View previous topic :: View next topic
|
| Author |
Message |
vd123
New User
Joined: 30 Jul 2009
Posts: 7
Location: Pune
|
|
|
|
I wan to see all the specifications related to a DB2 table?
How can we achieve this using SPUFI?
Thanks |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10900
Location: italy
|
|
|
|
SPUFI is just a smart interface to run queries
is not a <data aware> thing
You can find the info You look for by running the appropriate queries on the DB2 catalog tables ( SYSIBM. stuff )
or ask Your peers if some DATABASE ADMINISTRATION TOOL is available in Your organization |
|
| Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006
Posts: 1356
Location: Israel
|
|
|
|
| Quote: |
| all the specifications related to a DB2 table |
are stored in many... DB2 tables!
Depending on the specification you want, you can access one of the many SYSIBM.SYSxxxx tables.
For example, the table columns can be found with:
| Code: |
SELECT
*
FROM
SYSIBM.SYSCOLUMNS
WHERE
TBNAME = 'tablename'
ORDER BY
COLNO |
|
|
| Back to top |
|
|
|
|
