problem with handling nulls with timestamp field

varshanswamy · Post by **varshanswamy** » Fri Jun 10, 2005 2:57 pm

Hi,

I have a table which has a date column which can have a null value.
How do I use the modify stage to handle this the timestamp field.
and

regards,
varsha

ray.wurlod · Post by **ray.wurlod** » Fri Jun 10, 2005 5:59 pm

In the transitional definition don't specify that the target column is nullable, and handle the incoming null so that it is replaced with a default value (or dropped).

varshanswamy · Post by **varshanswamy** » Sat Jun 11, 2005 2:37 pm

ray.wurlod wrote:In the transitional definition don't specify that the target column is nullable, and handle the incoming null so that it is replaced with a default value (or dropped).

Eloborating on this I have read it as a timestamp field in datastage and handled it in a transformer, but the transformer slows the performance so
I wanted to know how I could use modify stage to handle it, which I am unable to handle

richdhan · Post by **richdhan** » Tue Jun 14, 2005 11:29 am

Hi,

Do a search on "handle_null" in this forum. A lot of examples have been discussed before.

HTH
Rich

bgs · Post by **bgs** » Tue Jun 14, 2005 12:42 pm

in the specification
<columnname> = handle_null(<columnname>,"<replacement value>")