[IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "case" was found following "else

[learn_SAS_23]

Dear Team, 

a

am getting below error : 

ERROR: CLI describe error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0104N An unexpected token "case" was found following "else
rstf.END_TS end". Expected tokens may include: "FROM". SQLSTATE=42601

[r_behata · Accepted solution]

Looks like Your Case statement Nesting is incorrect . try expanding all the scenarios like this :

case 
	when dt.DATE_TIME_KEY+900 < rstf.END_TS then 
                            dt.DATE_TIME_KEY+900
	when dt.DATE_TIME_KEY+900 > rstf.END_TS then rstf.END_TS 
	when dt.DATE_TIME_KEY > START_TS then dt.DATE_TIME_KEY
	when dt.DATE_TIME_KEY < START_TS then rstf.START_TS
end 

[learn_SAS_23]

Thanks, for finding it

[Tom]

In addition to your messed up CASE statement (statements?)  are you really trying to SUM() dates?  

What is in the variables DATE_TIME_KEY, END_TS and START_TS ?