Hi,
I am trying to run the following query, is giving me an error saying "missing right paranthesis" on the line where the SWITCH is. I couldn't figure out error, please help. Please treat this a urgent.
Thanks
SELECT Unique (ETA.CLNT_ID),
TC.CLNT_FNAME,
TC.CLNT_LNAME,
TC.CLNT_DOB,
LG.GENDER_NAME,
RACE_NAME,
ETA.ACCEPTED_DT,
ETA.TERMINATED_DT,
Switch(FS1.FUNDING_SRC_ID = '17','S')
FROM APPLICATION.T_ET_ASSESSMENT ETA,
APPLICATION.T_ET_ASMT_FUNDING_SOURCES FS1,
APPLICATION.T_CLIENT TC,
APPLICATION.L_GENDER LG,
APPLICATION.T_CLIENT_RACE TR,
APPLICATION.L_RACE LR
WHERE TC.CLNT_ID = ETA.CLNT_ID
AND TC.CLNT_ID = TR.CLNT_ID
AND TC.CLNT_ID = TR.CLNT_ID
AND ETA.ET_ID = FS1.ET_ID
AND TC.CLNT_GENDER = LG.GENDER_ID
AND TR.RACE_ID = LR.RACE_ID
AND TC.CLNT_DOB < to_date ('1992/01/01','yyyy/mm/dd')
AND (ETA.TERMINATED_DT > to_date ('2004/12/31','yyyy/mm/dd') OR ETA.TERMINATED_DT is null)
AND ETA.ACCEPTED_DT < to_date ('2006/01/01','yyyy/mm/dd')