How to populate/Pass NULL. Equivalent to SETNULL in Px
Posted: Thu Aug 14, 2008 7:49 am
Im new on server jobs, so please bear me for sometime. We used SETNULL() function in parallel what is equivalent in server.
I want to pass null to db2 date column. Row is loaded with null but Following warning msg comes :
JobLoadFile..Transformer_22: At row 53, link "DSLink24", while processing column "BIRTH_DATE"
Value treated as NULL
Attempt to convert String value "" to Date type unsuccessful
I want to pass null to db2 date column. Row is loaded with null but Following warning msg comes :
JobLoadFile..Transformer_22: At row 53, link "DSLink24", while processing column "BIRTH_DATE"
Value treated as NULL
Attempt to convert String value "" to Date type unsuccessful