Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 30 Jun 2003 @ 15:14:02 GMT


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


Subj:   3707 Error Message
 
From:   Fuller, Joe

Hello List,

I thought to go to the experts on this rather perplexing problem.

I have a view that was created using some fairly complex SQL. I tested the SQL and it works perfectly as straight SQL in both QueryMan (Teradata SQL Assistant) and in BTEQ (Unix, Windows). So, I created the view Revenue_By_Bill_Cycle AS with the tested SQL. When I execute a query against the view, with or without a WHERE clause I get the following error:

3707 Syntax Error, expected something like an 'OR' keyword or ')' or ',' between a string and "'||'".

Now I don't have the double bars ANYWHERE in the SQL! The view is created successfully as well. Any ideas?

I am running V2R5.

Best Regards,

Joe Fuller
Sr Data Warehouse Consultant, DBA
Teradata Professional Services

Advanced Teradata Certified Professional
Teradata Certified Designer



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2014 - All Rights Reserved    
Last Modified: 10 Jun 2014