DSXchange

I have a requirement wherein I need to round off incoming decimal data and convert to varchar and then right to seq file without leading or trailing zeroes.
Rounding Off condition as below

Suppose data is 345.5 or lower output should be 345 and if it is greater than 345.5 then output should be 346.

Any suggestions?

Use the rtype argument to manage your rounding, and Trim() to remove leading and trailing zeroes. It's slightly more complex with signed decimal numbers.

Just changed metadata of target seq file to Integer. So rounding happens automatically

That changes the question.

ray.wurlod wrote:That changes the question. ...

:D
Yes. I know. But the target was sequential file. So decided to have target metadata changed to integer since the priority was rounding rather than having metadata as varchar