Friends,
when i tried to default the timestamp filed with null value("") in in transformation i am getting the folllowing error
APT_CombinedOperatorController,2: Conversion error calling conversion routine timestamp_from_ustring data may have been lost
Ora_Lot_Attributes,0: Failure during execution of operator logic.
but if i populate some timestamp field its running fine..
my requirement is i have pass(default) null value to the target field..
target datatype timestamp 38
Thanks
null value to timestamp
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 7
- Joined: Wed May 17, 2006 12:41 am
- Location: Pune
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why do you hope that?
There IS a make_null() function for the Modify stage. Unfortunately the Parallel Job Developer's Guide documents this incorrectly. You also need to read the Orchestrate Operators manual.
There IS a make_null() function for the Modify stage. Unfortunately the Parallel Job Developer's Guide documents this incorrectly. You also need to read the Orchestrate Operators manual.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.