search

angoca / db2tools

Set of routines that can ease your daily work.
GNU General Public License v2.0
1 stars 0 forks source link

Find a table-column by its ID #3

Open angoca opened 10 years ago

angoca commented 10 years ago

Include my function here

angoca commented 10 years ago

db2 "select varchar(trim(c.tabschema) || '.' || trim(c.tabname) || '.' || trim(colname), 128) as \"ts.table.col\" from syscat.tables t join syscat.columns c on (c.tabschema = t.tabschema and c.tabname = t.tabname) where t.tbspaceid = 3 and t.tableid = 1563 "