исходя из предложенного решения в книге стр 342, 347 DB2 9 Cookbook Graeme Birchall
можно создать
#DELIMITER "@";

CREATE PROCEDURE "RETURN_VARCHAR"
(IN "IN_STMT" VARCHAR(4000),
OUT "OUT_VAL" VARCHAR(4000)
)
LANGUAGE SQL
NOT DETERMINISTIC
CALLED ON NULL INPUT
NO EXTERNAL ACTION
OLD SAVEPOINT LEVEL
READS SQL DATA
INHERIT SPECIAL REGISTERS
BEGIN
DECLARE c1 CURSOR FOR s1;
PREPARE s1 FROM in_stmt;
OPEN c1;
FETCH c1 INTO out_val;
CLOSE c1;
RETURN;
END@


CREATE FUNCTION "RETURN_VARCHAR"
("IN_STMT" VARCHAR(4000)
)
RETURNS VARCHAR(4000)
LANGUAGE SQL
NOT DETERMINISTIC
READS SQL DATA
STATIC DISPATCH
CALLED ON NULL INPUT
NO EXTERNAL ACTION
INHERIT SPECIAL REGISTERS
BEGIN ATOMIC
DECLARE out_val VARCHAR(4000);
CALL return_VARCHAR (in_stmt,out_val);
RETURN out_val;
END@

#DELIMITER RESTORE@

а затем выполнить select, где по всей БД выбираются таблицы с
колонкой FLATADDR, длиной 120, содержащей контекст %ИЗОБРЕТАТЕЛЕЙ%

SELECT CHAR(tab.tabname,15) AS tabname
,CHAR(tab.tabschema,15) AS tabschema
,CHAR(col.colname,10) AS colname
,CHAR(COALESCE(return_VARCHAR(
' SELECT '||col.colname ||
' FROM ' || tab.tabschema || '.' || tab.tabname ||
' WHERE ' || col.colname || ' LIKE ''%%ИЗОБРЕТАТЕЛЕЙ%%''' ||
' WITH UR'
),'N'),120) AS has_dept
FROM syscat.columns col
,syscat.tables tab
WHERE col.colname IN ('FLATADDR')
AND col.tabschema = tab.tabschema
AND col.tabname = tab.tabname
AND col.length = 120
AND tab.type = 'T'
FOR FETCH ONLY
WITH UR;