Archives of the TeradataForum
Message Posted: Tue, 04 Sep 2001 @ 19:40:09 GMT
I have just recently joined this group but it has already helped me a lot in solving some issues. Right now I am experiencing some problems with Teradata which I don't know how to solve.
The situation is following: I am connecting with one application through ODBC to the Teradata database from an Win NT server and trying to load the data. The application is something like "ETL Tool" which acts as a specialised interface between Data Sources and target aplication (these applications are Bancware Insight (ETL) and Bancware Convergence).
In some cases (for certain Data Mart views which are not different from the others) I get these errors:
22003[NCR][TDATA DLL] Numeric data precision will be lost
37000[NCR][Teradata RDBMS] Syntax error, expected something like a 'SELECT' keyword between the beginning of text and the Integer.
When we sent this problem to NCR support they gave us this answer:
I have used ODBC driver v.2.06.00.00 so I have installed the ODBC driver v.2.08.01.00 but it seems that it did not solve the problem in all the cases but it has helped in most of them (right now I am trying to use the supposed solution - no results so far) .
But this is not the right solution, because the regional settings were English US already. I am really unable to find any solution, and the error is appearing without any reasonable condition - for example, the same table I am not able to load for 2 times, the third time it does load the data and then again not.
I have also not find any relations btw. The tables that were loaded successfully and those that were not.
Has anybody from you experienced similar problems? If yes, please let me know and advise me with your solution. Thanks a lot in advance for your advice.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|