Archives of the TeradataForum

Message Posted: Wed, 09 Aug 2006 @ 15:45:16 GMT

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

<-- Anonymously Posted: Friday, August 04, 2006 22:13 -->

Glad we found a reason why the comparison succeeded. May be it's the same reason for below error too.

     ---
     BTEQ -- Enter your DBC/SQL request or BTEQ command:
     ct test(ch varchar(10));

     ct test(ch varchar(10));

      *** Table has been created.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     ins test('abc');

     ins test('abc');

      *** Insert completed. One row added.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your DBC/SQL request or BTEQ command:
     ins test('abc  ');

     ins test('abc  ');
      *** Failure 2802 Duplicate row error in odbc.test.
                     Statement# 1, Info =0
      *** Total elapsed time was 1 second.

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