Different routine results

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Juls
Participant
Posts: 51
Joined: Tue Sep 14, 2004 9:17 am

Different routine results

Post by Juls »

Hi,

I wrote a routine that takes 3 arguments and outputs a number. When I "Test" the routine with a set of values then it returns the correct value. When I put the same routine in my transformer and pass the same arguments it returns the wrong value.

I am lost.. I checked and rechesked the values that are passed and they are the same in both cases.

Any ideas?

Thanks
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

Make sure you dont have any leading or trailing spaces in the arguments you are passing to your routine. Try trimming your input arguments, either while feeding them into the routine, or inside your routine. That might be the reason.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Juls
Participant
Posts: 51
Joined: Tue Sep 14, 2004 9:17 am

Post by Juls »

SO SIMPLE!!!!!! trim worked!!!!

But I could swear that there weren't any spaces!!!!

I guess you can never be too sure until you TRIM.

Thanks!!!
Post Reply