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