Hi Every one ,
1. I used some stages to develop the job. I am having a problem with the aggregator stage as when i perform the function 'Sum' in aggregator stage,
I am getting an error saying that invalid argument type. When I use with any other functions in aggregator stage, it is working.
The process of the job is as follows: I am grouping two fields and I have to sum based on the grouping fields. I know this is not a typical job but I am not sure why i am getting an error only with the Sum function in aggregator stage. I also checked with different Data types like Varchar, Integer, Long Varchar but still not working. Can any one suggest me what is the solution for this error?
Thanks in advance
aggregator problem
Moderators: chulett, rschirm, roy
aggregator problem
Last edited by rsunny on Mon Sep 20, 2010 10:17 am, edited 1 time in total.
rsunny,
1) Don't hijack a thread (even your own) with a completely different problem. Post both separately. In this case I'd suggest cutting the second problem out and posting it as it's own issue.
2) If you want an specific answer to your question you need to post details! You need to cut and paste exact error messages and showing the exact code you are using.
In the first problem I suspect your problem is you should either be using DFLOAT as a variable type or using a decimal override on the output and then selecting decimal as your variable type. However, that's a guess because you didn't post any specifics on input variables and output variable types.
In the second problem we need to see the code you are using - please post it in a separate post.
1) Don't hijack a thread (even your own) with a completely different problem. Post both separately. In this case I'd suggest cutting the second problem out and posting it as it's own issue.
2) If you want an specific answer to your question you need to post details! You need to cut and paste exact error messages and showing the exact code you are using.
In the first problem I suspect your problem is you should either be using DFLOAT as a variable type or using a decimal override on the output and then selecting decimal as your variable type. However, that's a guess because you didn't post any specifics on input variables and output variable types.
In the second problem we need to see the code you are using - please post it in a separate post.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Are you saying that you're trying to sum a VarChar data type?
Please post the exact properties you've used in the Aggregator stage, as well as whether your data are sorted (and, if so, on what fields).
Please post the exact properties you've used in the Aggregator stage, as well as whether your data are sorted (and, if so, on what fields).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: