Hi,
While I am trying to convert datatypes for few columns like Varchar to Decimal, Varchar to Date and Varchar to Timestamp which are not nullable on the target table, I am getting following warnings:
1) APT_CombinedOperatorController,2: Numeric string expected, got "". Use Decimal default value.
2) APT_CombinedOperatorController,2: Null string argument.
Please let me know best way to get over these warnings.
Thank You,
RSSV
Null Handling
Moderators: chulett, rschirm, roy
Re: Null Handling
check the null value using IsNull function and assign a default value if it returns 1srivvds wrote:Hi,
While I am trying to convert datatypes for few columns like Varchar to Decimal, Varchar to Date and Varchar to Timestamp which are not nullable on the target table, I am getting following warnings:
1) APT_CombinedOperatorController,2: Numeric string expected, got "". Use Decimal default value.
2) APT_CombinedOperatorController,2: Null string argument.
Please let me know best way to get over these warnings.
Thank You,
RSSV
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Looks like you are in a Transform stage, wrap a NullToValue around your string fields to turn them into zeros or reject them out of the transformer. If you were using a Modify you would do something like decimal_from_string(handle_null(stringfield, 0)).
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn