Setting Null to a nullable decimal column

srinivas.nettalam · Post by **srinivas.nettalam** » Tue Feb 21, 2012 8:14 am

Is that true that if we use SetNull() to a nullable decimal field ,it goes as 0.00 in to database???I really felt wierd when most of the people said that.

chulett · Post by **chulett** » Tue Feb 21, 2012 8:33 am

Why not test that theory yourself? Sounds all kinds of wrong to me.

DSguru2B · Post by **DSguru2B** » Tue Feb 21, 2012 8:46 am

Sometimes the database columns have default values set. Maybe thats in play here.

chulett · Post by **chulett** » Tue Feb 21, 2012 8:52 am

You have to not mention a column in your DML for the default value to be used, setting it to null will cause it to be null regardless of the default. That's true for Oracle and I'm assuming other databases as well.

DSguru2B · Post by **DSguru2B** » Tue Feb 21, 2012 8:59 am

In DB2 it depends how the DBA has set it. There are conditional values on inserts as well.
Test it out as Craig mentioned. Drop the records in a dataset or flat file and see what the values are. If it shows up null there then there is something on the database side.

srinivas.nettalam · Post by **srinivas.nettalam** » Tue Feb 21, 2012 9:02 am

thanks all for your replies..I am getting NULLs in database.I was confident enough but the counters were many.Hence I posted but yes it is my fault to post it before testing on my own