CREATE table Work.PCGT1 AS 5705 SELECT 5706 POLICY_NUMBER, 5707 Sum(POLICY_COUNT) AS POLICY_COUNT, 5708 FROM WORK.BLCCRF ____ 22 ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, FROM, GE, GET, GT, GTT, LE, LET, LIKE, LT, LTT, NE, NET, OR, ^=, |, ||, ~=.
5709 GROUP BY POLICY_NUMBER _____ 22 76 ERROR 22-322: Syntax error, expecting one of the following: a quoted string, !, !!, &, *, **, +, ',', -, /, <, <=, <>, =, >, >=, ?, AND, AS, BETWEEN, CONTAINS, EQ, EQT, FORMAT, FROM, GE, GET, GT, GTT, IN, INFORMAT, INTO, IS, LABEL, LE, LEN, LENGTH, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, TRANSCODE, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
5710 HAVING POLICY_COUNT > 1 5711 ;
I'm having trouble debugging this simple program. And for some additional information the Work.BLCCRF table does exist and has been referenced in previous blocks of code that ran fine. And every field that I'm calling is spelled correctly. What seems to be the problem?
... View more