Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: MOd function in view
 
From:   Dieter Noeth

Rachana Agarwal wrote:

  But when I create a view on this select, it fails :-  


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


  Syntax error : expected something between the select keyword and the mod keyword.  



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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023