Trying to insert Black where columb datatype is Date

mshilpa · Post by **mshilpa** » Tue Dec 16, 2008 5:53 am

Hi ALL,
I am trying to insert "Blank" in one of my column where my column data type is DATE.
But but i am not able to do so.
Could anybody please help me.
Thanks in Advance

DS_SUPPORT · Post by **DS_SUPPORT** » Tue Dec 16, 2008 7:10 am

What do you meant by 'BLANK'? Is it Null or Empty String ?

Will your target accept NULL values for that date column, in that case use @NULL in your Transformer derivation.

Sathishkumarins · Post by **Sathishkumarins** » Tue Dec 16, 2008 7:17 am

mshilpa wrote: I am trying to insert "Blank" in one of my column where my column data type is DATE.

If you are using any database like oracle then you have to give 'Y' in nullable column in table or view as well as in DS. Otherwise you might get "cannot insert null error".

ray.wurlod · Post by **ray.wurlod** » Tue Dec 16, 2008 12:16 pm

If this is a parallel job (as marked) then "blank" is not a legal value. Parallel jobs strictly enforce data type compliance.

DSXchange

Trying to insert Black where columb datatype is Date

Trying to insert Black where columb datatype is Date

Re: Trying to insert Black where columb datatype is Date