Staging Variable Length (Resolved)
Posted: Tue Aug 26, 2003 2:32 pm
What is the default length for a staging variable in a Server Job on DataStage6
I have to pick up the unique values from my source flat file I am using a combination of Sort and RowProcCompareWithPreviousValue()
The Data is
380440802865249131
380440802865249149
380440802865249149
and when I pass this data through RowProcCompareWithPreviousValue() what I get is
0
1
1
Where as looking at the data I would expect the output to be
0
0
1
Thanks in advance.
_________________________________________________________________
Resolution
It was not a staging variable issue but an issue with using the RowProcCompareWithPreviousValue() which I assume only works with the first 14 chars (is it bcoz of the COMMON variable ???), but thanks to the guru's in the forum using the Compare function I was able to resolve my issue.
Thanks a lot Ray & VMC
I have to pick up the unique values from my source flat file I am using a combination of Sort and RowProcCompareWithPreviousValue()
The Data is
380440802865249131
380440802865249149
380440802865249149
and when I pass this data through RowProcCompareWithPreviousValue() what I get is
0
1
1
Where as looking at the data I would expect the output to be
0
0
1
Thanks in advance.
_________________________________________________________________
Resolution
It was not a staging variable issue but an issue with using the RowProcCompareWithPreviousValue() which I assume only works with the first 14 chars (is it bcoz of the COMMON variable ???), but thanks to the guru's in the forum using the Compare function I was able to resolve my issue.
Thanks a lot Ray & VMC