RE: Conversion of large numbers Daniel W Heichel 3.Sep.14 08:39 PM Lotus Notes Connector for ODBC LEI - All ReleasesWindows
That IS an odd issue. I don't have a Sybase installation to test with, but I ran a test pushing those numbers you posted from DB2 -> ODBC -> LEI -> Notes Numeric fields, and they transferred normally. What this proves is that the length is not an issue from a Notes standpoint - that's within the range of what a Notes numeric field can handle.
What kind of LEI activity are you running to transfer this data?
What ODBC driver are you using?
Do you see this problem with long integers in other fields, or is it just this one particular field?
Is there any other code that runs on the Notes side? Some prime examples: Is it a computed field, do you have Enforce Form Design set, do you have anything set in the Data Transformation tab of the Notes Connection Document; are there agents or other entities that run against this data?
Hopefully investigation into these concerns will reveal what is modifying the data, because it should not be happening in Notes by default.