Hi,
is there a way (by executing a SQL statement) to find out which FKs defined
against a given table are enforced and which are not?
SYSCAT, SYSPROC, SYSIBMADM... something?
I cannot find it :-(
(DB2 V9.7.2 LUW)

Greetings,
Damir

On 2010-09-22 19:11, Damir wrote:
A trick is to make an educated guess on what the column might be named:

[lelle@c-83-219-209-129 ~]$ db2 "select tabschema, tabname from
syscat.columns where colname = 'ENFORCED'"

TABSCHEMA TABNAME
---------------------------
SYSCAT TABCONST
SYSIBM SYSTABCONST

2 record(s) selected.

You are probably looking for syscat.tabconst


One thing that strikes me as odd from time to time is that the remarks
column is null for the catalog table/columns. It would be nice to be
able to search for info via descriptions of columns/tables.


/Lennart

"Damir" <damirwilder (AT) yahoo (DOT) com> wrote

You need to look in the DB2 System Catalog Views (which have a schema name
of SYSCAT). They are documented in the "SQL Reference Vol 1
Appendix D. System catalog views" manual.

I would look in the TABCONST view.