I meant to say, is there something which I am not aware of,
Like arg1 & arg2 are both Decimal datatype (in sequential file), anything of that sort causing this problem. (changed them to numeric, bigint, still same result)
======================================
I am getting crazy, feels like there is nothing to debug.
Code: Select all
if svNullIdst Then 112 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1222576)) Then 101 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221747)) Then 102 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221748)) Then 103 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221751)) Then 104 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221750)) Then 105 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221761)) Then 106 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221756)) Then 107 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221755)) Then 108 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221753)) Then 109 Else
if (NullChecking(in.VCS_GRP_ID) And (TRIMLT(in.VCS_DIV_ID)=1221771)) Then 110 Else
TRIMLT(in.VCS_GRP_ID)
The value of
in.VCS_DIV_ID is 1221748
and in.VCS_GRP_ID is either Null or ''
I get the result of this statment as 101 instead of 103..