Archives of the TeradataForum

Message Posted: Tue, 04 Sep 2001 @ 19:40:09 GMT

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

Hi everybody,

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:

22003:
Probable Cause:
The ODBC Driver does not support > then 15 digit numbers with numeric data-types.

Solution:
To avoid the above error you can Cast the column that has 18 digits to Decimal(15,0). You can either do: select columname (decimal (15,0) or cast (columname as decimal (15,0)).

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) .

37000:
Probable Cause:
Regional settings are set to something other than English US.

Solution:
Set the regional settings for NT to US English.

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.

Igor Matejov
Bratislava
Slovak Republic

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