DSXchange

Use Round Function: Round(field_name,2)

or

Use longint

Thanks Everyone! I figured the answer out.

I need to create a buidop which will do the branching for me to divert to appropriate output link and select from appropriate input link.

why dont u use "do while" in Unix scripting? The job flow design contains lot of other stuff within the job itself. The looping required is for different file merge with different schema and I am using Generic Stage to provide the dynamic expression files to merge operator. This merge ope...

Thanks DSGuru!

The problem is the environment being used here doesnot support sequencer. I need to loop within DataStage job.

I need to loop 'x' times for a functionality. 'x' is a variable and can be passed as an environment variable to the job.

if x=4; I need to loop for a particular logic (coded within shared container) 4 times.

How can I handle looping in DataStage PX job?

Thanks Ray,

I could not find any function with the name mentioned by you.

Instead, I used DecimalToDecimal(%string%,"round_inf") to get the rounded data as I needed.

Hi,

We need to ROUND the numeric data result of a numeric division to nearest integer value. Is there a function in PX to address this?

>2.5 should be rounded to 3
<=2.5 should be rounded to 2

Thanks,