NUll handling

[dsdevper]

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..

[ray.wurlod]

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

[dsusr]

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.