Bigint comparision in DataStage 7.1

s_boyapati · Post by **s_boyapati** » Fri Jul 16, 2004 7:07 am

Hi Guys,
Anyone has idea that how to compare two bigint numbers. for example (x = y), both x and y bigint with 20 digits. even if both are equal it is not resulting true. How can I solve this?

Sree

ray.wurlod · Post by **ray.wurlod** » Fri Jul 16, 2004 4:07 pm

1. Change your configuration so that the EXACTNUMERIC parameter is rather more than 20. It can be as high as 57.

2. Use the Compare function. Look for it in on-line help or in the BASIC manual or in TCL-level help (HELP BASIC COMPARE).

3. Use subtraction and check for a zero result.

4. Use string-math subtraction (SSUB). You can compare million digit "numbers" with these functions. Again, check for a zero result. Look for SSUB in the BASIC manual or in TCL-level HELP.

roy · Post by **roy** » Sun Jul 18, 2004 12:51 pm

Hi,
As Ray pointed your best way to compare them is using character comparison.
We found that there is a problem when writing to a sequential file numbers with more then 15 digits (any more means the least siginificant ones are zeroed (hash files works fine).
Alas using the EXACTNUMERIC doesn't work for now.
We have an open case with ascential regarding big numbers and it is being worked on, hopefully they'll have it fixed soon.
a workaround for having seq files with the acual big number is to use a transformer and change the data type to char(20).

IHTH,