Searching for strings and replacing them

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harlin - 24 Apr 2006 13:00 GMT

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?

Thanks,

Harlin Seritt

Reply to this Message

Knut Stolze - 24 Apr 2006 13:06 GMT

> 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?

You will have to query all string columns in all tables and execute
respective update statements.

Signature

Knut Stolze
DB2 Information Integration Development
IBM Germany

Reply to this Message