Hi Buddies,
help me to get out the warning
Implicit conversion from source type "int32" to result type "string[max=6]": Converting number to string.
trying to convert int (2) to varchar(6), in modify stage, not able to find suitable function name
Implicit conversion from source type "int32" to re
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Tue Jan 29, 2008 3:48 am
- Location: Chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There is no such thing as int(2). You have an int32 with a display width of 2. The largest possible int32 has 11 characters. This will not fit in a string[6] and therefore DataStage generates this alert. You may have knowledge about your data that might allow you to use int16, where six characters in the string would be sufficient.
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.