Getting NULL handling warning even when checking for NULL

Abhyankar · Post by **Abhyankar** » Mon Mar 16, 2009 6:18 am

Hi,
My Job uses 2 sources, then a change capture stage then inserting the changed records in my DB2 stage. I am getting below mwnetioned warning:

" Assignment of a NULL value to a NOT NULL column "TBSPACEID=4, TABLEID=114, COLNO=0" is not allowed. SQLSTATE=23502 "

I am getting this even though i am checking for NULLs in a transformer stage just before target stage. My null handling condition says to check for null, if it exits populate a ' ' else the value.

Mike · Post by **Mike** » Mon Mar 16, 2009 6:25 am

You're most likely getting this error because the columns mentioned in your DB2 stage are not consistent with the columns defined in the database table. Specifically "COLNO=0" would be the first column in the database table...

Mike

Abhyankar · Post by **Abhyankar** » Mon Mar 16, 2009 7:03 am

Thanks mike. Will check that!