Damanindahaus
New Member
hi mates,
i need some help navigating through the system catalog. i want to search all columns in my system with a special content. something like this:
select col, tbl, coltype, nullflag, width from sysprogress.SYSCOLUMNS
where coltype = 'integer' and owner = 'pub'
and col -- now comes psydo code
is (select col from tbl where col like '%content%')
order by tbl, id
can you help me plz? :blush:
regards
Daman
i need some help navigating through the system catalog. i want to search all columns in my system with a special content. something like this:
select col, tbl, coltype, nullflag, width from sysprogress.SYSCOLUMNS
where coltype = 'integer' and owner = 'pub'
and col -- now comes psydo code
is (select col from tbl where col like '%content%')
order by tbl, id
can you help me plz? :blush:
regards
Daman