Null handling of Timestamp field in Modifystage

[madsongtel]

Hi All,

My source is delimiter text file, i am reading as char datatype for all columns. Timestamp filed coming as (2008-05-15-14.59.36.000000).
i am using modify stage to convert all datatypes and laod into DB2 table.
but for timestamp columns some times it as coming as null and i have to load as null only in table. when i get null then job is getting aborted with below error :DB2_Connector_467,3: Operator terminated abnormally: received signal SIGSEGV"

How can we handle nulls for timestmap field in modify stage and load as nulls only.

please help me.

[ray.wurlod]

Do you need to use an in-band null or an out-of-band null?

[kmsekhar]

Hi madsongtel,

Please go through with the below link it will brief you about Out-of-band to normal representation and normal to Out-of-band representation:

http://publib.boulder.ibm.com/infocente ... Nulls.html

[madsongtel]

Thanks Ray and kmsekhar, issue solved.