NULL Handling using Modify stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
aaikat
Participant
Posts: 47
Joined: Tue Mar 07, 2006 2:49 am

NULL Handling using Modify stage

Post by aaikat »

I want to convert any NULL values in column XYX to "NULLXYZ" using Modify stage.

I used the following statement as specification :

XYZ:string = NullToValue(XYZ,"NULLXYZ")

But it is giving error like :

main_program: Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue
Expected destination field selector, got: ")"; input:
balajisr
Charter Member
Charter Member
Posts: 785
Joined: Thu Jul 28, 2005 8:58 am

Re: NULL Handling using Modify stage

Post by balajisr »

aaikat wrote:I want to convert any NULL values in column XYX to "NULLXYZ" using Modify stage.

I used the following statement as specification :

XYZ:string = NullToValue(XYZ,"NULLXYZ")

But it is giving error like :

main_program: Error parsing modify adapter: Error in binding: Unknown conversion: NullToValue
Expected destination field selector, got: ")"; input:
Use handle_null function instead of NullToValue.
aaikat
Participant
Posts: 47
Joined: Tue Mar 07, 2006 2:49 am

Post by aaikat »

Thanks,it is solved
Post Reply