View columns explicitly titled - where are the titles stored?

Database

View columns explicitly titled - where are the titles stored?

Hi all

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.

Many thanks

Simon

1 REPLY
Junior Contributor

Re: View columns explicitly titled - where are the titles stored?

Hi Simon,

it's not stored in any easily accessible way, just in dbc.tvm's RequestText or CreateText.

It's parsing time :-(

Dieter