Null handling of Timestamp field in Modifystage
Posted: Sun Jul 03, 2011 9:18 am
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.
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.