We are implementing an Ab Initio based metadata solution for our DW.
However we are hitting a minor issue with fields that have been explicitly titled differently to the the underlying table
These titles are not held in DBC.columns, nor in DBC.TVfields. When one does an explain on the HELP COLUMN table.* it goes straight to the underlying table which would lead use to assume the PE is fetching it straight from that underlying table. However when a derived column is used in a view where on earth is the title of this column being stored, if not in DBC.columns or DBC.TVfields. We definately do not want to parse DBC.Tables for the requesttext, but it seems we will be forced to.
it's not stored in any easily accessible way, just in dbc.tvm's RequestText or CreateText.
It's parsing time :-(