Im using netezza connector. I try to sum a numeric NUMERIC column using below select statement. However, I always get "did not have a compatible data type. These columns will be dropped from the output link schema" message.
select Sum(col) as ssum from table
May I know what DS datatype I should use? I had tried all of them (may be I missed out).
Thanks in advance
Netezza - What is datatype for select Sum(col) from table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A Numeric data type with sufficiently large precision should be adequate.
Try dfloat (Double), since this is the largest possible numeric data type, and all numeric data types can be implicitly converted to it. Also try reducing the severity of metadata mismatch reports in any Connector stage that you are using.
Try dfloat (Double), since this is the largest possible numeric data type, and all numeric data types can be implicitly converted to it. Also try reducing the severity of metadata mismatch reports in any Connector stage that you are using.
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.