Concatenate to an integer

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
Shruthi
Participant
Posts: 74
Joined: Sun Oct 05, 2008 10:59 pm
Location: Bangalore

Concatenate to an integer

Post by Shruthi »

We have a requirement when we have to concatenate a value to integer.

Input is 1999
Output should be 11999

How to concatenate this?
Top
Sreedhar
Participant
Posts: 187
Joined: Mon Oct 30, 2006 12:16 am

Post by Sreedhar »

Hi,

add 10,000 to the given value.....
Regards,
Shree
785-816-0728
Top
jpraveen
Participant
Posts: 71
Joined: Sat Jun 06, 2009 7:10 am
Location: HYD

Post by jpraveen »

Hi,

convert the integer into varchar and then concat it.
Jaypee
Top
Shruthi
Participant
Posts: 74
Joined: Sun Oct 05, 2008 10:59 pm
Location: Bangalore

Post by Shruthi »

I wanted to avoid conversions as they are giving lot of confusions. adding 10000 is a great idea. will go ahead and use this. Thanks
Top
Post Reply

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