Please help to solve in the warning

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
deesh
Participant
Posts: 193
Joined: Mon Oct 08, 2007 2:57 am

Please help to solve in the warning

Post by deesh »

Hi Friends,

Please Help in the below warning, its occured in my job

REPORT: When checking operator: When binding input interface field "COUNTRY_CODE" to field "COUNTRY_CODE": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted
angelovaira
Participant
Posts: 16
Joined: Fri Mar 28, 2003 4:36 am
Location: Italy - Roma

Re: Please help to solve in the warning

Post by angelovaira »

deesh wrote:Hi Friends,

Please Help in the below warning, its occured in my job

REPORT: When checking operator: When binding input interface field "COUNTRY_CODE" to field "COUNTRY_CODE": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur;
use a modify operator to specify the value to which the null should be converted
Try these actions:

1)In the properties page of the source sequential file go to the format tab and set the filling charachter for the null fields.

2)Otherwise, If the target is not nullable, in the transformer you must change the nullable fields in not nullable using a function, for example if isnull(link_in.COUNTRY_CODE) THEN " " ELSE link_in.COUNTRY_CODE.

If the source can be nullable, change the field type of the target table in nullable and set nullable in the source field stage and target field stage.
Post Reply