modify stage

deepthi · Post by **deepthi** » Mon Aug 22, 2005 7:35 am

Hi
i'm using modify stage to handle null values.
the expression i used is AP_SOC = NullToValue ( AP_SOC, "DMY" ) , where "AP_SOC" is the column that has null values and should be replaced by dummy variable "DMY".
i'm getting the following error
: Error parsing modify adapter: Error in binding: Expected '=', got: "("
Expected destination field selector, got: ")"; input:
can some one please check this.
thank you
deepthi

elavenil · Post by **elavenil** » Mon Aug 22, 2005 7:39 am

NullToValue will not work in Modify stage. Instead use handle_null (ColName, <default value>) function to replace the null value. Parallel job's documentation needs to be amended.

HTWH.

Regards
Saravanan

deepthi · Post by **deepthi** » Mon Aug 22, 2005 2:11 pm

Thanks it worked for null values , but its showing 0,rows at the modify link, but the destination file after this modify link is showing all rows.

elavenil wrote:NullToValue will not work in Modify stage. Instead use handle_null (ColName, <default value>) function to replace the null value. Parallel job's documentation needs to be amended.

HTWH.

Regards
Saravanan