Page 1 of 1
converting the null
Posted: Tue Feb 05, 2008 10:36 pm
by uppalapati2003
Hi,
how to convert null values into some default value in modify stage
right now i am using like this
the data type of the column is DATE
column name is BEG_DATE
BEG_DATE = handle_null(BEG_DATE,'1800-01-01') i am giving like this
it showing some error
"""" main_program: Error parsing modify adapter: Error in binding: Expected ')', got: "-01"
Expected destination field selector, got: ")"; input: """""
Re: converting the null
Posted: Tue Feb 05, 2008 11:42 pm
by gnreddy
Hi,
U can do this like the following.
BEG_DATE:DATE=NullToValue(BEG_DATE,'1800-01-01')
i think it works fine.
regards
narayan reddy.g
Posted: Wed Feb 06, 2008 12:30 am
by ray.wurlod
One function is for Modify stage, the other is for Transformer stage.
The chapter in Parallel Job Developer's Guide on Modify stage is incorrect in stating that NullToValue() can be used in Modify stage.
Try using double quotes around the default value ("1800-01-01"). What is the default date format for your project/job?
Posted: Tue Feb 19, 2008 8:22 am
by vinayc
Hi
I am also facing same problem.
I want to do null handling using Modify stage rather than transformer stage.I am using following function.
DEF= Handle_Null (DEF,'AAAA')
DEF is the column name.
But rather than transferring null as AAAA, it is transferring null only.
Can you please give me some solution?
Posted: Tue Feb 19, 2008 8:24 am
by vinayc
Hi
I am also facing same problem.
I want to do null handling using Modify stage rather than transformer stage.I am using following function.
DEF= Handle_Null (DEF,'AAAA')
DEF is the column name.
But rather than transferring null as AAAA, it is transferring null only.
Can you please give me some solution?
Posted: Tue Feb 19, 2008 2:59 pm
by ray.wurlod
Why do you have a space between the function name and the "(" character?