Problem in passing number as parameter
Posted: Tue May 08, 2007 12:49 pm
Hello All,
I am trying to pass a number (Ex: 6000) as job parameter and use that parameter in the stage variable. But the job parameter is acting weired. Below are the complete details.
I added a job parameter with name AmtDiff with value as 6001. My logic int he stage variable is
StageVariable : svDiffAmt
My constraint is svDiffAmt = 1
In the result I am getting the negative values as well. When I used the function like > Num(AmtDiff) I am not getting the negative values but there are some positive values in the file that are less than the parameter value (6000).
Any help would be appreciated.
I am trying to pass a number (Ex: 6000) as job parameter and use that parameter in the stage variable. But the job parameter is acting weired. Below are the complete details.
I added a job parameter with name AmtDiff with value as 6001. My logic int he stage variable is
StageVariable : svDiffAmt
Code: Select all
If lkp.NOTFOUND then 1 else if ((lnlink.AMOUNT- lkp.AMOUNT) <> 0 and (lnlink.AMOUNT- lkp.AMOUNT) > AmtDiff ) then 1 else 0
In the result I am getting the negative values as well. When I used the function like > Num(AmtDiff) I am not getting the negative values but there are some positive values in the file that are less than the parameter value (6000).
Any help would be appreciated.