BigInt Problem

[poonam12]

Hi All,
I have a problem when dealing with bigint values. In my job in a transformer when itry to assign eighteen 9's i.e 999999999999999999 to a BigInt(19) field it rounds the value to 2808348671. How can i pass the original value to output as i could not find any explicit type conversion function. Code isl ike
if length(field)>18 Then 999999999999999999 else field value

so when it reaches the first branch only then there is a problem

[dhanashreepanse]

Hi
Which stage are you using before and after the transformer?
What is the nullability set for that field at the input and output?

[ArndW]

What datatype is "field"? Perhaps it is your "if" construct that isn't working. What happens when you explicitly set a bigint(19) to all those 's?

[ray.wurlod]

The largest permissible BigInt (int64) value is 9,223,372,036,854,775,807 (2^63-1) in a twos-complement machine. This has 19 digits.

Therefore nineteen "9" characters is not a legal BigInt.

You need to re-think your logic.

Does this "rounding" happen only in View Data, or are you writing the result out to a file or a Peek event? If it is happening only in View Data then the data browser may be treating BigInt as Int.

[poonam12]

I used following code:
StringToDecimal('999999999999999999')

Now it was not rounded up and correct value was passed.Thanks for your help.

[ray.wurlod]

That value only has eighteen "9" characters and is therefore legal as a BigInt.

[poonam12]

[quote="ray.wurlod"]That value only has eighteen "9" characters and is therefore legal as a BigInt. ...[/quote]

Yeah thats write but if you pass it directly in a BigInt field it is rounded to int32 value by datastage. To retain this value,it need to be passed
1) as a character field
2) using the function StringToDecimal while passing to a BigInt value