I am running DB2 v.8 on AIX
1. What sql can I write to query the system tables to return an alphabetic listing of column names within a table ?
example:
select * from system_table where col_name like 'TRAN%' and
table_name like 'TRAN_TAB%'


2. In an ER diagram..the crows feet touching a table indicate that table holds the primary or foreign key???

1. SELECT * FROM SYSCAT.COLUMNS WHERE COLNAME ... AND TABNAME ...

2. I think in some notations the "crow foot" thing shows the "...-to-many" part of the relationship. It might be represented by a foreign key, yes.