DSXchange

Hi , I worked with function like ROUND_INF, for rounding the data.This function is called Rtype function which is compatable with type conversion functions.For example DecimalToDecimal((100.00/12),'round_inf').But this function is working finely up to 18 digits.After that this function is not giving...

Hi All, Now we are doing the performance tuning for our Jobs.Presently we are using DB2 API stage to extract the attributes from database tables.If we use DB2 EE stage to extract the attributes, is it improve the perforamnce ? Please , give me some inputs on the basic difference between API and EE s...

Hi, In case 1 : If u r input column field_name=blank means it contains null.So,u want to handle nulls By using If isnull(field_name) then 0.0 else Stringtodecimal(field_name) In case 2 : If u r string contains +999.999,then first u want to remove + from string by using function convert("+"...

Hi all, I am facing one strange problem with Dataset.In one of my output Dataset i have one column like ACCOUNT :DECIMAL: Length 7 and scale 4.In my output Dataset i am getting the proper value like 87.40.While, when i am using the same Dataset as a input in one of my other jobs,all my columns are s...

Hi,

I think left function in transformer stage will resolve your problem, the syntax is as follows

Left(col1,19):col2

now the col2 will start from 20 th opsition.


Thanks&Regards
Nagesh

Hi brethart, Thanx for u r suggestion,i tried with the userdefined of the Environment variables section,but the results are not proper ? its not rounding the number properly.u have any other idea regarding this rounding function Please let me know. Thanks&Regards Nagesh Did u try adding to the u...

Hi Nagesh, Please check the Environment Variable settings. Default internal decimal variables are precision 38 scale 10, but this can be changed by specifying $APT_DECIMAL_INTERM_PRECISION $APT_DECIMAL_INTERM_SCALE Set APT_DECIMAL_INTERM_ROUND_MODE to specify : Ceil Floor Round_inf Trunc_zero I thi...

hai all, Actually i am facing problem with Decimaltodecimal(----somecalculation),Round_inf) in Transformer Stage .This function giving proper rounding up to 17 digits.its not working properly for more than 18 digits number.can anybody suggest or any help regarding this matter. Thanks & Regards N...