1. Forum
  2. Usenet
  3. COMP.DATABASES.IBM-DB2

  • Overflow on SUM of a column defined as INT

    From phillip.thomson01@gmail.com@21:1/5 to All on Mon Jun 18 11:13:58 2018
    I know this is an old thread, but I just ran into this. Wrapping the column in bigint solved it.

    SELECT
    SUM(BIGINT(COLUMNNAME))
    FROM TABLE.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)