Converting string to number

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

So now you're taking what I assume is the result of the lookup from an integer back to a string with no conversion? Why? :?
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
prakashdasika
Premium Member
Premium Member
Posts: 72
Joined: Mon Jul 06, 2009 9:34 pm
Location: Sydney

Post by prakashdasika »

If the source data is from database try to cast it in the sql itself as a number. Use TO_NUMBER function and read it directly as integer in datastage. This will remove the leading '0' and the key fields will be integer.
Prakash Dasika
ETL Consultant
Sydney
Australia
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”