Archives of the TeradataForum

Message Posted: Fri, 30 May 2003 @ 18:39:58 GMT

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

<-- Anonymously Posted: Friday, May 30, 2003 14:31 -->

I differentiate between Teradata RDBMS and Teradata clients BTEQ, queryman, interagate.

In the query

select gross_sales (format '99.');

(some of) the Teradata clients take action based on the format clause, not the Teradata RDBMS. In fact, RDBMS does nothing with the format clause. So, why is the sql WITH THE FORMAT sent to the Teradata RDBMS? and what exactly does the RDBMS do with the format clause? ignore it? just syntax check it?

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