Hi
I am encountering erron while trying to insert DATETIME YEAR TO FRACTION(3) field. DataStage takes the field as TimeStamp (25) while reading , but failed to insert the same column while I tried inserting it to exactly same data type field.
I encountered the same problem in Server Job for Data Type DATETIME HOUR TO MINUTE!
The error displayed is
Dynamic_RDBMS_15: [Informix][Informix ODBC Driver][Informix]Non-numeric character in datetime or interval.
I tried to use CAST statement in user defined query without any success.
Any suggestion.
Regards
Rubu
Error Inserting DATETIME field
Moderators: chulett, rschirm, roy
Hi,
DATETIME hour to minute has hh:mm format so you'll probably have to substring your data type since no DS type is compatible.
year to fraction could have a similar issue since timestamp (AFAIK) is not including a fraction part.
Unfotunatly I don't have Informix available to give you real solutions
IHTH,
DATETIME hour to minute has hh:mm format so you'll probably have to substring your data type since no DS type is compatible.
year to fraction could have a similar issue since timestamp (AFAIK) is not including a fraction part.
Unfotunatly I don't have Informix available to give you real solutions
![Sad :(](./images/smilies/icon_sad.gif)
IHTH,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
-
- Participant
- Posts: 82
- Joined: Thu Dec 02, 2004 10:27 pm
- Location: INDIA