Resources

SQL to show number of levels of RI in a database schema

Topic: Code Place

Subtopic: DB2 for z/OS



This SQL counts the number of levels of referential integrity (parent, child, grandchild, etc.) that exist in a database schema (up to 100 levels)



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.