Routines

[Latha1919]

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,

[kduke]

Post the routine code.

[ray.wurlod]

Did you export the routines as well? Or are you using old versions of the routines in the newer environment?

[pavanns]

Hi
I had similar problems when i imported routines from a diff prj. all i did was to knock off the .dsx file and reimport routines compile them and then try it out. for safe side please make sure that all the protocols of the code are followed!

[kumar_s]

Just export doenst make any differenct in the working Job/Routine. There should be some other environmental change, which might be the reason for the routine to validate ok for those records, which you think, should be rejected.
What is the condition based on which you are trying to reject the rows.