Here is a snippet of code I used in a report that ran smoothly:
((b.REC_CHNG_CD IN ('A','C') and
(a.LN_BA > 0 and
&elapse >=0 ) and
(a.iv_id not like 'Z%' or
a.iv_id not like 'A%') and
b.hz_ins_co_cd in ('NEWLN','MAINT','')));
I have another report that is very similar although some of the fields are different. It seems pretty straight forward but I am getting
((d.REC_CHNG_CD IN ('A','C') and
(a.LN_BA >0 and
d.LN_HAZARD_TABLE_FG = 'N' and
(a.ix_id not in('Cx2','d01','f10','Z55') or
a.iv_id not like 'F%') and
(a.PR_TYPE_CD not in('C','3') and
b.ins_co_cd in ('NEWLN','MAINT','')));
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, ), *, **, +, -, /, <, <=, <>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ,
EQT, GE, GET, GT, GTT, IN, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ^, ^=, |, ||, ~, ~=.
ERROR 76-322: Syntax error, statement will be ignored.
