FIND & REPLACE

karthi_gana · Post by **karthi_gana** » Wed Nov 17, 2010 9:17 am

All,

I have used #off_funds.SourceDSN# in more than 150 jobs. Now i would like to replace it as #SourceDSN#. I am doing it manually now

is there any way to do it ?

i am looking kind of 'FIND & REPLACE'.

vinothkumar · Post by **vinothkumar** » Wed Nov 17, 2010 9:24 am

Import those jobs as dsx format and then do find replace in that dsx file through notepad or textpad.

vinothkumar · Post by **vinothkumar** » Wed Nov 17, 2010 9:28 am

Sorry its export..

chulett · Post by **chulett** » Wed Nov 17, 2010 11:16 am

... then import.

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Wed Nov 17, 2010 1:19 pm

Two notes:
1) BACKUP ALL YOUR JOBS before you do the export / import? Why? Because
2) Manual editing of DSX files is not supported / recommended by IBM. It can be dangerous and can corrupt your jobs if you aren't careful.

If you have an unedited backup you can always re-load and try again.