Problem displaying BigInt

[stormtrooper]

Using DB2 v8 and CR9 I am having trouble displaying a BigInt field. The values range from 1 to an 11 digit number. It will only display approx. up to the 1.8 million point and nothing larger. Would this be a formula problem or an actual driver issue with CR9?

Please advise.

Thanks.

 

[stormtrooper]

Here's some more information. I have all the latest drivers and hotfixes installed. The field to be displayed has always been a BigInt. The only recent change to the data in the field is that another 4 digits have been added in front. That is, the data before the change displays eventhough the field is a BigInt. The data after the change does not.

eg.

1708220 will display
1001849006 will display
10006090040 will not display

Thanks.

 

[Ngolem]

this is obviously too large a number.

Perhaps using an SQL expression (toChar) you can convert the number to a string...then break up the string and use the pieces in subsequent calculations...just a thought.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[stormtrooper]

Discovered this work around just before you posted

Thanks Anyway