I want to convert Null to Not Null of a column with data Type as Date. I am using Reprt_Date : string = NullToValue (Reprt_Date,"Null") in the Specification of Modify stage. But I am getting error as
"main_program: Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue
Expected destination field selector, got: ")"; input:
Reprt_Date : string = NullToValue (Reprt_Date,"Null")
;
Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue
Expected destination field selector, got: ")"; input:
Reprt_Date : string = NullToValue (Reprt_Date,"Null")
;"
Thanks In advance
Converting Null into Not Null Using Modify Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 48
- Joined: Mon Oct 08, 2007 7:12 pm
- Location: Sydney
Converting Null into Not Null Using Modify Stage
Regards
Naveen Kandukuri
Naveen Kandukuri
-
- Participant
- Posts: 48
- Joined: Mon Oct 08, 2007 7:12 pm
- Location: Sydney
The data type is Date
when i am giving the above said Condition for Datatype Date, the error I am getting is
Modify_112: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "Reprt_Date" to field "Reprt_Date": Bad literal for type date: Null.
Thanks in Advance
Modify_112: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "Reprt_Date" to field "Reprt_Date": Bad literal for type date: Null.
Thanks in Advance
Regards
Naveen Kandukuri
Naveen Kandukuri
"Null" is not a valid date value.
Your business rules has to decide what should be the default date when the input date is null. E.g 1500-01-01.
Your specification should be:
Your business rules has to decide what should be the default date when the input date is null. E.g 1500-01-01.
What is Reprt_Date datatype when output? The above answer is applicable only if it is date.
Reprt_Date : string = NullToValue (Reprt_Date,"Null")
Your specification should be:
Code: Select all
Reprt_Date :date = handle_null(Reprt_Date,"1500-01-01")