The TeradataForum depends on cookies for its operation. Please refer to our Privacy page for details. By closing this banner or continuing to browse the TeradataForum website, you agree to the use of cookies.

Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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>  
Next> Last>>  
  Top Home Join Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 31 Dec 2015