DSXchange

That's what I'm doing in the extraction job.

It shows up as 2.55487e+07

That's what I'm doing in the transformation job.

That where I get the value 25548700.

I have been struggling to get my floats (doubles actually) to work correctly. I think I have found out why, the DataSet can't handle floats correctly. We have a common framework where an extraction jobs is used to determine which rows are extracted, this is stored in a DataSet then a transformation ...

My problem was actually caused by the p.c's network card set to Half Duplex.

My more complex jobs didn't compile either.

I am also getting this error, compiling sequences, but jobs are okay. My p.c is new, but I am an administrator, and I have refeshed the security to the DataStage client folders just in case. I am wondering if this is a bug, I am running 7.5.1. If I don't hear anything, I will raise this with Ascenti...

Well this should work

If I change the precision (the length) it does not seem to have any effect. However I have been playing around with something that does appear to have an effect. I did say that we have tried Double and this has no effect, however it turns out that this is not entirely true. If I change the type from...

It seems that the problem may be with the conversion from Float to display, internally the data may be okay. However as I actually want the Float to be output to a file it's not very helpful for me. I understand that the conversion process can be the source of problems, but I think this should be co...

ArndW I tried some other numbers, all pretty bad, the worst I found in my short testing was this one 10234.5683 I am sure there are worse ones, however if you assign a float to this value and then display the result, it is 10234.6. This is an error of 0.0317 I also tried to do some Math with FLOAT2D...

I shall make no comments about the application (I didn't write it). You say the best solution if you have a float input is to leave it as a floating point number However this is what I am doing when I get the 0.0022 error. It is actually better when I take the Float and convert it to Numeric; error ...

Well the first thing is we are a Bank and therefore we are looking to get a good representation of the number. I guess we do accept that with a Float we are not going to get and exact number all the time, but I just think the difference is too great. The difference between the entered value and the ...

Is anybody else getting unexplained results from Floats? We have a database with Floats in it and we are finding difficult to get any consistent results. We have generated a test case and I will explain the results we are getting. Basically we are generating 1 row of data then hard coding a Float an...

I think the 1st part has been answered before, only Solaris on Sun platforms are supported.

I had a few problems with the old solution, and I found a better way. There appears to be a new function DFloatToStringNoExp, this converts to string. doesn't give you an exponential and allow you you have control over the number of decimal places. DFloatToStringNoExp(DSLink2.FLOAT2DECI,6) I sure pe...

Thanks guys this work a treat.

I set the return code = no.
Also my Stored Procedure just returns a result set, so the Stored Procedure Parameters were left blank.