Attempt to setIsNull() on the accessor interfacing to non-nu

[Developer9]

Hi everyone,

I am getting below error Joining two tables (A ,B)using LEFT OUTER join in DB2 connnector stage.
Keys:FIELD1,FILED2,FILED3,FIELD4,FIELD5

Code: Select all

All fields defined as null expect FIELD5 defined as NOT NULL

A-LEFT table ,B-Right table

Code: Select all

DB2Conn,0: Fatal Error: Attempt to setIsNull() on the accessor interfacing to non-nullable field "B.FIELD5".

Query from output :

Code: Select all

I have 60 records out of which for one record I have B.FIELD1,B.FILED2,B.FILED3,B.FIELD4,B.FIELD5 as blank.

Earlier job ran fine with no issues but recent run I am having this error ..(data might have change in right table B)

Can you please suggest me how to handle this scenario ?

Thanks

[ray.wurlod]

Any kind of outer join has the potential to return null columns. This is normal and does not require any special handling, other than to make sure that the receiving columns and those on the outer part of the join are nullable.

[ssnegi]

DB2Conn,0: Fatal Error: Attempt to setIsNull() on the accessor interfacing to non-nullable field "B.FIELD5".

Make "B.FIELD5" field as Null from non-nullable. This should allow null values in field.

[kduke]

There is an IsNull() function and a SetNull() function but no setIsNull().

[ray.wurlod]

There is an internal setIsNull() function, used when assigning null into a column in a Connector stage. Apparently your design has sent null into a non-nullable column in the Connector DB2Conn.

[Developer9]

Thanks Ray,

I changed the column from non-nullable to nullable .Issue resolved.