Inserting NULL value in a DATE field

[poorna_76]

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.

[dsguy1247]

Create this ENV variable and set its value to 1

APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL

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.