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,
Routines
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Routines
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!
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!
pavan
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.
What is the condition based on which you are trying to reject the rows.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'