Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 30 Aug 2007 @ 22:57:44 GMT


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


Subj:   ODBC TIMESTAMP math problem (datatype - or ANSI Date Time error)
 
From:   Richard Terry

Teradata 06.01.0143 V2R

Ok I have been struggling with this one for a week now ..

Queries that succeed in TD SQL Assistant seem to fail in Business Objects XI R2 SP2. Simple queries work fine in all of them .. it's only when I do a subtraction of two TIMESTAMP fields that anything has a problem ..

I've tried the casting and things like suggested in the while papers on Time.Date and timestamp..

They yield an invalid data type message

As usual the BO support folks are pointing at the ODBC driver for TD and saying it isn't their fault..

Any help would be appreciated !!!

Query:

     SELECT (FEDX_FPOS_PROD_VIEW_DB.pos_transaction.TRAN_END_TMSTP -
     FEDX_FPOS_PROD_VIEW_DB.pos_transaction.handled_tmstp day(4) to second(6))
     FROM FEDX_FPOS_PROD_VIEW_DB.pos_transaction

1) Works in TD SQL Assistant (About says: 7.1.0 English October 12, 2005) on Desktop

2) Failed with the following Error message in Desktop Business Object s - defined beneath error message:

     Exception: DBD, [NCR][ODBC Teradata Driver][Teradata Database] Invalid
     operation on an ANSI Datetime or Interval value. State: HY000

     Desktop driver version PC based ODBC:
     BusinessObjects Configuration :
     Version : 11.5..826.826
     Network Layer : Teradata
     DBMS Engine : Teradata V2 R6
     Language : en
     Charset : CP1252
     Library : C:\Program Files\Business Objects\BusinessObjects Enterprise
     11.5\win32_x86\dataAccess\connectionServer\dbd_wtdodbc.dll
     SBO : C:\Program Files\Business Objects\BusinessObjects Enterprise
     11.5\win32_x86\dataAccess\connectionServer\teradata\teradata.sbo
     RSS : C:\Program Files\Business Objects\BusinessObjects Enterprise
     11.5\win32_x86\dataAccess\connectionServer\teradata\teradata.rss
     PRM : C:\Program Files\Business Objects\BusinessObjects Enterprise
     11.5\win32_x86\dataAccess\connectionServer\teradata\teradata.prm
     Strategies : C:\Program Files\Business Objects\BusinessObjects
     Enterprise
     11.5\win32_x86\dataAccess\connectionServer\teradata\teradata.stg
     Middleware and DBMS Configuration :
     Charset : UCS2
     Driver version :  3.05.00.00
     Driver API level : 03.52
     ODBC Manager version : 03.52.1117.0000
     ODBC Manager API level : 03.52.0000
     DBMS name : Teradata
     DBMS version : 06.01.0143  V2R
     3)      Fails with a similar ODBC message on the Linux web based
     Business Objects query
     Linux Driver version (Linux Client)
     Enter SQL string:
     -sh-3.00$ /usr/odbc/samples/C++/adhoc
     Enter Data Source Name[coop_0]:
     Enter userId: xxxxx
     Enter password: xxxxx
     ...ODBC connection successful.
     ODBC version        = -03.52.0000-
     DBMS name           = -Teradata-
     DBMS version        = -06.01.0143  V2R-
     Driver name         = -tdata.so-
     Driver version      = - 12.00.00.00-
     Driver ODBC version = -03.51-
     Enter SQL string:

Richard Terry
Technical Advisor
Marketing Technical Administration



     
  <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: 15 Jun 2023