String to Number Convertion ( User defined SQL ) problem

[kbsuryadev]

source ACD_ID( NULL) TARGET ACD_ID( NULL)

In datastage it should say YES on both source and target ................. not NO

[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]

[priyadarshikunal]

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,

[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.

[kbsuryadev]

thanks Kunal ....I am glad you found the solution.