|
Archives of the TeradataForumMessage Posted: Wed, 02 Apr 2003 @ 16:59:30 GMT
Code = 2616. 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
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||