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,

Probably because &CATAGORY. How is that being passed? Might need to be in quotes.

Nevermind... &CATEGORY was null.