DSXchange

Did you try something like this ?

If NullToValue(lnk_in_tfm.Gender,'$')='$' Then 300 Else 0

Still it would be decimal datatype and hence the leading zeroes would be available.

Please try the below for removing control-m and see if it helps.
1) dos2unix or
2) sed -e "s/^M//" filename > newfilename
To enter ^M, type CTRL-V, then CTRL-M. That is, hold down the CTRL key then press V and M in succession

Did you try to read the whole record as 1 single column in source stage and then split using Field function in a transformer stage using delimiter(pipe in this case)?

For me....it looks like the 2nd invocation_id passed isn't different from the 1st one. Are you seeing 2 different log files generated in the DS Director client when you run this job with one instance at a time?

Row number column in the options category can be used to generate row numbers if required...using which we can filter in subsequent stages.

Could you please give us the details of on how many nodes and partitions the sequence job ran when it failed and the parallel job ran when it succeeded?

--
Raj

Gaurav,
Did you try viewing the data by defining it as either LONGVARCHAR? If not...Could you please try and let us know?

Hi,
Please provide few more details like how exactly are you calculating length in DataStage & Unix?

--
Rajesh

Is '1' the scale for your decimal ? Also, what is the maximum value you are passing when you are getting the error ?? You need to account for minus sign too while calculating the length(i.e. length of decimal + 1) should be your target column length for varchar field to avoid this message.

--
Rajesh

I have never done one before of this kind. So, lets wait for one of those who did it in the past if that's feasible.

--
Raj

Diego,
Can we have the command you are using so that it would be easy to troubleshoot and add the missing component(s)?

--
Raj

koolsun85 wrote:You will find in "Sum Output Column" with the property name "Decimal Output" where the default is 8,2 .

Hopefully dspxlearn has resolved this in the past 5 1/2 years. If not, this is the moment to go for it.

--
Raj

Does the view data return correctly?

--
Raj

Did you try deleting the transformer stage and by placing a new one? (Sometimes this worked for me in few of my jobs)
Or
Does this job compile fine in other projects/environments?
Or
Would it be possible to design the job from scratch? If so, can you try and let us know please

--
Raj