Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Syntax error at or near WHERE clause
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Syntax error at or near WHERE clause
 Login/Join
 
Platinum Member
posted
Hi Folks,

Can anyone spot the syntax error here? WF is saying that I have a syntax error at or near line 42. Line 42 is the second WHERE clause.

Sigh...

TABLE FILE FS_OCCS_PERSONS_UCRS
BY FS_OCCS_PERSONS_UCRS.FACT_PERSON.PERSON_SOURCE_KEY
BY FS_OCCS_PERSONS_UCRS.DIM_UCR.CATEGORY
WHERE DB_INFILE(PEEPS_W_VIO, PERSON_SOURCE_KEY, PERSON_SOURCE_KEY);
WHERE FS_OCCS_PERSONS_UCRS.DIM_UCR.CATEGORY NE &CATEGORY;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLEMBEDIMG ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/enwarm.sty,
$
ENDSTYLE
END

Let me know if you want to see the whole procedure. The whole thing is only 53 lines.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 161 | Registered: May 19, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Probably because &CATAGORY. How is that being passed? Might need to be in quotes.
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Nevermind... &CATEGORY was null.


WebFOCUS 8201, SP 0.1, Windows 7, HTML
 
Posts: 161 | Registered: May 19, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Syntax error at or near WHERE clause

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.