DSXchange

Hi Arndw,

Thanks for the reply,I am not able to see your full message since i am not a premier member.

could you help me to reply the decima;l function again?


thanks for the help

Hi Arndw,

Thanks for the reply,I am not able to see your full message since i am not a premier member.

could you help me to reply the decima;l function again?


thanks for the help

Hi,

I am trying to use Abs() function to remove - symbols in the data,but when i am using this ,i am getting data issue.i.e. decimals are not coming.

for ex:

old data: -123.45

if i use Abs() i am getting new data like 123

can any one help me on this...?

Hi Arndw,

Thanks for the reply and I am looking to truncate to 2 decimal places while converting from float to string.

Hi Arndw,

Thanks for the reply and I am looking to truncate to 2 decimal places while converting from float to string.

I have my job is like: source columns A--(double,15) B--(double,15) TARGET: C(varchar) I am populating target C with B and converting in to varchar. the code using now like: dfloattostringnoexp(col.B,15) this is working fine.but But now i have a change request like if columnA='XXX' Then populate tar...

all, i am getting values in my output file for one of my columns are like: 102.34 -103.68 108.98 -45.08 etc etc but requirement is to get absolute values(to remove '-' symbol) i used Abs function in my transformer for that perticular calculation,but when i tried with the function ,the decimals are c...

thanks all

hi all,

when i tried one of my job,it is getting aborted and i can see the below messaage in the log.

Transformer_20,0: Fatal Error: APT_Decimal::asInteger: the decimal value is out of range for the integer result.

could any one helpme to resolve this.

thanks in advance,
sampath

Thanks maveric for your reply.

this post is seems to be help full for me,but could you clarify one thing ,when defining sort stage ,which column do i need to mention to sort.

is it column xxx or different?

hi all, I have 10 input columns passing to an aggregator stage in my job.and i am doing sum on column xxx.Thais column is passing to next stage like sum_xxx. and i dont want to groupby this column xxx.and i need this column available for next stage.(not sum_xxx,but only xxx) so how to get this colum...

hi all, I am getting below warning message in my director log ,when i tried to run my job ,i am using source as the sybase and i am loading in to .ds file warning message: vw_ven_xxx,0: Unable to set output decimal field value from argument string '4.0000000000000003e-05' in function setOutputFieldA...

Hi All, I have a requirement to generate a sequential file from sql server database and it is a parallel job. And we are using Autosys to schedule and run our datastage jobs. But for this perticular file,the requirement is like: it should generate(datastage job should run) only on 5th bussiness day/...

Hi All, I am getting below message in my log,when i try to run the job. I have dataset as one input file. Input_Delta,0: Delimiter for field "CNTRY_NME" not found; input: {U N I T E D 20 K I N G D O M}, at offset: 313 no records are processing and all are rejecting. Can any one help me on ...

Hi All,

I am getting some warning messages in my director log like below.

Input_Delta,0: Field "LT_SZE" has import error and no default value; data: <empty>, at offset: 202


This is message belongs to one sequential file stage.

Any one has idea?