SetNull() in a Nullable field conundrum

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
blewip
Participant
Posts: 81
Joined: Wed Nov 10, 2004 10:55 am
Location: London

SetNull() in a Nullable field conundrum

Post by blewip »

This may be a stupid question however; if I have a Nullable field (say varchar(12)), why cannot I set the derivation to SetNull()?

Surely if a field is nullable it can accept a Null, as a value. And setNull surely sets Null to be the value?
blewip
Participant
Posts: 81
Joined: Wed Nov 10, 2004 10:55 am
Location: London

Post by blewip »

I am going to Sequential Stage, so I can set Null field value = "" in Format, Field Defaults it does kind of work.

However if I was going to other stages I may not have this option.

I shall try this out.
Post Reply