Hi
My job failing with error esql complaint: ORA-12899: value too large for column
error is coming while updating , the field which giving error has length 40 before database stage there is trnasfpormer stage and in transformer have derivition like
if isnull(columnname) then setnull() else left(columnname, 35)
in database also the filed is having lenght 40.
I have used tring in transformer , substring in sql but still same error persists. Source is SAP system and filed is coming only 40 char from there side.
Any clues,solution for this
thanx in advance
DataStage job failing with error esql complaint: ORA-12899:
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
-
- Participant
- Posts: 88
- Joined: Wed Apr 05, 2006 1:04 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
What Craig is getting at with his question is that, depending on what character set you are using, it may require more than 40 bytes to store 35 characters. Oracle can be specified to allocate storage in either bytes or characters.
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.