Error during DB2 compilation SQLSTATE=42601

dineshsjce · New User Joined: 16 Apr 2007 Posts: 41 Location: Bangalore

Hi I got the following error while compiling a DB2 program . What is the solution ?

An unexpected token "UNION SELECT
'Y' " was found following "FF_DT > CURRENT
DATE". Expected tokens may include: "<space>".
SQLSTATE=42601

AND
my query looks like this

SELECT 'Y'
INTO :WS-FUTURE-EXIST-SW
FROM CON01_CUST_CNTCT
WHERE
AID_CD = :WS-AID-CD-ONLY
AND CNTCT_EFF_DT > CURRENT DATE
UNION
SELECT 'Y'
INTO :WS-FUTURE-EXIST-SW
FROM CON01_CUST_CNTCT
WHERE
AID_CD = :WS-AID-CD-COMP
AND CNTCT_EFF_DT > CURRENT DATE

priyamnavada · New User Joined: 24 Dec 2005 Posts: 52 Location: hyderabad

i think declarion of WS-AID-CD-COMP was not done properly.