converting the null

[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: """""

[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

[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?

[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?

[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?

[ray.wurlod]

Why do you have a space between the function name and the "(" character?