Are you trying to query the SYSIBM.SYSCOLUMNS table to see certain columns start with some thing like "SELECT * FROM SYSIBM.SYSCOLUMNS WHERE COLUMN_NAME LIKE 'I_%'". You can also join with Sysibm.Systables to get table name and column name.....

-----Original Message-----
From: gerryray
[mailto:db2udbdba-ezmlmshield-x31751926.[Email address protected]
Sent: Friday, March 24, 2006 9:01 AM
To: LazyDBA Discussion
Subject: 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?



---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


CONFIDENTIALITY NOTICE: The Ohio Public Employees Retirement System intends this e-mail message, and any attachments, to be used only by the person(s) or entity to which it is addressed. This message may contain confidential and/or legally privileged information. If the reader is not the intended recipient of this message or an employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that you are prohibited from printing, copying, storing, disseminating or distributing this communication. If you received this communication in error, please delete it from your computer and notify the sender by reply e-mail.


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