Routines
Posted: Sun Sep 10, 2006 4:24 am
Hi,
I am using routines in my DataStage jobs. Last week the jobs ran successfully, which uses number of routines. After that I exported the jobs in .dsx format. However, when I started testing the same jobs today, jobs are not rejecting the invalid records. Finally, I found that some routines are not returning the correct values which are supposed to. If the data is invalid, routines should return 1, else 0. I compiled and tested the routines, still these are returning 0 instead of 1, for invalid data.
These routines use common variables. I am unable to figure out the issue, please advise.
Thanks in advance,
I am using routines in my DataStage jobs. Last week the jobs ran successfully, which uses number of routines. After that I exported the jobs in .dsx format. However, when I started testing the same jobs today, jobs are not rejecting the invalid records. Finally, I found that some routines are not returning the correct values which are supposed to. If the data is invalid, routines should return 1, else 0. I compiled and tested the routines, still these are returning 0 instead of 1, for invalid data.
These routines use common variables. I am unable to figure out the issue, please advise.
Thanks in advance,