Hi
I want to know what value we should use if we need to handle null for decimal and date fields and provide some value if thouse contains null value in souce fields.
Please provide some suggestion if some one have already handled decimal and date field without using any type conversion functions.
Regards
default value for Nullable decimal fields
Moderators: chulett, rschirm, roy
default value for Nullable decimal fields
Regards,
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Deepak Singhal
Everything is okay in the end. If it's not okay, then it's not the end.
Re: default value for Nullable decimal fields
hi,
It depends upon your business logic as what to default the NULLS to in decimals and date fields. We had faced a similar problem and had asked the business to define the defaults incase NULLS were encountered.
Sometimes a NULL value in a decimal field is also correct data. you might default it to 100.0000 , or it could be 0.0 as well..
for dates it could be 9999/12/31 as default or the current system date or processing date - as per the requirement.
cheers,
Nik
It depends upon your business logic as what to default the NULLS to in decimals and date fields. We had faced a similar problem and had asked the business to define the defaults incase NULLS were encountered.
Sometimes a NULL value in a decimal field is also correct data. you might default it to 100.0000 , or it could be 0.0 as well..
for dates it could be 9999/12/31 as default or the current system date or processing date - as per the requirement.
cheers,
Nik