Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Numeric overflow when inserting
 
From:   Burton, Bruce

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023