Setting output field to Null in 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
ggarze
Premium Member
Premium Member
Posts: 78
Joined: Tue Oct 11, 2005 9:37 am

Setting output field to Null in Modify stage

Post by ggarze »

Any way to set an output field to NULL in the modify stage? I've tried
EVNT_ACTVTY_SEND = null and
EVNT_ACTVTY_SEND = SetNull()

and neither work.

thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Try make_null() function.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ggarze
Premium Member
Premium Member
Posts: 78
Joined: Tue Oct 11, 2005 9:37 am

Post by ggarze »

Looks like same error as when I tried SetNull(). doesn't seem to like functions.
EVNT_ACTVTY_SEND_TMSTMP = make_null()

main_program: Error parsing modify adapter: Error in binding: Expected source field selector or conversion name, got: ")"
Expected destination field selector, got: ")"; input:
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

outputcolumnname = make_null(inputcolumnname)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ggarze
Premium Member
Premium Member
Posts: 78
Joined: Tue Oct 11, 2005 9:37 am

Post by ggarze »

Unfortunately that did not work either. Didn't fail but it put the value of the input field in the output instead of NULL

EVNT_ACTVTY_SEND = make_null(resultcode)
Post Reply