How to populate/Pass NULL. Equivalent to SETNULL in Px

ds2000 · Post by **ds2000** » 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

chulett · Post by **chulett** » Thu Aug 14, 2008 7:50 am

You use the @NULL system variable.

ds2000 · Post by **ds2000** » Thu Aug 14, 2008 9:28 am

It worked. Thanks.