Archives of the TeradataForum

Message Posted: Fri, 07 Sep 2007 @ 15:49:45 GMT

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

Scenario:

When math is done on TIMESTAMP data i.e.(TIMESTAMP - TIMESTAMP = result), you get and error . Query assistant and ODBC handle this error, include it in the reply and then give you the data you requested.

Business Objects does not give you the return because it traps the return error and stops right there, responding with "Unsupported Datatype", because the returned value is an interval datatype. The near term answer is to cast the entire answer set to char(22) to get rid of the error and allow for all positions in the interval that might have data.

So the working, if simplistic Query (for Business Objects) is:

     select cast(tmstp - tmstp day(4) to second(6)) as char(22))
     from view_db sample 10

The longer term answer for Business Objects would be to accommodate the datatype natively, and is probably a bug fix in some patch version.

We worked this out with our Teradata guys here. Thanks to Bill for the heavy lifting.

Thanks for all your help in the forum

Richard Terry

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