hello

i need sql statements that find foreign key constrints for a table and the key fields of the two tables - the fileds that has unique constraint or primary key and the fields ot the other table which has defined foreign key constraint ...

table 1 table2
primary key, unique fields <---------------------------------------------- foreign key fields

i need the name of the key filed which are involved in the foreign key constrain

please help

Have a look at

sysibm.SQLFOREIGNKEYS
or
syscat.tabconst and syscat.keycoluse

you might want to download "SQL Reference Vol.1.pdf"