Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 08:56:00 GMT

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

Subj:   Re: Retailers only---GTIN length changes
From:   Dieter Nöth

Yonina Schuchman wrote:

  We have a similar issue with debit card numbers. I'm not sure what the time frame is for those numbers to expand past 18 digits. Decimal(18,0) served us well aside from the truncating 18th digit that occurred with various releases.  

This is mainly an ODBC issue, because there's no bigint in ODBC. It's converted to float, that's why the last 1 or two digits are wrong. Run the same select using BTEQ and it's ok.


  <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: 28 Jun 2020