Unable to set output decimal-director warning message

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
scorpion
Participant
Posts: 144
Joined: Thu May 12, 2005 4:19 am

Unable to set output decimal-director warning message

Post by scorpion »

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 setOutputFieldAsDecimal() for field '0' in output dataset '0'.


Does any one have idea about this warnig?

Help would be appreciated.

cheers,
Thanx&Regards
scorpion
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post by Maveric »

Code: Select all

output decimal field value from argument string
Looks like you are trying to map char or varchar data type to decimal data type. What is your source data type? If it is char or varchar then you will have to convert it to float first and then to decimal.
Post Reply