DSXchange

If there is a rotine 'X1' in a job & should be replaced by another routine 'Y1' using a routine can it be written in datastage or do we need a unix script for that.

There is no built method to do this. Can you just replace the code of X1 with Y1 and recompile the new contents of the routine?

ArndW wrote:There is no built method to do this. Can you just replace the code of X1 with Y1 and recompile the new contents of the routine?

ur suggestion siuts for one job if there are n no of jobs using the routine then wat is the solution

The first part of the solution is to write in English.

A similar manual solution exists for any N, where there are N jobs using the routine. You can determine which these are by performing a Usage Analysis on the Routine. For a sufficiently small N the amount of work is less than trying to script an "automatic" method.

Same solution - ArndW suggested is what exactly you have to do if you have N number of jobs. If some other jobs are still referring to Y1, then you might have to take care of that scenario. Check if the number of parameters passing are the same (Type & Count). In that case you can try taking an export and replace all X1 with Y1 in your .dsx and import those jobs back.

anees1 wrote:

ArndW wrote:There is no built method to do this. Can you just replace the code of X1 with Y1 and recompile the new contents of the routine?

ur suggestion siuts for one job if there are n no of jobs using the routine then wat is the solution

anees1 wrote:ur suggestion siuts for one job if there are n no of jobs using the routine then wat is the solution

If n jobs use this routine then by replacing the code and recompiling all n jobs will immediately use the new code.

The other routine would be to do a full export of all jobs, then manually edit the .dsx file and replace X1 with Y1 {assuming the number of parameters is the same}