RE: Which table column does a view column map to?

Rob,

It looks like your final select statement (qsys2.sysviews) gives me the
statement that created the view.

I'm really looking for a map of view.column = table.column. If I have to
parse the statement I'd be better off just hardcoding the relationship in
the trigger program.

To use the fields from your example I'm looking for something like this:

view, column, table, column
-----------------------------------------
dmv1, mycol1, dm1, mycol1
dmv1, mycol2, dm2, mycol2