Decimal to integer

somu_june · Post by **somu_june** » Thu Mar 09, 2006 3:43 pm

Hi,

Iam using an stagevariabe as integer .ex total (variable)

Total(integer) = Total(integer)+Reclinenumber(decimal). I want this Reclinenumber to convert to integer.How to convert decimal to integer can I take it asinteger function to convert decimal to string. Please help me

Thanks
Somaraju

ray.wurlod · Post by **ray.wurlod** » Thu Mar 09, 2006 4:21 pm

AsInteger may generate warnings, because the potential exists for your decimal number to be too large to fit in an integer. If you can be 100% certain that this will never be the case, equip a message handler for this message in this job to demote the warning to informational.

somu_june · Post by **somu_june** » Thu Mar 09, 2006 5:03 pm

Hi Ray,

Sorry Iam not able to understand. What is this equip a message. Is there any solution for this . please help me.

Thanks
Somaraju

ray.wurlod · Post by **ray.wurlod** » Thu Mar 09, 2006 5:24 pm

No. DataStage will always generate the warning. Because you need the warning. If you want to you can create a message handler to demote the warning to an informational message. Search is your friend.

rasi · Post by **rasi** » Thu Mar 09, 2006 5:30 pm

Somu

The easiest way is to convert your decimal to integer use AsInteger

Total(integer) = Total(integer)+AsInteger(Reclinenumber(decimal)).

vinaymanchinila · Post by **vinaymanchinila** » Fri Mar 24, 2006 10:14 am

How can we convert an integer to string, we have source column as 2 , and we need it to be padded with 0s for lenght of 3 i.e. 002.

Thanks,

vcannadevula · Post by **vcannadevula** » Fri Mar 24, 2006 10:26 am

vinaymanchinila wrote:How can we convert an integer to string, we have source column as 2 , and we need it to be padded with 0s for lenght of 3 i.e. 002.

Thanks,

You can use the padstring() function

vinaymanchinila · Post by **vinaymanchinila** » Fri Mar 24, 2006 11:27 am

Thanks for the inputs, when I used PadString() its padding at the end so its making a 1 to 10 , I was expecting 01 !

kumar_s · Post by **kumar_s** » Sat Mar 25, 2006 5:40 am

Use MantissaFromDecimal or need to pad the string of 0s to the left of the existing number manually after calculating the length (digint) of the existing number.

vinaymanchinila · Post by **vinaymanchinila** » Mon Mar 27, 2006 9:08 am

Right now using FMT(SrcColumn, "2'0'R") , wil post it if I come across any better ideas.

kumar_s · Post by **kumar_s** » Mon Mar 27, 2006 9:00 pm

Are you using transformer or BasicTransformer?

vinaymanchinila · Post by **vinaymanchinila** » Fri Mar 31, 2006 9:05 am

The basic transformer.

Thanks,

vsurap · Post by **vsurap** » Fri Mar 31, 2006 11:26 am

Right( ("000":SrcColumn) , 3 )

vinaymanchinila · Post by **vinaymanchinila** » Wed May 03, 2006 1:46 pm

Hi,
FMT(SrcColumn, "4'0'R") was working fine but when it hits a -ve number it pads like this 00-12 instead of -012 .
Any ideas on how to correct this !

Thanks,

ray.wurlod · Post by **ray.wurlod** » Wed May 03, 2006 8:23 pm

Code: Select all

(If (SrcColumn < 0) Then "-" Else "") : Fmt(Abs(SrcColumn), "R%" : (4 - (SrcColumn < 0)))

or

Code: Select all

If SrcColumn < 0 Then "-" : Fmt(Abs(SrcColumn), "R%3") Else Fmt(SrcColumn, "R%4")

"R%4" is another way to represent "4'0'R" but fewer keystrokes.