Oninit cdi / Archive
Talk to an expert →

MOD function for INT8

Posted in 2007

Topics: Platform-Specific Issues, Versions, Editions & End-of-Life

ANDREW SVIKHNOUSHIN — — source: IIUG Forums & Mailing Lists

Have some strange result: SELECT MOD(source, 4294967296) FROM some_table always returns 0 regadless of source value, where source is INT8 with values more than 4294967296, 4294967296 is MAX_UINT If I replace 4294967296 with 4294967295 or 4294967297, it works right. I use IDS 9.40 UC2 on Suse Linux 9.2 -- Andrew Svihnushin Email: san@inist.ru Software developer, INIST Ltd.

↪ replying to ANDREW SVIKHNOUSHIN
ART KAGEL, BLOOMBERG/ 731 LEXIN — — source: IIUG Forums & Mailing Lists

Try: SELECT MOD(source, CAST(4294967296 AS INT8)) FROM some_table; Art S. Kagel ----- Original Message ----- From: Andrew Svikhnoushin <ids@iiug.org> At: 3/28 2:35:42 Have some strange result: SELECT MOD(source, 4294967296) FROM some_table always returns 0 regadless of source value, where source is INT8 with values more than 4294967296, 4294967296 is MAX_UINT If I replace 4294967296 with 4294967295 or 4294967297, it works right. I use IDS 9.40 UC2 on Suse Linux 9.2 -- Andrew Svihnushin Email: san@inist.ru Software developer, INIST Ltd. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary