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.
Null handling of Timestamp field in Modifystage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Fri Aug 01, 2008 2:56 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Null handling of Timestamp field in Modifystage
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
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
-
- Participant
- Posts: 31
- Joined: Fri Aug 01, 2008 2:56 am