isnull() function

[deva]

Hi all
I am using 7.1 datastage v. windows xp.
I have 4 fields, circuit, phn, bill_info, bill
I have query,

we need to load the data into bill_info where ,

if circuit is null take the data from phn. and bill = 'phn'
if phn is null get the data from circuit.and bill='crc'

I given like : bill_info= if isnull(circuit) then phn else circuit.

Please help me on this.

Thanks in advance...

[DSguru2B]

Your code looks fine. Is there something thats not working?
Have you considered the scenario in which both circuit and phn are null? Then what?

[deva]

Your code looks fine. Is there something thats not working?
Have you considered the scenario in which both circuit and phn are null? Then what?

no actually if we have circut we populate curcuit value into bill_info and we have another field say bill , we hotcode bill = crc,
if we have phn then we populate phn value into bill_info and we hotcore bill = phn

[DSguru2B]

You are saying the same thing over and over.
Tell me this, how will you handle the following:
What if both are not null?
What if both are null?
and between the two, which one take precedence (i.e, which one to check first)?