Search result title:
PH32779: COLUMN NAME SQLVAR, LENGTH 173710678 TYPE DOES NOT MATCH THE ERROR RUNNING BUCKET TESTS (Community support)

2 April 2021
Search result summary: DB2 is returning type INTEGER for SUM function, whereas SQL Engine is returning the type of SUM as BIG INTEGER.
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PH32779

Search result title:
Why DB2 returns inaccurate SUM result on double column? (Community support)

16 June 2018
Search result summary: Why the last query retruns +6.60619999999999E+002 instead of +6.60620000000000E+002? $ db2 "create table tmp_day_act( avge_amount double)" $ db2 "insert into tmp_day_act values(-1020)" $ db2 "insert into tmp_day_act values(-19053.67)" $ db2 "insert into tmp_day_act values(29869.35)" $ db2 "insert into tmp_day_act values(-258.62)" $ db2 "insert into tmp_day_act values(-8876.44)" $ db2 "select sum(avge_amount) from tmp_day_act" 1 ------------------------ +6.60619999999999E+002
Search result URL: Search result URL: https://www.ibm.com/support/pages/node/277757

Search result title:
Why DB2 returns inaccurate SUM result on double column? (Community support)

23 February 2020
Search result summary: Why DB2 returns inaccurate SUM result on double column?
Search result URL: Search result URL: https://www.ibm.com/support/pages/node/3286755

Search result title:
PQ55858: WHEN MSGDSNT404I SQLCODE = 802 IS ISSUED, TIVOLI PR ISSUED NO REPORT. (Community support)

4 August 2002
Search result summary: When the sql provied by DRL150.SDRLRJPN member DRLQIT01, VALUE((SUM(MSGQ_RESPONSE_SEC)/SUM(MSGQ_RESPONSES)), 0) is used,
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PQ55858

Search result title:
DB2 madhubcreate issue (Community support)

16 June 2018
Search result summary: MADHUBCREATE does not work throwing the following error: ERROR ODBC [S1000] [InitiateSystems][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]CANNOT CREATE INDEX; SUM OF INTERNAL LENGTHS OF COLUMNS > ALLOWABLE MAX. MPI_STRANON1 (DBError=-614)
Search result URL: Search result URL: https://www.ibm.com/support/pages/node/471831

Search result title:
Can I use the SUM column function on a character field? (Community support)

16 June 2018
Search result summary: I have a sizing field consisting of numeric data imbedded as part of a character field in SQL/DS. I can select the sizing field using the SUBSTR function, but I cannot summarize the sizings in that column because DB2® QMF says it is character data. Is there a way I can use the select statement to convert the character data to numeric data? I tried the REXX functions C2D and VALUE, but neither worked.
Search result URL: Search result URL: https://www.ibm.com/support/pages/node/657373

Search result title:
Statement contains too many table names (Community support)

15 June 2018
Search result summary: Error [IBM][cli client][db2] sql0129n The statement contains too many table names. The maximum number is 15. SQLSTATE=54004 This error occurs when you click on the SUM button. You are accessing a DB2 database on AS/400.
Search result URL: Search result URL: https://www.ibm.com/support/pages/node/105123

Search result title:
PI51255: DB2 ADMIN TOOL IMPORT DDL WITH SUM(LENGTH OF COLUMNS) > 32K GIVING ADB7350E (Community support)

5 April 2016
Search result summary: IMPORT DDL with this table definition (SUM(LENTH of COLUMNS) > 32K):
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PI51255

Search result title:
PM43780: INCORROUT WHEN USE OPTIMIZATION HINT FOR THE QUERY WITH GROUP BY AND COLUMNS IN GROUP BY ALSO HAVE EQUAL PREDICATE (Community support)

3 October 2011
Search result summary: For this query: SELECT SUM(C3), C2 FROM T1
Search result URL: Search result URL: https://www.ibm.com/support/pages/apar/PM43780

Search result title:
SQL0802N might happen for SUM() function in specific SQL statements with DB2 V11.1 (Community support)

16 June 2018
Search result summary: Db2 might return the error, "SQL0802N Arithmetic overflow or other arithmetic exception occurred. SQLSTATE=22003" while executing sum() function in V11.1 where it does not in V10.5.
Search result URL: Search result URL: https://www.ibm.com/support/pages/node/300733