Find/Replace tool to change suite of queries

[kq]

Our DBAs have made a change in logic to one of the dimension which, when used through BO is not an issue; however, many of our queries are in freehand sql and we're having to manually update each one (approx 100).

Is there an automated tool of any kind that could do a find/replace function?

 

[tdatgod]

Hi,
What kind of Verbage are you talking about?

Single Words,
Multiple words on the same line
Multiple Words across multiple lines?

Can you give us an example of what you need to change?

You can probably write a PERL script to do the modification of this sort. I have done that before.

----

 

[kq]

Here's the original language:
sum(CASE WHEN ((D.covg_typ_cntg_ind = 'Y' and C.sub_mth_cnt in ('-1','1') ))
THEN C.sub_mth_cnt ELSE 0 end) AS CNT

Here's the change:
sum(CASE WHEN ((D.covg_typ_cntg_ind='Y' and C.sub_mth_cnt in ('-1','1') [RED]and D.prod_var_age_cd ='1'[/RED] )) THEN C.sub_mth_cnt ELSE 0 end)

This is the logic behind a measure we use CONSTANTLY -- but many of our queries are in freehand sql -- a long, sad story.

 

[Lysen]

http://www.divlocsoft.com/index.htm

could this tool be of some help to you?

Eli

 

[bridgeconsultant]

Hello. I have been using a wonderful tool called wingrep to do advanced searches (and replace). It's available at wingrep.com You can use regular expressions to perform your search. A wonderful tool!

 

[kq]

Thank you both Bridgeconsultant and Lysen for your assistance. Now the job will be to get something past "Dr NO" as we call our IT guys!