DSXchange

sorry my bad,i have said saleem instead of waseem.

Thanks waseem once again.



Thanks.

Thanks to all of you.

I have used As Saleem said

Asfloat(Asfloat(inputcoloumn)/Asfloat(10.0)) and it solved my problem...


Thanks Saleem for the solution........

Hi

I have tried

Div(AsFloat(AsFloat(DSLink3.INSTR_SET_HRS)/AsFloat(10.0))) This aldo its not giving decimal output..

Any one help mee...

Thanks

Ray,i am posting the generated OSH,Please have a look at it...Thanks INput field is INSTR_SET_HRS Output field for this input is CONTACT_HOURS ################################################################# #### STAGE: DB2_UDB_API_0 ## Operator dscapiop ## Operator options -stageprops PSAyyDP__T_S...

Yes ,Ray .I have checked ,the Target is Decimal(4,1) and Source is Integer.

Thanks

I did what you said Ray,But the result is same its not giving the decimal values.Any other possible way.

Help me..

Thanks.

Thanks Ray,

Its not working..

Thanks Ray,

But its not working.I have used Div(AsFloat( DSLink3.INSTR_SET_HRS), AsFloat(10)).Its still giving only integer value with out decimal values.

My sorce and target is DB2

Thanks

Hi.

I have to divide an input(integer) by 10. And output is decimal(4,1).I did
Div(input coloumn,10) in Datastage 8.0 Parallel

Ex 12/10 = 1.2

But i am getting only 1 as outout.Instead of 1.2.

I have tried this Div(AsFloat(input coloumn),10) but it is also not working.

Thanks.