How to populate NULL?

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
synsog
Premium Member
Premium Member
Posts: 232
Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune

How to populate NULL?

Post by synsog »

Hi..

My column datatype is decimal. so can you please let me know how to populate null for that coumn. If i use setnull() then , all the 0 values are also populating as null.

Please reply


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

Post by ray.wurlod »

What is your target?

What is your derivation expression?
(For example, setnull() alone will only and always set NULL - you need conditional logic that specifies when NULL should be set.)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply