"Teknik & System" <te****@0725.dk> wrote in message
news:3f***********************@dread16.news.tele.d k...
Hi,
I need to search all tables and all records in a large database (v. 7.2)
for at text string.
Are there any _easy_ ways of doing this?
How easy do you want?
SELECT 'SELECT * FROM ' || TABSCHEMA || '.' || TABNAME
|| ' WHERE ' || COLNAME || ' LIKE ''%your_search_value%'';'
FROM SYSCAT.VIEWS
WHERE TYPENAME IN ('CHAR','VARCHAR','CLOB','LONG VARCHAR','CHARACTER')
Regards
Paul Vernon
Business Intelligence, IBM Global Services