Archives of the TeradataForum

Message Posted: Thu, 17 Feb 2005 @ 16:11:20 GMT

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

Rachana Agarwal wrote:

          create view bazzee.test  as
          select mod(10,3) tt

This is ODBC SQL (and SQL:2003), but not Teradata:

     ODBC Driver for Teradata User Guide
     Chapter 4: ODBC Application Development
     ANSI SQL 1992 Syntax
     Scalar Functions

The ODBC drivver replaces those ODBC functions with equivalent syntax in Teradata SQL, but only for plain selects.

Uncheck "Allow use of ODBC SQL Extensions in queries" in Queryman - Tools - Options, use "10 mod 3" and your query will run without any problems.

Dieter

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