Hi,
I have a peculiar issue. In datastage 7.1 when I used source as char(4) and value (26 two leading spaces) and convert to integer (without any function) it goes through fine but in 8.1 it is converted to zero. Since we need to change for lot of jobs is there any environmental variable settings which can be changed?
Conversion from character to Integer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 47
- Joined: Thu Oct 04, 2007 3:37 am
- Location: chennai
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't think there's any "automatic" mechanism here. The granularity is too fine to use Find. Others will recommend search and replace in a DSX file, but you would need to be so, so careful not to change anything incorrectly.
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.