Archives of the TeradataForum

Message Posted: Wed, 02 Apr 2003 @ 16:59:30 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Code = 2616.
2616: Numeric overflow occurred during computation.
Output directed to Answer set window

I have several numeric fields that are computed and then inserted into a table. The destination table has the numeric columns defined with the pre-computed columns definition from the select (integer, decimal(10,2), smallint, etc.).

The odbc trace returned the following.

Is there a way from the below to tell which column and/or value is causing the query to blow up?

                DIAG [22003] [NCR][ODBC Teradata Driver][Teradata RDBMS]
Numeric overflow occurred during computation.  (-2616)

queryman        658-2d8 ENTER SQLErrorW
                HENV                00000000
                HDBC                00000000
                HSTMT               015D16D8
                WCHAR *             0x0012F188 (NYI)
                SDWORD *            0x0012F1FC
                WCHAR *             0x0012ED88
                SWORD                      512
                SWORD *             0x0012F202

queryman        658-2d8 EXIT  SQLErrorW  with return code 0
(SQL_SUCCESS)
                HENV                00000000
                HDBC                00000000
                HSTMT               015D16D8
                WCHAR *             0x0012F188 (NYI)
                SDWORD *            0x0012F1FC (-2616)
                WCHAR *             0x0012ED88 [      90] "[NCR][ODBC
Teradata Driver][Teradata RDBMS] N"
                SWORD                      512
                SWORD *             0x0012F202 (90)

Thanks,

Bruce

	<Prev	Next>		<<First	<Prev	Next>	Last>>