| re: Searching for strings and replacing them
Harlin wrote:
[color=blue]
> I have 2 databases I need to search through. I am looking for say...
> "bad.string" and want to replace it with "good.string". I do not know
> where in which table or even field the "bad.string" will show up in.
> What commands could I use to get this done?[/color]
You will have to query all string columns in all tables and execute
respective update statements.
--
Knut Stolze
DB2 Information Integration Development
IBM Germany
| 
