Toad World® Forums

Is there a catalog table that holds th relationship of a view column name to a table column name

For a given column in a view I want to know where in the catalog I can find its table column name. I.e when you do a CREATE VIEW when does DB2 hold the column relationship details This is on DB2 z/OS

SYSIBM.SYSVIEWS might be what you are looking for.

Thanks very much. That’s exactly what I needed.