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.