Hi All,
Iam having problems bringing in a DateTime field coming from Oracle which as some NULL values and trying to load into Teradata DATE field (which allows NULL's).
what is the best way to load a NULL value into a DATE field?
Thanks in Advance.
Inserting NULL value in a DATE field
Moderators: chulett, rschirm, roy
Re: Inserting NULL value in a DATE field
Create this ENV variable and set its value to 1
APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL
APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL
poorna_76 wrote:Hi All,
Iam having problems bringing in a DateTime field coming from Oracle which as some NULL values and trying to load into Teradata DATE field (which allows NULL's).
what is the best way to load a NULL value into a DATE field?
Thanks in Advance.