View Column Names

View Column Names

 

  





1) Is there a way using system tables to look for view column names with
certain attributes? (Ex: any view column name beginning with I_ )

2) If I know a Table Name and View Name is there a way using system tables
to list all the column names in the table by position and then in another
column list the matching View column name?


DB2 & UDB email list listserv db2-l LazyDBA home page