DSXchange

Thanks Ray, 'floor' option has solved one requirement i.e for not to round the values but this will not cater for exponential values. inputvalves=5.99999999999 and 9.9999999999999995e-07 using StringToDecimal(inputvalues,'floor') does not work for expo values as a test job i am handling expo values ...

By now with several experiements i am using

AsDouble(Input) or DfloatToDecimal(AsDouble(pTest))
These would still round but to very less extend

Any other trick would help.

Hi there, Thanks for possible solutions, Sol1: I can applied APT_DECIMAL_INTERM_PRICISION TO NONE -But the same results. :cry: Sol2: i know there are ceil,floor, round_inf and trunc_zero(default) -But all there are meant to say how to round the input value. :oops: But i don't want to round the input...

Basically i don't want to round the input value.
Is there any environment variable to disable?
[quote][/quote]

Inputstring=5.9999999999999999999
expectoutoput(decimal,26,8)=5.99999999

but i am getting 6.00000000 (decimal,26,8)

how to acevied this ia m using stringtodecimal

Please help

Oh Sorry.. I accidently clicked to Resolved

I am looking for solution.
Please let me.

can we use same share container multiple time in a same job?
Thanks

Hi All,

Does Datastage recognise exponential numbers?

ie., incoming data is 9.9999999999999995e-07
and we want to recognise this in datastage and then do validation on this.

any advise or help would be appreciable

Please let me the cause and and fixing for it.. I too facing the same error message

can anyone ellaborate on this and how to get sqlstate please.

Hi Etlers, using Oracle Enterprise Stage to load data to oracle db. need to know the sqlstate along with sqlcode at Job log for every record reject. Currently, collecting rejects in peekstage with sqlcode & message type=Info. But, can I get both sqlcode & sqlstate if message type=Info.? Is t...

Hi mrvsr, Did u tried without any conversion i.e, don't specify any conversion rule and make ur target column to decimal(x,y) and ajust the y according to ur req. but, yes if you want to do some ceil or float then conversion is req. Hi I am trying to convert a string1 varchat(256) = 010.000989887899...

Correct, and then based on this I want to perfrom the case statment. But I think transfrom is not support to handle case function. is it so? :shock: is not then what the equivalent for case statement in DS? 8) The INDEX() Function is correct; but use "INDEX(FKPOSSTR_IN.SEC_CODE,'.AX',1)" i...

It works .. Ohh it was so simple...

-Thanks a lot.

Hi, i m facing issue at

converting date (yyyy-mm-dd) to dd/mm/yyyy
converting date (dd-mon-yyyy) to dd/mm/yyyy

i tried unsuccessfully with convert function..

can any one came across such tasks?