Page 2 of 2
Posted: Fri Feb 12, 2010 3:23 pm
by kbsuryadev
source ACD_ID( NULL) TARGET ACD_ID( NULL)
In datastage it should say YES on both source and target ................. not NO
Posted: Sun Feb 14, 2010 3:35 pm
by Kryt0n
As a workaround, try wrap your query within another select query i.e.
Code: Select all
select col1, col2, colasnum from
( select col1, col2, to_number(col3) as colasnum....)
Not sure why but DataStage EE doesn't seem to like conversions within queries... [/code]
Posted: Mon Feb 15, 2010 4:46 am
by priyadarshikunal
sreddy wrote:Thank you Priyadarshi Kunal
I need data in Number that is why i am converting from String to Number.
please follow the history messages and help me.
"ACT_ID" to field "ACT_ID": Implicit conversion from source type "decimal[38,10]" to result type "string[12]": Not enough room in string for decimal[38,10].
this error means that you have defined the coulmn as varchar(12)
and you are applying to_number() in your query. when you don't specify the length of number explicitly it will be taken as number(38,10). Thats why you are getting this error.
Please try to understand the post before replying.
Regards,
Posted: Mon Feb 15, 2010 4:50 am
by priyadarshikunal
There is also a theoritical possiblity of getting a null value even if the column is not null when you apply any conversion function and hence the warning related to null. You need to define it as null and then convert it to not null in downstream modify/transformer stage.
Posted: Mon Feb 15, 2010 8:32 am
by kbsuryadev
thanks Kunal ....I am glad you found the solution.