DSXchange

Posted: **Fri Mar 07, 2014 10:17 am**

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

Posted: **Fri Mar 07, 2014 2:42 pm**

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.

Posted: **Fri Mar 07, 2014 6:38 pm**

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.

Posted: **Wed Mar 12, 2014 11:40 pm**

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

Posted: **Thu Mar 13, 2014 1:38 am**

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.

Posted: **Tue Jun 03, 2014 12:08 pm**

Thanks Ray,

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

DSXchange

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

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

Reply