DSXchange

HI


JOb design is

DB2----------Transformer-------Sequential file.
-
-
-sequential file(reject).

My both input and out coloumns are Nullable feilds.
I am using

If IsNull(DSLink15.SOURCE) Then NullToValue(DSLink15.SOURCE,'A') Else DSLink15.SOURCE

For nullhandling in stage variable.

But still i am getting error
"APT_CombinedOperatorController,0: Field 'SOURCE' from input dataset '0' is NULL. Record dropped.

Can any one help..

Disable operator combination. You may then find that the error is not being generated where you think it is.

just check if you are using the same column elsewhere in transformer. In addition to this put the property NullFieldValue='' in the Reject(sequential File)...

Also if-then-else syntax is redundant as you can use the function NullToValue(Source,'A') directly.