Datastage function

[atulgoel]

Hi,

Can anyone please tell me what would be the output of the below given function and how is ir working?

INPUT is DECIMAL of 8 Length
OUTPUT is VARCHAR of 2 Length

INPUT= 10990001

OUTPUT = FMT(INPUT,"R%8")

Thanks in Advance!

Thanks
Atul

[ArndW]

Page 164 of the [u][i]BASIC Programmers Guide[/i][/u] details what you want to know. The R format is right-justified. the % shows zeroes. I can't check now, but I think the format clause is wrong, the length (8) should be first. i.e. '8%R'

[Sainath.Srinivasan]

Why don't you try it out ?

Right oriented zero padded 8 digit output.

Your output will be '10'.

Note - I have not tried it. So it is just my guess.

[ray.wurlod]

In spite of Arnd's doubts, "R%8" is also correct. The width parameter is not required if there is a mask, and "%8" is a shorthand way of specifying "%%%%%%%%" as a mask. "R%8" displays the rightmost eight characters of the input, left padding with zeroes as required.

To answer your original question, the data will appear unchanged, since there are already eight characters - no leading zeroes would be required.

[major]

The simple way to know ourselves how a particular function works is to write a test routine with it and test it