DSXchange

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

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).

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

Hi,

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

HTH
Rich

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